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.
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) |