Re: Corrupted or deleted pg_tables

Can you post your errors?

Andrew

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Curtis Klumas
Sent: Tuesday, June 08, 2004 8:09 PM
To: pgsql-admin@postgresql.org
Cc: Jonathan Yee
Subject: Re: [ADMIN] Corrupted or deleted pg_tables



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.

---------------------------------------------------

Curtis Klumas
Randr, Inc.
909-205-9138 (cell)
909-669-3427 (office)
curtis@mail.randrinc.com

---------------------------------------------------




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend