Hi I have my standby (streaming replication) down due to missing wal files. You
would see the same error in the logs stating "cannot find the wal file ..."
What is the best way to get it going so that when we switch between standby and
primary once in a while they are in sync?
Currently I am wor
-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Thursday, October 08, 2015 9:31 AM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres standby won't start
On 10/07/2015 10:01 PM, Ramalingam, Sankarakumar wrote:
> Hi Adrian,
> After a few
OG: connection authorized: user=postgres
database=clients
Thanks
Kumar Ramalingam
X6015288
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, October 07, 2015 8:06 PM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] p
Yes target is a standby on another machine. We have two sites (geographically
separated)
Thanks
Kumar Ramalingam
X6015288
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, October 07, 2015 8:06 PM
To: Ramalingam, Sankarakumar; pgsql-general
Thanks
Kumar Ramalingam
X6015288
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, October 07, 2015 1:25 PM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres standby won't start
On 10/07/2015 10:
22
Any ideas?
Thanks
Kumar Ramalingam
X6015288
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, October 07, 2015 1:25 PM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres standby won't start
On
lot for your
invaluable suggestions overall to this forum.
Thanks
Kumar Ramalingam
X6015288
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, October 05, 2015 7:35 PM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re
: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, October 05, 2015 2:18 PM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres standby won't start
On 10/05/2015 10:53 AM, Ramalingam, Sankarakumar wrote:
> We have a standby set up between t
We have a standby set up between two sites in two different locations. The
replication was going on well and suddenly it stopped due to error
2015-09-08 16:07:51 EDT LOG: streaming replication successfully connected to
primary
2015-09-08 16:07:51 EDT FATAL: could not receive data from WAL strea
