Re: postmaster never finishes starting up, silent to boot

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Aaron Glenn <aaron(dot)glenn(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: postmaster never finishes starting up, silent to boot
Date: 2009-03-18 05:46:21
Message-ID: alpine.GSO.2.01.0903180139470.15634@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2009-03-18 05:49:34 Re: PostgreSql with or without Plus?
Previous Message Christophe 2009-03-18 05:34:13 Re: [GENERAL] Re: Video from the 2009-03-11 SFPUG talk on Unison, by Reese Hart