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
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! |