| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | "pdxpug(at)postgresql(dot)org" <pdxpug(at)postgresql(dot)org> |
| Subject: | Re: Next: Encoding Issue |
| Date: | 2009-02-03 16:40:40 |
| Message-ID: | 1233679240.31769.1.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pdxpug |
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
> work?
No.
You must use pg_dump and then restore the dump.
Joshua D. Drake
>
> Thanks,
>
> Rich
>
> --
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Selena Deckelmann | 2009-02-03 17:15:41 | Re: Dropping Old Databases |
| Previous Message | Rich Shepard | 2009-02-03 16:39:26 | Re: Next: Encoding Issue |