postgres standby won't start - Mailing list pgsql-general

From Ramalingam, Sankarakumar
Subject postgres standby won't start
Date
Msg-id C7BCCAFB121E934BA4FE0D9790294D57AD5EB6CB@SPPATLXCHMBX01.servers.global.prv
Whole thread Raw
Responses Re: postgres standby won't start  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: postgres standby won't start  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

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 stream: FATAL:  requested WAL segment 0000000C0000035E000000F0 has already been removed

 

I am unable to start the DB as well.

Should I restore a fresh copy from production on to this standby to make things in order? If yes, how to go about it. I am quite new to Postgres. Any help/suggestions will be greatly appreciated.

 

 

Thanks

Kumar Ramalingam

Global Database Administration

Elavon, Atlanta , GA

 

678 731 5288

 

The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.

pgsql-general by date:

Previous
From: Steve Pribyl
Date:
Subject: Re: BDR Rejoin of failed node, hangs.
Next
From: Andreas Kretschmer
Date:
Subject: Re: postgres standby won't start