Re: [GENERAL] 9.1.9 -> 9.1.10 causing corruption

2013-11-24 Thread Ben Chobot
For posterity, it appears my issues were https://wiki.postgresql.org/wiki/Nov2013ReplicationIssue. On Nov 4, 2013, at 3:48 PM, Ben Chobot wrote: > Anybody? I've tried this again on another streaming replication server, and > again had pg_toast errors until I re-basebackup'd it. Does it make se

Re: [GENERAL] 9.1.9 -> 9.1.10 causing corruption

2013-11-04 Thread Ben Chobot
Anybody? I've tried this again on another streaming replication server, and again had pg_toast errors until I re-basebackup'd it. Does it make sense to try disabling streaming replication for the backup and just use wal replay from the archive? My slave will be a bit behind, but I'll have draine

[GENERAL] 9.1.9 -> 9.1.10 causing corruption

2013-11-01 Thread Ben Chobot
I've got a bunch of independent database clusters, each with a couple of streaming replication slaves. I'm starting to upgrade them to 9.1.10, but on 3 of the 3 I've tried so far, this has somehow resulted in data corruption. I'm hoping it was the upgrade itself that caused the corruption, inste