postgres standby won't start

From: "Ramalingam, Sankarakumar" <Sankarakumar(dot)Ramalingam(at)elavon(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgres standby won't start
Date: 2015-10-05 17:53:08
Message-ID: C7BCCAFB121E934BA4FE0D9790294D57AD5EB6CB@SPPATLXCHMBX01.servers.global.prv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-10-05 18:11:06 Re: postgres standby won't start
Previous Message Kevin Grittner 2015-10-05 15:27:26 Re: md5(large_object_id)