Re: Miss of global directory

From: gborges(at)radiumsystems(dot)com(dot)br
To: Artur Pietruk <arturp(at)plukwa(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Miss of global directory
Date: 2003-03-10 20:27:27
Message-ID: 20030310202727.B84F76C31F@smtp.radiumsystems.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bob Smith 2003-03-10 20:38:16 Re: Followup Re: Performance question
Previous Message Chris Mungall 2003-03-10 20:24:07 Using functions as filters in queries