Re: [HACKERS] TOAST table (or index?) corruption on PITR replica

2009-03-06 Thread Zdenek Kotala
Alvaro Herrera píše v pá 06. 03. 2009 v 10:32 -0300: > > The servers are running 8.3.5. > > Does this ring a bell for anyone? look here: http://archives.postgresql.org/pgsql-bugs/2008-11/msg00113.php It look likes that there could be problem with btree wal. Zdenek -- Sent via pgs

Re: [HACKERS] TOAST table (or index?) corruption on PITR replica

2009-03-06 Thread Gregory Stark
Alvaro Herrera writes: > 14903 2009-02-28 22:22:02 EST kangaroo app 49a9fe2e.3a37 ERROR: index > "pg_toast_42299_index" contains unexpected zero page at block 23768 > > There were actually several different instances of the first error > involving different toast values. Do you know how big this

[HACKERS] TOAST table (or index?) corruption on PITR replica

2009-03-06 Thread Alvaro Herrera
We have a customer running a very high-velocity database. We have set up a PITR replica that's restoring correctly using JD's PITRtools and pg_standby. However, upon stopping the recovery and starting it for production (for "switchover") it promptly gets into these problems: 14895 2009-02-28 22: