How to migrate data from non-bdr pgsql to bdr pgsql

528 Views Asked by At

I have fusionpbx with simple pgsql working ... Now i have created HA fusionpbx with bdr pgsql and it is working fine but I don't know how to migrate data from non-bdr pgsql to bdr pgsql ...

1

There are 1 best solutions below

0
On

pg_dump worked for me.

pg_dump $non_bdr_db > db.sql
psql $bdr_db < db.sql

Although if you have some fancy extensions (in my case it's PostGIS) you might want to restore the database from the backup first (separately on each and every node of your BDR cluster) and then enable the BDR extension.