Re: Miss of global directory - Mailing list pgsql-admin

From Artur Pietruk
Subject Re: Miss of global directory
Date
Msg-id 20030310200531.GK1941@plukwa.net
Whole thread Raw
In response to Miss of global directory  (gborges@radiumsystems.com.br)
List pgsql-admin
On Wed, Mar 05, 2003 at 11:02:25PM -0300, gborges@radiumsystems.com.br wrote:
> Hi!
>
> I lost the global directory wich contains some archives which are needed to use postgres correctly.

    I'm not sure what you mean by "global directory". You mean
you've lost binaries, etc. related to pgsql?

> Is there some way to rebuild this directory? The data directory which contains all my database information is safe.

    But, as long as you have $PGDATA, you should be safe. (But
remember to backup everything, and make sure you know what you are
doing, to not loose your DB by simple mistake/rm - be careful).

    Here is short overview of what you could try: Backup your
current $PGDATA directory. Then, reinstall postgresql (remember -
exactly the same version of PGSQL as before!). When done, new
$PGDATA dir will be created. Take postgresql down, and remove new
$PGDATA. Then, copy to that place your old, backuped $PGDATA.

    Hope it works,
--
--- Artur Pietruk, arturp@plukwa.net

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: multiple $PGDATA dir's for one! postmaster?
Next
From: "Yudha Setiawan"
Date:
Subject: OOT-Does PostgreSQL has commercial level.