Re: Miss of global directory

There really isn't a tool per say. You best bet is to do an initdb in a
new directory, then copy the contents of that global directory into your
old $pgdata (or better yet, a copy of it).  IF that works, you should
immediately do a pg_dump to see if you can get a real backup of your
data, and then I'd do a whole new initdb/createdb/load just to be overly
thorough. Then send us an email to let us know :-)

Robert Treat

On Mon, 2003-03-10 at 15:27, gborges@radiumsystems.com.br wrote:
> I mean that I lost /var/lib/pgsql/data/global
>
> Do you know some tool that helps me to recover/rebuild this directory?
>
> Thnks
> Gustavo
>
> No dia Mon, 10 Mar 2003 21:05:31 +0100, Artur Pietruk <arturp@plukwa.net> escreveu:
>
> > 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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org