| From: | Ashish Chauhan <Ashish(dot)Chauhan(at)support(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Live steraming replication setup issue! |
| Date: | 2016-02-18 21:52:08 |
| Message-ID: | 6837D32772C03D42BF09864A2DACFF9B1D2E867B@dcmail02.supportsoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2016-02-18 22:12:20 | Re: PostgreSQL vs Firebird SQL |
| Previous Message | Melvin Davidson | 2016-02-18 21:11:41 | Re: Multiple databases and shared_buffers |