Re: Live steraming replication setup issue!

[Ashish Chauhan <Ashish.Chauhan@xxxxxxxxxxx>]

I am using Postgres 9.4.

 

I removed /etc/Postgres/9.4/main directory from DR server and fetching data through below pg_basebackup command but no luck.

 

sudo -u postgres pg_basebackup -h <slave server ip> -D /var/lib/postgresql/9.4/main -U postgres -v –P

 

Do I need to enable these two parameters in slave server? archive_mode = on and archive_command = some command?

 

Biggest issue is, replication running between master and slave and I need to build DR from slave server.

 

Thanks,

Ashish

 

From: Venkata Balaji N [mailto:nag1010@xxxxxxxxx]
Sent: Thursday, February 18, 2016 3:45 PM, 15:45
To: Ashish Chauhan
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Live steraming replication setup issue!

 

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?

 

 

Steps are pretty much similar. You can setup replication between slave and DR by using the backup of Master database + WAL archives (if available) and setup primary_conninfo to point to slave database in recovery.conf on DR. 

Can you please let us know which version of postgresql you are using ? Thats important for us to make any suggestions.

 

Regards,

Venkata B N

 

Fujitsu Australia