Search Postgresql Archives

postgres standby won't start

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux