From: | Ashish Chauhan <Ashish(dot)Chauhan(at)support(dot)com> |
---|---|
To: | Venkata Balaji N <nag1010(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Live steraming replication setup issue! |
Date: | 2016-02-18 23:54:52 |
Message-ID: | 6837D32772C03D42BF09864A2DACFF9B1D2E883E@dcmail02.supportsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com]
Sent: Thursday, February 18, 2016 3:45 PM, 15:45
To: Ashish Chauhan
Cc: pgsql-general(at)postgresql(dot)org
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
From | Date | Subject | |
---|---|---|---|
Next Message | CS DBA | 2016-02-19 00:44:21 | Exporting a PDF from a bytea column |
Previous Message | Venkata Balaji N | 2016-02-18 23:45:17 | Re: Live steraming replication setup issue! |