pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't access tables.
2+ messages / 2 participants
[nested] [flat]
* Can't access tables.
@ 2010-10-06 06:45 Lukasz Brodziak <lukasz.brodziak@gmail.com>
2010-10-06 13:41 ` Re: [ADMIN] Can't access tables. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Lukasz Brodziak @ 2010-10-06 06:45 UTC (permalink / raw)
To: pgsql-admin; pgadmin-support@postgresql.org
Hello,
I have a problem with viewing tables from my DB. The interesting thing
is that the physical files exist in the data folder but only some of
them are visible both in pgAdmin and the application that uses the DB.
What's more there's no trace of those tables in pg_class whatsoever. I
can view ca. half of the tables (120 out of almost 250). Have anyone
come accross such behaviour? The files appear to be fine compared to
another DB containing same tables and same data.
--
Łukasz Brodziak
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [ADMIN] Can't access tables.
2010-10-06 06:45 Can't access tables. Lukasz Brodziak <lukasz.brodziak@gmail.com>
@ 2010-10-06 13:41 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-10-06 13:41 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; +Cc: pgsql-admin; pgadmin-support@postgresql.org
Lukasz Brodziak <lukasz.brodziak@gmail.com> writes:
> I have a problem with viewing tables from my DB. The interesting thing
> is that the physical files exist in the data folder but only some of
> them are visible both in pgAdmin and the application that uses the DB.
> What's more there's no trace of those tables in pg_class whatsoever. I
> can view ca. half of the tables (120 out of almost 250). Have anyone
> come accross such behaviour? The files appear to be fine compared to
> another DB containing same tables and same data.
We used to get reports of that sort of thing from people who hadn't
vacuumed pg_class in a very long time (>2 billion transactions).
The pg_class rows *were* there, but invisible to ordinary queries
because of wraparound. That should be impossible in any modern
PG release branch, but since you didn't say what you're running,
maybe vacuuming the system catalogs would help.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-10-06 13:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-06 06:45 Can't access tables. Lukasz Brodziak <lukasz.brodziak@gmail.com>
2010-10-06 13:41 ` Tom Lane <tgl@sss.pgh.pa.us>
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