Re: [GENERAL] postgres standby won't start

2015-10-08 Thread Adrian Klaver
On 10/08/2015 08:27 AM, Ramalingam, Sankarakumar wrote: Yes it is and Yes I do have the recovery file. I would suggest you and the other folks involved take a look here: http://www.postgresql.org/docs/9.4/interactive/warm-standby.html It will go a long way to explaining what you are seeing a

Re: [GENERAL] postgres standby won't start

2015-10-08 Thread Ramalingam, Sankarakumar
- 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

Re: [GENERAL] postgres standby won't start

2015-10-08 Thread Adrian Klaver
n it that points to that location? 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] postgres standby won&

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Ramalingam, Sankarakumar
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

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Ramalingam, Sankarakumar
@postgresql.org Subject: Re: [GENERAL] postgres standby won't start On 10/07/2015 01:30 PM, Ramalingam, Sankarakumar wrote: > Hello Adrian, > Can I use this command so that all the data is streamed directly to the > target. Target is pretty much unusable now. Should I get rid of all

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Adrian Klaver
On 10/07/2015 01:30 PM, Ramalingam, Sankarakumar wrote: Hello Adrian, Can I use this command so that all the data is streamed directly to the target. Target is pretty much unusable now. Should I get rid of all items under my $PGDATA and leave the empty before doing the following? pg_basebackup

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Ramalingam, Sankarakumar
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:

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Ramalingam, Sankarakumar
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

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Adrian Klaver
: Ramalingam, Sankarakumar; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres standby won't start On 10/05/2015 12:35 PM, Ramalingam, Sankarakumar wrote: Thanks Adrian. My primary is doing fine. Only the standby. I am noticing it after a while..my Bad!! Primary se

Re: [GENERAL] postgres standby won't start

2015-10-07 Thread Ramalingam, Sankarakumar
: [GENERAL] postgres standby won't start On 10/05/2015 12:35 PM, Ramalingam, Sankarakumar wrote: > Thanks Adrian. > > My primary is doing fine. Only the standby. I am noticing it after a > while..my Bad!!

Re: [GENERAL] postgres standby won't start

2015-10-05 Thread Adrian Klaver
On 10/05/2015 12:35 PM, Ramalingam, Sankarakumar wrote: Thanks Adrian. My primary is doing fine. Only the standby. I am noticing it after a while..my Bad!! Primary setting #-- # REPLICATION #---

Re: [GENERAL] postgres standby won't start

2015-10-05 Thread Ramalingam, Sankarakumar
: 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

Re: [GENERAL] postgres standby won't start

2015-10-05 Thread Adrian Klaver
On 10/05/2015 10:53 AM, Ramalingam, Sankarakumar wrote: 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

Re: [GENERAL] postgres standby won't start

2015-10-05 Thread Andreas Kretschmer
Ramalingam, Sankarakumar wrote: > 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 E

[GENERAL] postgres standby won't start

2015-10-05 Thread Ramalingam, Sankarakumar
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