Обсуждение: 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
pgsqldata directory, but not prepping the db first.<br /><br />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.<br /><br />I've been on the IRC channel for a
whileand they referred me here. I know that the DB wasn't backed up correctly, but is there anything I can do to
recover?<br/><br />Thanks,<br />David<br clear="all" /><br /> -- <br />David Dollar <<a
href="mailto:ddollar@gmail.com">ddollar@gmail.com</a>> 

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