Move single server to HA

[mikeonan]

I have a single server setup on the latest FusionPBX. Has anyone moved from single server to a dual server HA with BDR? What steps did you take for the migration? Is there an easy way to uninstall current PostgreSQL and replace with 2ndQuadrant? Any help would be greatly appreciated!

 

[ad5ou]

It could be done on the same server since you can have multiple versions of postgresql running, but is much easier to load existing setup into two or more freshly installed servers.

The advanced class example uses a single server info to load into a 2 newly installed servers.

 

[mikeonan]

It could be done on the same server since you can have multiple versions of postgresql running, but is much easier to load existing setup into two or more freshly installed servers.

The advanced class example uses a single server info to load into a 2 newly installed servers.

Do you happen to know which video goes into detail on that? I must have missed it while watching the latest ones from December 2019.

 

[ad5ou]

No idea on which video. Installing BDR etc is usually on first day of Advanced class. If there are 5 videos for that month, it should be in 4th day.
General steps are:
get a backup of existing system.
Install 2 new servers with custom config settings for fusion
empty database on new servers
build bdr cluster
import schema from backup
import data from backup.