[GENERAL] Standby stopped working after PANIC: WAL contains references to invalid pages

2013-06-22 Thread Dan Kogan
Hello, Today our standby instance stopped working with this error in the log: 2013-06-22 16:27:32 UTC [8367]: [247-1] [] WARNING: page 158130 of relation pg_tblspc/16447/PG_9.2_201204301/16448/39154429 is uninitialized 2013-06-22 16:27:32 UTC [8367]: [248-1] [] CONTEXT: xlog redo vacuum: rel

Re: [GENERAL] Standby stopped working after PANIC: WAL contains references to invalid pages

2013-06-22 Thread Dan Kogan
I am in the process of doing that now. I'll reply again with results once that is done. -Original Message- From: Lonni J Friedman [mailto:netll...@gmail.com] Sent: Saturday, June 22, 2013 4:11 PM To: Dan Kogan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Standby st

Re: [GENERAL] Standby stopped working after PANIC: WAL contains references to invalid pages

2013-06-22 Thread Dan Kogan
Message- From: Lonni J Friedman [mailto:netll...@gmail.com] Sent: Saturday, June 22, 2013 4:11 PM To: Dan Kogan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Standby stopped working after PANIC: WAL contains references to invalid pages Looks like some kind of data corruption

Re: [GENERAL] Standby stopped working after PANIC: WAL contains references to invalid pages

2013-06-24 Thread Dan Kogan
We have backed up $PGDATA, but had to re-initialize the slave. We also have the WALs from the day this happened. Thanks, Dan -Original Message- From: Lonni J Friedman [mailto:netll...@gmail.com] Sent: Saturday, June 22, 2013 10:09 PM To: Dan Kogan Cc: pgsql-general@postgresql.org