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(at)radiumsystems(dot)com(dot)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(at)plukwa(dot)net> escreveu:
>
> > On Wed, Mar 05, 2003 at 11:02:25PM -0300, gborges(at)radiumsystems(dot)com(dot)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(at)plukwa(dot)net
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org