Re: Corrupted or deleted pg_tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Curtis Klumas" <cklumas(at)mail(dot)randrinc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Jonathan Yee" <jon(at)mail(dot)randrinc(dot)com>
Subject: Re: Corrupted or deleted pg_tables
Date: 2004-06-09 14:26:55
Message-ID: 20832.1086791215@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Curtis Klumas" <cklumas(at)mail(dot)randrinc(dot)com> writes:
> We have a database that we manage through Webmin and today, the entires for
> the databases dissappeared from webmin. Going in through psql we could see
> our data in tables still intact, and have a copy of the directory structure.
> Is thier anyway to extract data and reconstruct a new database? We tried
> pg_dump but had a host of errors.

Like what? The only specific information you've provided here is that
things still work from psql ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Milosz Miecznik 2004-06-09 14:34:22 PostgreSQL Performance
Previous Message Andrew Janian 2004-06-09 14:22:43 Re: Corrupted or deleted pg_tables