On Tue, 2009-02-03 at 08:39 -0800, Rich Shepard wrote:
> On Tue, 3 Feb 2009, Selena Deckelmann wrote:
> > You have to re-initdb (as Devin indicated in an earlier message).
> If I tar /var/lib/pgsql/data/base/* before removing and recreating that
> path, can I untar the base directories and return to a running postmaster?
> Or, are there specific files to be removed that permit the new initdb to
You must use pg_dump and then restore the dump.
Joshua D. Drake
> Richard B. Shepard, Ph.D. | Integrity Credibility
> Applied Ecosystem Services, Inc. | Innovation
> <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
In response to
pdxpug by date
|Next:||From: Selena Deckelmann||Date: 2009-02-03 17:15:41|
|Subject: Re: Dropping Old Databases|
|Previous:||From: Rich Shepard||Date: 2009-02-03 16:39:26|
|Subject: Re: Next: Encoding Issue|