Re: Corrupted or deleted pg_tables - Mailing list pgsql-admin

From Curtis Klumas
Subject Re: Corrupted or deleted pg_tables
Date
Msg-id NBEFJKGCNFNGADGMBKIMMEKPCAAA.cklumas@mail.randrinc.com
Whole thread Raw
Responses Re: Corrupted or deleted pg_tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Corrupted or deleted pg_tables  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-admin
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

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




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Refined LC_COLLATE or multiple database clusters?
Next
From: "Cook, Tom"
Date:
Subject: PostgreSQL 7.4.2 on SunOS 4.1.4