Hard failure, can't restart DB
We recently experienced a hard media failure. It turns out our admin guys
have been doing backups by backing up the pgsql data directory, but not
prepping the db first.
After a restore, when I try to start the database I get "LOG: logger
shutting down" and nothing else. This is Postgres 8.1.3.
I've been on the IRC channel for a while and they referred me here. I know
that the DB wasn't backed up correctly, but is there anything I can do to
recover?
Thanks,
David
--
David Dollar <ddollar@gmail.com>
On Thu, May 03, 2007 at 08:37:33AM -0400, David Dollar wrote:
We recently experienced a hard media failure. It turns out our admin guys
have been doing backups by backing up the pgsql data directory, but not
prepping the db first.
What platform is this?
After a restore, when I try to start the database I get "LOG: logger
shutting down" and nothing else. This is Postgres 8.1.3.
This sounds like you're looking at the wrong log. You have the syslogger
set up to write the log somewhere else - you need to look in that logfile.
//Magnus