Hi,
Currently we have master -> slave -> DR hot standby streaming replication in current prod environment. Between master and slave server replication running fine. Between slave and DR server replication is broken and I am trying to fix it. For DR server, slave server is master server.
Issue: Few days back, DR was lagging behind slave server and stopped replication. I tried to setup the replication from slave to DR (currently there is replication running from master to slave) with pg_basebackup command, I am able to restart Postgres without any error on DR server but when I try to run any psql on DR, it throwing up below error.
psql: FATAL: the database system is starting up
Slave configuration:
hot_standby = on
listen_addresses = '*'
wal_level = hot_standby
wal_keep_segments = 3000
max_wal_senders = 5
default_statistics_target = 100
maintenance_work_mem = 1792MB
checkpoint_completion_target = 0.7
effective_cache_size = 22GB
work_mem = 144MB
wal_buffers = 16MB
checkpoint_segments = 32
shared_buffers = 7GB
max_connections = 300
DR Server configuration:
listen_addresses = '*'
hot_standby = on
wal_level = hot_standby
default_statistics_target = 100
maintenance_work_mem = 896MB
checkpoint_completion_target = 0.7
effective_cache_size = 10GB
work_mem = 352MB
wal_buffers = 16MB
checkpoint_segments = 32
shared_buffers = 3584MB
max_connections = 300
How do I setup replication between DR server and slave server while slave server and master server are running? I cannot stop master server. Can someone please guide with steps?
Thanks for your help in advance.
Thanks
-Ashish