[HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Jim Buttafuoco
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

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Robert Haas
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

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Jerry Sievers
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.

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Jim Buttafuoco
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

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Simon Riggs
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

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Simon Riggs
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:

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Jim Buttafuoco
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"

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread desmodemone
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,