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 > Simon, > > What do you mean, start over with a ba

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 wrote: the WAL file on the master is long gone, how would one inspect the web segment?  Any way to have PG "move" on?Regene

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Simon Riggs
On Thu, Dec 1, 2011 at 9:08 PM, Simon Riggs wrote: > On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco > 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: regenerate *from* the master --

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Simon Riggs
On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco 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. > -- > Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Supp

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 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 Jerry Sievers
Jim Buttafuoco 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. > > 2011-12-01 07:46:

Re: [HACKERS] Postgresql 9.1 replication failing

2011-12-01 Thread Robert Haas
On Thu, Dec 1, 2011 at 1:41 PM, Jim Buttafuoco 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 replica or do I

[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.  Same 2 lines over and over since yesterday.2011-12-01 07:46:30 EST  >LOG:  restored log file "0001000