Skip site navigation (1) Skip section navigation (2)

Re: Next: Encoding Issue

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 (view raw or flat)
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


In response to

Responses

pdxpug by date

Next:From: Selena DeckelmannDate: 2009-02-03 17:15:41
Subject: Re: Dropping Old Databases
Previous:From: Rich ShepardDate: 2009-02-03 16:39:26
Subject: Re: Next: Encoding Issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group