[ADMIN] Database corruption event, unlockable rows, possibly bogus virtual xids? (-1/4444444444)

2013-02-21 Thread Ned Wolpert
Folks- I'm doing a postmortem on a corruption event we had. I have an idea on what happened, but not sure. I figure I'd share what happened and see if I'm close to right here. Event: Running 9.1.6 with hot-standby, archiving 4 months of wal files, and even a nightly pg_dump all. 50G database.

Re: [ADMIN] Pg 9.1 master-slave replication

2013-02-21 Thread Kevin Grittner
Prashanth Ranjalkar wrote: >> Hello, Could explain somebody what will happen, if the slave > It depends on the type of replication is used. > > If it's a slony replication then master continues to work and > will catch up when slave is available. > > However if the Streaming replication is used,

[ADMIN] Re: Database corruption event, unlockable rows, possibly bogus virtual xids? (-1/4444444444)

2013-02-21 Thread Ned Wolpert
My bad, I'll re-post this to pgsql-general with more data on my running environment On Thu, Feb 21, 2013 at 11:16 AM, Ned Wolpert wrote: > Folks- > > I'm doing a postmortem on a corruption event we had. I have an idea on > what happened, but not sure. I figure I'd share what happened and s