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: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Florian Pflug <fgp@phlo.org>, Aidan Van Dyk <aidan@highrise.ca>, Daniel Farina <daniel@heroku.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2011-11-02T02:40:27Z

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

looks like the v3 patch re-introduces the pg_subtrans issue...


On Tue, Nov 1, 2011 at 9:33 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> On Thu, Oct 27, 2011 at 4:25 PM, Simon Riggs <simon@2ndquadrant.com>
> wrote:
>
> > StartupMultiXact() didn't need changing, I thought, but I will review
> further.
>
> Good suggestion.
>
> On review, StartupMultiXact() could also suffer similar error to the
> clog failure. This was caused *because* MultiXact is not maintained by
> recovery, which I had thought meant it was protected from such
> failure.
>
> Revised patch attached.
>
> --
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>