pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gavin Hamill <gdh@laterooms.com>
To: pgsql-performance@postgresql.org
Subject: Re: VACUUMs take twice as long across all nodes
Date: Sun, 29 Oct 2006 15:08:26 +0000
Message-ID: <20061029150826.80afe324.gdh@laterooms.com> (raw)
In-Reply-To: <20061029145825.GB14585@phlogiston.dyndns.org>
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>


Hi :)

[pg_dump from a Slony replica]

> That's not the problem.  The problem is that when you restore the
> dump of the slave, you'll have garbage.  Slony fools with the
> catalogs on the replicas.  

>  (And you might as well throw away the
> dumpfiles from the replicas that you have.  They won't work when you
> restore them.)

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?

Cheers,
Gavin.



view thread (17+ messages)  latest in thread

Message-ID: <20061029150826.80afe324.gdh@laterooms.com>
Permalink:  ../20061029150826.80afe324.gdh@laterooms.com/
Also on:    postgresql.org/message-id/20061029150826.80afe324.gdh@laterooms.com

 · 

reply
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: gdh@laterooms.com
  Subject: Re: VACUUMs take twice as long across all nodes
  In-Reply-To: <20061029150826.80afe324.gdh@laterooms.com>

* 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