Re: missing data

Dave Perkins writes:

> I'm running postgresql 6.5 on Red Hat Linux 6.2 and have run into a
> situation where I am able to open a database connection using psql yet
> there is no trace of any tables in the database even though all the data
> files are present when I browse the database directory.

Depending on your definition of "no trace", this might work:  Try

select relname, relowner from pg_class;

If this shows table names that sound familiar, then it is likely that the
user indicated by "relowner" disappeared.  Look into the table pg_shadow
to make sure some user's usesysid column matches relowner.  (It's safe to
change these with update commands.)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/