Re: [GENERAL] Live steraming replication setup issue!

2016-02-23 Thread Ashish Chauhan
:01.612415 | -2 Thanks, Ashish From: Venkata Balaji N [mailto:nag1...@gmail.com] Sent: Sunday, February 21, 2016 2:14 AM, 2:14 To: Ashish Chauhan Cc: Andreas Kretschmer; pgsql-general@postgresql.org Subject: Re: [GENERAL] Live steraming replication setup issue! On Fri, Feb 19, 2016 at 6:24 PM

Re: [GENERAL] Live steraming replication setup issue!

2016-02-22 Thread Venkata Balaji N
On Tue, Feb 23, 2016 at 10:02 AM, Ashish Chauhan wrote: > Thanks Venkata, I am able to setup replication now. Just wondering when I > check replication_delay and lag, I am getting negative number, any idea why? > > > > receive|replay| replication_delay | lag > > --+---

Re: [GENERAL] Live steraming replication setup issue!

2016-02-21 Thread Venkata Balaji N
On Fri, Feb 19, 2016 at 6:24 PM, Ashish Chauhan wrote: > Below is recovery.conf on slave > > > #--- > # STANDBY SERVER PARAMETERS > > #--- > # > # standb

Re: [GENERAL] Live steraming replication setup issue!

2016-02-19 Thread Ashish Chauhan
6 5:11 PM, 17:11 To: Ashish Chauhan; pgsql-general@postgresql.org Subject: Re: [GENERAL] Live steraming replication setup issue! > Currently we have master -> slave -> DR hot standby streaming > replication in current prod environment. Between master and slave > server rep

Re: [GENERAL] Live steraming replication setup issue!

2016-02-19 Thread Ashish Chauhan
: pgsql-general@postgresql.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

Re: [GENERAL] Live steraming replication setup issue!

2016-02-18 Thread Andreas Kretschmer
> 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. > > I

Re: [GENERAL] Live steraming replication setup issue!

2016-02-18 Thread Venkata Balaji N
> > 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 Maste

[GENERAL] Live steraming replication setup issue!

2016-02-18 Thread Ashish Chauhan
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: