Couldn't find any tables, sequences or indices!

From: "Fredrik Larsson" <fln(at)mendosus(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Couldn't find any tables, sequences or indices!
Date: 2001-03-01 22:57:31
Message-ID: 003a01c0a2a3$0268de90$3c01a8c0@MSURFERS3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message John Hatfield 2001-03-01 23:28:07 Vacuum analyze problem
Previous Message Craig McDaniel 2001-03-01 22:38:59 No UDP(5432) For You!