Switching from mysql to posgtres

Openfire Openfire Support
#1

Hi,

after running into the nearly common connection issues regarding exceeding the 25 connection limit (switched from hsql to mysql recently) and finding any promising hints on a solution, we consider migrating from MySQL to Postgres.

Is there anything you should take care of besides doing a straight fordward MySQL=>Postgres database migration and changing the connection?

Best,

c.

#2

damokles wrote:

Is there anything you should take care of besides doing a straight fordward MySQL=>Postgres database migration and changing the connection?

I make the switch from mysql to postgres. Pay attention when you convert your mysql sql to pgsql.

In rest all is very simple.