Switching databases from mysql to postgresql



  • Is there an easy way to migrate FusionAuth from MySQL to PostgreSQL engine?

    We have 2 environments to migrate, because of the DigitalOcean primary key issue, and we're wondering if you did face something like this before.

    I checked FusionAuth docs but there wasn't anything useful for our goal. If there is nothing, can you please tell us what should we take care for to have a successful migration?



  • There is no easy way to do this. You'd have to migrate your configuration, your users and your DNS (if you are standing up a separate system).

    If you have all your configuration as scripts, that should be easy to migrate, otherwise you need to move things over manually.

    You could probably script a retrieve and then add of all the configuration, but there is no 'export all configuration' option.

    For your users, you could do a database dump to get the hashes and do a bulk import. Or if you have developer edition you could set up a slow migration using connectors. The user migration process is broadly documented here: https://fusionauth.io/docs/v1/tech/guides/migration/

    DNS migration is like any other DNS migration.



Looks like your connection to FusionAuth Forum was lost, please wait while we try to reconnect.