All,I have a large PG 9.1.1 server (over 1TB of data) and replica using log shipping. I had some hardware issues on the replica system and now I am getting the following in my pg_log/* files. Same2 lines over and over since yesterday.2011-12-01 07:46:30 EST LOG: restored log file
On Thu, Dec 1, 2011 at 1:41 PM, Jim Buttafuoco j...@contacttelecom.com wrote:
2011-12-01 07:46:30 EST LOG: restored log file 0001028E00E5
from archive
2011-12-01 07:46:30 EST LOG: incorrect resource manager data checksum in
record at 28E/E555E1B8
Anything I can do on the
Jim Buttafuoco j...@contacttelecom.com writes:
All,
I have a large PG 9.1.1 server (over 1TB of data) and replica using log
shipping. I had some hardware issues on the
replica system and now I am getting the following in my pg_log/* files. Same
2 lines over and over since yesterday.
the WAL file on the master is long gone, how would one inspect the web segment? Any way to have PG "move" on?On Dec 1, 2011, at 2:02 PM, Jerry Sievers wrote:Jim Buttafuoco j...@contacttelecom.com writes:All,I have a large PG 9.1.1 server (over 1TB of data) and replica using log shipping. I had
On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco j...@contacttelecom.comwrote:
the WAL file on the master is long gone, how would one inspect the web
segment? Any way to have PG move on?
Regenerate the master.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL
On Thu, Dec 1, 2011 at 9:08 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco j...@contacttelecom.com
wrote:
the WAL file on the master is long gone, how would one inspect the web
segment? Any way to have PG move on?
Regenerate the master.
typo:
Simon,What do you mean, start over with a base backup?JimOn Dec 1, 2011, at 4:08 PM, Simon Riggs wrote:On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco j...@contacttelecom.com wrote:
the WAL file on the master is long gone, how would one inspect the web segment? Any way to have PG "move"
Hello Jim,
I think you not have other possibilities if the archives are
corrupted and there are no possibilities to restore it,
you need to recreate the standby starting from a base backup.
Kind Regards
2011/12/1 Jim Buttafuoco j...@contacttelecom.com
Simon,
What do you mean,