Re: Hot Backup with rsync fails at pg_clog if under load

Chris Redekop <chris@replicon.com>

From: Chris Redekop <chris@replicon.com>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: Florian Pflug <fgp@phlo.org>, Aidan Van Dyk <aidan@highrise.ca>, Daniel Farina <daniel@heroku.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2011-10-26T19:27:23Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Derive oldestActiveXid at correct time for Hot Standby.
- 656bba95af39 9.0.6 cited
Start Hot Standby faster when initial snapshot is incomplete.
- ff8451aa14c8 9.0.6 cited
Fix timing of Startup CLOG and MultiXact during Hot Standby
- 2f55c535e1f0 9.0.6 cited

FYI I have given this patch a good test and can now no longer reproduce
either the subtrans nor the clog error.  Thanks guys!


On Wed, Oct 26, 2011 at 11:09 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> On Wed, Oct 26, 2011 at 5:16 PM, Simon Riggs <simon@2ndquadrant.com>
> wrote:
> > On Wed, Oct 26, 2011 at 5:08 PM, Simon Riggs <simon@2ndquadrant.com>
> wrote:
> >
> >> Brewing a patch now.
> >
> > Latest thinking... confirmations or other error reports please.
> >
> > This fixes both the subtrans and clog bugs in one patch.
>
> I'll be looking to commit that tomorrow afternoon as two separate
> patches with appropriate credits.
>
> --
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>