pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtable disappear from pg_class
2+ messages / 2 participants
[nested] [flat]
* table disappear from pg_class
@ 2006-03-15 08:16 marco <marco.put@tiscali.it>
2006-03-19 02:14 ` Re: table disappear from pg_class Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 2+ messages in thread
From: marco @ 2006-03-15 08:16 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I have a problem with a table which is disappeared from pg_class
with all objects related (views, indexes and so on).
pg_dump against this table does not work (I think because it is not
present in pg_class).
The strange behaviour is that I can select data from this table !!
We are using a 7.4.6 on linux (slackware).
Any help will be appreciated we are in emergency
regards
M.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: table disappear from pg_class
2006-03-15 08:16 table disappear from pg_class marco <marco.put@tiscali.it>
@ 2006-03-19 02:14 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2006-03-19 02:14 UTC (permalink / raw)
To: marco <marco.put@tiscali.it>; +Cc: pgsql-admin
marco wrote:
> Hi all,
> I have a problem with a table which is disappeared from pg_class
> with all objects related (views, indexes and so on).
> pg_dump against this table does not work (I think because it is not
> present in pg_class).
>
> The strange behaviour is that I can select data from this table !!
This sounds very much like transaction Id wraparound, meaning you failed
to vacuum pg_class (and possibly other system catalogs as well) in a
timely fashion. Basically you need to return the transaction counter a
little bit, then vacuum and make sure all your data is still consistent.
This has been discussed before. See for example:
http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-03-19 02:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-15 08:16 table disappear from pg_class marco <marco.put@tiscali.it>
2006-03-19 02:14 ` Alvaro Herrera <alvherre@commandprompt.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