Re: lost system tables: any hope?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Rose <srose(at)telus(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: lost system tables: any hope?
Date: 2001-12-10 15:39:39
Message-ID: 22737.1007998779@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Rose <srose(at)telus(dot)net> writes:
> I'm one of those people who created the system database on one partition
> and put all the application databases on another. The latter was backed
> up, but the former was not. And that drive crashed.

What do you mean by "system database"?

template1 is not particularly critical, and you could survive without
the WAL log too ... but if you lost pg_log (in the $PGDATA/global/
directory) then you've got a problem. Please be specific about what
you have and what you don't.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raul DAVIDOVICH 2001-12-10 16:07:03 problem with select after updating
Previous Message Mourad EL HADJ MIMOUNE 2001-12-10 15:30:45 Limit of sequence