Re: Is my database done for?

Mark Nelson <mcn@cc.usu.edu> writes:
> DEBUG:  database system is in production state

Looks to me like you're up and running --- although that bit about
pre-existing shared memory block worries me.  Are you *certain* there is
no postmaster already running?  I'd try "ps auxww | grep postmaster" (or
"ps -ef" depending on your Unix flavor) and look for older processes.
It's not at all impossible that your machine is already configured to
start Postgres at bootup.

> I have not been returned to a prompt of any kind

You didn't put the postmaster in background.  You may care to reread
the Admin Guide concerning standard procedures for starting the
postmaster...

            regards, tom lane