Re: postmaster never finishes starting up, silent to boot - Mailing list pgsql-general

From Greg Smith
Subject Re: postmaster never finishes starting up, silent to boot
Date
Msg-id alpine.GSO.2.01.0903180139470.15634@westnet.com
Whole thread Raw
In response to postmaster never finishes starting up, silent to boot  (Aaron Glenn <aaron.glenn@gmail.com>)
List pgsql-general
On Tue, 17 Mar 2009, Aaron Glenn wrote:

> Despite configuring postgresql.conf for excessive 'verboseness' nothing
> gets outputted to syslog or the --log specified file.

You shouldn't trust those destinations for getting really unusual errors
starting the server.  Change your log_destination temporarily back to just
"stderr" and start the server with a simple "pg_ctl start".  Errors will
show up on the terminal.  If that works but doesn't tell you anything
interesting about why startup isn't going correctly, try changing
log_min_messages=debug2 ; that will show you a bunch more information
about what's happening.

If you didn't delete the pid file after the crash or the old server is
still holding onto some shared memory/ports, that might be causing your
problem.  Another possibility is that you don't have the right permissions
on the copy.  Once you get the log output on the screen it should narrow
the possibilities here.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Christophe
Date:
Subject: Re: Re: [pgsql-advocacy] Video from the 2009-03-11 SFPUG talk on Unison, by Reese Hart
Next
From: Ashish Karalkar
Date:
Subject: Re: PostgreSql with or without Plus?