Re: Resurrecting pg_upgrade - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: Resurrecting pg_upgrade
Date
Msg-id 20031212182647.J81928@ganymede.hub.org
Whole thread Raw
In response to Re: Resurrecting pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, 12 Dec 2003, Tom Lane wrote:

> Alternative thought: just recommend that if possible, people take
> a filesystem dump of their old PGDATA directory after stopping
> the old postmaster.  This would be sufficient for retreating to
> the prior version if needed.  It might or might not be slower
> than copying all the files to a new PGDATA ...

being able to do a dump to a gzip'd tar file might be an option here also
... should take a significantly less footprint to create the "backup", and
on an idle server, shouldn't take any longer then other backup methods ...




----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: markw@osdl.org
Date:
Subject: more dbt-2 results hyperthreading on linux-2.6.0-test11
Next
From: Thomas Swan
Date:
Subject: Re: Resurrecting pg_upgrade