From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: VACUUMs take twice as long across all nodes
Date: Sun, 29 Oct 2006 10:34:04 -0500
Message-ID: <20061029153404.GF14585@phlogiston.dyndns.org> (raw)
In-Reply-To: <20061029150826.80afe324.gdh@laterooms.com>
References: <20061026095827.9e85e1c0.gdh@laterooms.com>
<20196.1161874041@sss.pgh.pa.us>
<20061026160609.5e94e581.gdh@laterooms.com>
<20061026191728.GD26892@nasby.net>
<20061026213556.174bd7b5.gdh@laterooms.com>
<20061026220937.GA6866@phlogiston.dyndns.org>
<20061027102025.8183c5d9.gdh@laterooms.com>
<20061029145825.GB14585@phlogiston.dyndns.org>
<20061029150826.80afe324.gdh@laterooms.com>
On Sun, Oct 29, 2006 at 03:08:26PM +0000, Gavin Hamill wrote:
>
> This is interesting, but I don't understand.. We've done a full restore
> from one of these pg_dump backups before now and it worked just great.
>
> Sure I had to DROP SCHEMA _replication CASCADE to clear out all the
> slony-specific triggers etc., but the new-master ran fine, as did
> firing up new replication to the other nodes :)
>
> Was I just lucky?
Yes. Slony alters data in the system catalog for a number of
database objects on the replicas. It does this in order to prevent,
for example, triggers from firing both on the origin and the replica.
(That is the one that usually bites people hardest, but IIRC it's not
the only such hack in there.) This was a bit of a dirty hack that
was supposed to be cleaned up, but that hasn't been yet. In general,
you can't rely on a pg_dump of a replica giving you a dump that, when
restored, actually works.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
--Jane Jacobs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: VACUUMs take twice as long across all nodes
In-Reply-To: <20061029153404.GF14585@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox