pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
table 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