pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Corrupted or deleted pg_tables
4+ messages / 4 participants
[nested] [flat]
* Re: Corrupted or deleted pg_tables
@ 2004-06-09 01:08 Curtis Klumas <cklumas@mail.randrinc.com>
2004-06-09 14:26 ` Re: Corrupted or deleted pg_tables Tom Lane <tgl@sss.pgh.pa.us>
2004-06-11 21:35 ` Re: Corrupted or deleted pg_tables Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 2 replies; 4+ messages in thread
From: Curtis Klumas @ 2004-06-09 01:08 UTC (permalink / raw)
To: pgsql-admin; +Cc: Jonathan Yee <jon@mail.randrinc.com>
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
---------------------------------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Corrupted or deleted pg_tables
2004-06-09 01:08 Re: Corrupted or deleted pg_tables Curtis Klumas <cklumas@mail.randrinc.com>
@ 2004-06-09 14:26 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-06-09 14:26 UTC (permalink / raw)
To: Curtis Klumas <cklumas@mail.randrinc.com>; +Cc: pgsql-admin@postgresql.org, "Jonathan Yee" <jon@mail.randrinc.com>
"Curtis Klumas" <cklumas@mail.randrinc.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Corrupted or deleted pg_tables
2004-06-09 01:08 Re: Corrupted or deleted pg_tables Curtis Klumas <cklumas@mail.randrinc.com>
@ 2004-06-11 21:35 ` Robert Treat <xzilla@users.sourceforge.net>
1 sibling, 0 replies; 4+ messages in thread
From: Robert Treat @ 2004-06-11 21:35 UTC (permalink / raw)
To: Curtis Klumas <cklumas@mail.randrinc.com>; +Cc: pgsql-admin@postgresql.org, Jonathan Yee <jon@mail.randrinc.com>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Corrupted or deleted pg_tables
@ 2004-06-09 14:22 Andrew Janian <ajanian@scottrade.com>
0 siblings, 0 replies; 4+ messages in thread
From: Andrew Janian @ 2004-06-09 14:22 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-06-11 21:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-09 01:08 Re: Corrupted or deleted pg_tables Curtis Klumas <cklumas@mail.randrinc.com>
2004-06-09 14:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-11 21:35 ` Robert Treat <xzilla@users.sourceforge.net>
2004-06-09 14:22 Re: Corrupted or deleted pg_tables Andrew Janian <ajanian@scottrade.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox