ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MySQL to PostgreSQL conversion

    Scheduled Pinned Locked Moved IT Discussion
    moodlepostgresqlmysqlmariadbdatabaserelational database
    13 Posts 4 Posters 2.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scottalanmillerS
      scottalanmiller
      last edited by

      Recommends PostgreSQL is one thing. Being worth converting is another. You will need a Moodle-specific converter to do this. There is no generic conversion. As long as MySQL is supported, I would stick with it.

      JaredBuschJ 1 Reply Last reply Reply Quote 2
      • JaredBuschJ
        JaredBusch
        last edited by

        Why worry about moving? Is something not working?

        For example, I have NodeBB setup for one place using Redis and for another using MongoDB.

        I feel no need to migrate anything jsut because of a recommended setup.

        1 Reply Last reply Reply Quote 0
        • JaredBuschJ
          JaredBusch @scottalanmiller
          last edited by

          @scottalanmiller said in MySQL to PostgreSQL conversion:

          Recommends PostgreSQL is one thing. Being worth converting is another. You will need a Moodle-specific converter to do this. There is no generic conversion. As long as MySQL is supported, I would stick with it.

          Downvote for posting before me!

          scottalanmillerS 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @JaredBusch
            last edited by

            @JaredBusch said in MySQL to PostgreSQL conversion:

            @scottalanmiller said in MySQL to PostgreSQL conversion:

            Recommends PostgreSQL is one thing. Being worth converting is another. You will need a Moodle-specific converter to do this. There is no generic conversion. As long as MySQL is supported, I would stick with it.

            Downvote for posting before me!

            Hey man, I gave you fourteen hours 🙂

            JaredBuschJ 1 Reply Last reply Reply Quote 0
            • JaredBuschJ
              JaredBusch @scottalanmiller
              last edited by

              @scottalanmiller said in MySQL to PostgreSQL conversion:

              @JaredBusch said in MySQL to PostgreSQL conversion:

              @scottalanmiller said in MySQL to PostgreSQL conversion:

              Recommends PostgreSQL is one thing. Being worth converting is another. You will need a Moodle-specific converter to do this. There is no generic conversion. As long as MySQL is supported, I would stick with it.

              Downvote for posting before me!

              Hey man, I gave you fourteen hours 🙂

              Game Night > Mangolassi.it (sorry @Minion-Queen)

              1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller
                last edited by

                PostgreSQL and MySQL are the two supported database options. MySQL is very good. There is an article that argues that PostgreSQL is better when you do extra tuning on it and I would guess that this is true, PostgreSQL is the more powerful, robust and advanced of the two. But that isn't the big deal that it sounds like. MySQL is extremely capable and takes less experience and effort to use.

                1 Reply Last reply Reply Quote 0
                • WLS-ITGuyW
                  WLS-ITGuy @coliver
                  last edited by

                  @coliver

                  Yes it is working. Just wasn't sure if it was something that should be considered.

                  coliverC scottalanmillerS 2 Replies Last reply Reply Quote 0
                  • coliverC
                    coliver @WLS-ITGuy
                    last edited by

                    @WLS-ITGuy said in MySQL to PostgreSQL conversion:

                    @coliver

                    Yes it is working. Just wasn't sure if it was something that should be considered.

                    No, if it's working then your configuration is supported. No need to look at moving off of it for the various reasons both @JaredBusch and @scottalanmiller gave.

                    1 Reply Last reply Reply Quote 0
                    • scottalanmillerS
                      scottalanmiller @WLS-ITGuy
                      last edited by

                      @WLS-ITGuy said in MySQL to PostgreSQL conversion:

                      @coliver

                      Yes it is working. Just wasn't sure if it was something that should be considered.

                      Considered, sure. But I would say that unless there is a key feature or a huge specific concern, not to worry about it. This is nearly a six of one, half a dozen of the other scenario from the outset. They are both fully supported for a reason. Both will scale to massive size, both can do high availability, both are free and well known, both have support options, etc.

                      1 Reply Last reply Reply Quote 0
                      • WLS-ITGuyW
                        WLS-ITGuy
                        last edited by

                        Well, that was a thread that will fizzle out quickly 🙂

                        Thanks for the assist all.

                        scottalanmillerS 1 Reply Last reply Reply Quote 1
                        • scottalanmillerS
                          scottalanmiller @WLS-ITGuy
                          last edited by

                          @WLS-ITGuy said in MySQL to PostgreSQL conversion:

                          Well, that was a thread that will fizzle out quickly 🙂

                          Thanks for the assist all.

                          LOL, sometimes that's exactly what you want. This would have been a large, horrible project. Now it's a simple "Oh good, we are all set" 🙂

                          1 Reply Last reply Reply Quote 1
                          • 1 / 1
                          • First post
                            Last post