| Lists: | pgsql-admin |
|---|
| From: | "Curtis Klumas" <cklumas(at)mail(dot)randrinc(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | "Jonathan Yee" <jon(at)mail(dot)randrinc(dot)com> |
| Subject: | Re: Corrupted or deleted pg_tables |
| Date: | 2004-06-09 01:08:58 |
| Message-ID: | NBEFJKGCNFNGADGMBKIMMEKPCAAA.cklumas@mail.randrinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)mail(dot)randrinc(dot)com
---------------------------------------------------
| 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 |
| 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
| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| 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-11 21:35:16 |
| Message-ID: | 1086989716.9266.1186.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Tue, 2004-06-08 at 21:08, Curtis Klumas wrote:
>
> 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.
>
My guess is that you have hit xid wrap around. Try vacuuming full
template1 and see if your info starts to reappear. Also watch to see if
it tells you some other db's need vacuum.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL