break HA and replace secondary node

yaboc

Member
Nov 23, 2017
44
3
8
35
hi,
if i need to switch / replace 2nd node in HA do i just execute

DROP SUBSCRIPTION IF EXISTS fspbx_subscription_b_to_a;
DROP SUBSCRIPTION IF EXISTS fspbx_subscription_a_to_b;

DROP PUBLICATION IF EXISTS fspbx_publication_a;
DROP PUBLICATION IF EXISTS fspbx_publication_b;

on primary server? and re-run
sh /var/www/fspbx/install/setup_logical_replication.sh ? with new server remote ip

and update advanced settings with new ip?

or is it better to backup/restore to fresh and then run replication script?

thanks
y