Re: Cannot (re)start PostgreSQL - Mailing list pgsql-admin

From Lamar Owen
Subject Re: Cannot (re)start PostgreSQL
Date
Msg-id 200205060003.28600.lamar.owen@wgcr.org
Whole thread Raw
In response to Re: Cannot (re)start PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Cannot (re)start PostgreSQL
List pgsql-admin
On Monday 06 May 2002 12:04 am, Tom Lane wrote:
> "otisg" <otisg@iVillage.com> writes:
> > Is there a way to get a more verbose error message from PostgreSQL that
> > will tell me why I can't start the DB?

> I'd venture that your /etc/rc script is preventing Postgres from telling
> you anything useful.  Try starting PG by hand ... or at the very least,
> find out what the script is doing with the postmaster's error output.

For debugging purposes, either editing /etc/rc.d/init.d/postgresql to change
the output redirect, or enabling syslog as documented in
/usr/share/doc/postgresql-7.2 (or 7.2.1, as applicable).

> There are way too many of those scripts that think routing stderr
> to /dev/null is a good idea.

And until our stderr is rollable it will remain a good idea.  Sorry.  Syslog
is the best bet with our current non-rollable stderr.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot (re)start PostgreSQL
Next
From: "otisg"
Date:
Subject: Re: Cannot (re)start PostgreSQL