Couldn't find any tables, sequences or indices! - Mailing list pgsql-admin

From Fredrik Larsson
Subject Couldn't find any tables, sequences or indices!
Date
Msg-id 003a01c0a2a3$0268de90$3c01a8c0@MSURFERS3
Whole thread Raw
List pgsql-admin
Hi guys

I have a sorta emergency...
For some reason all my databases are gone, I can connect to the database but
when I do
\d i get "Couldn't find any tables, sequences or indices!"

But I can do querys: ie select (*) from tblfoo wich results in
count
-----
    0
(1 row)

All the data files (base/foo) is still in place.

I belive the problem occured when (directorys are symlinked) postmaster
failed to startup, due to a broken symlink (was installing new hardware) so
postmaster stared up without the base/foo directory so the pg_log got messed
but, I stoped postmaster, fixed the symlink.
But when I restarted postmaster the problem occured.
While examining the system tables I find that for example in pg_class the
entrys for my tables are gone.

Any ideas? comments?

(Yes there are backups)

Thanks
Fredrik


pgsql-admin by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: No UDP(5432) For You!
Next
From: John Hatfield
Date:
Subject: Vacuum analyze problem