Live steraming replication setup issue!

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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