Re: 9.1.2 ? - Mailing list pgsql-hackers

From Chris Redekop
Subject Re: 9.1.2 ?
Date
Msg-id CAC2SuR+ca-_Y8x5dDtt+WUa6RiWYrZvvzAcDiDZya0yVSmz3Wg@mail.gmail.com
Whole thread Raw
In response to Re: 9.1.2 ?  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
On Wed, Nov 9, 2011 at 6:22 PM, Florian Pflug <fgp@phlo.org> wrote:
On Nov9, 2011, at 23:53 , Daniel Farina wrote:
> I think a novice user would be scared half to death: I know I was the
> first time.  That's not a great impression for the project to leave
> for what is not, at its root, a vast defect, and the fact it's
> occurring for people when they use rsync rather than my very sensitive
> backup routines is indication that it's not very corner-ey.

Just to emphasize the non-conerish-ness of this problem, it should be
mentioned that the HS issue was observed even with backups taken with
pg_basebackup, if memory serves correctly.
Yes I personally can reliably reproduce both the clog+subtrans problems using pg_basebackup, and can confirm that the "oldestActiveXid_fixed.v2.patch" does resolve both issues.

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: why do we need two snapshots per query?
Next
From: Tom Lane
Date:
Subject: Re: trivial patch: foreign table either defines row type