From: Wei Weng <wweng@kencast.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: debug a mess
Date: Thu, 27 Feb 2003 12:18:06 -0500
Message-ID: <20030227121806.A31374@example.com> (raw)
In-Reply-To: <6489.1046295261@sss.pgh.pa.us>
References: <20030225155820.B24120@example.com>
<13032.1046208448@sss.pgh.pa.us>
<20030226161011.A28093@example.com>
<6489.1046295261@sss.pgh.pa.us>
On 26/02/03 16:34 -0500, Tom Lane wrote:
> Wei Weng <wweng@kencast.com> writes:
> > Where is postmaster log? I found a new file in /var/log/pgsql. I put
> > log_connections = yes and syslog = 2 into my postgresql.conf file and expect
> > something to happen. Restarted postgresql service on my redhat 7.3 box and
> > tried a couple of queries with psql utility. Nothing seemed to have been
> > logged in /var/log/pgsql.
>
> If you want to use syslog then you'd better be sure that syslogd is
> configured to do something useful with Postgres messages, and not just
> drop 'em on the floor.
>
> If you want to use stderr, look at the start script. Some distros
> provide Postgres start scripts that route the postmaster's stderr to
> /dev/null --- either explicitly, or by using the infamous -S switch.
>
Tom:
I checked pg_config's output, in my redhat build, syslog is already enabled.
So that clears some of my doubt.
This is how I started my postmaster.
su postgres
/usr/bin/pg_ctl -D $PGDATA -l /var/log/pgsql -p /usr/bin/postmaster start >
/var/log/pgsql 2>&1
I am trying my best to force the postmaster to write to the /var/log/pgsql
file. But it didn't seem to work at all. All there in /var/log/pgsql is a
oneline "postmaster successfully started". I checked the manpages, and all
they say about log is use -l switch (which I used).
Can you provide a little more hints?
Thanks!
Wei
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: wweng@kencast.com, tgl@sss.pgh.pa.us
Subject: Re: debug a mess
In-Reply-To: <20030227121806.A31374@example.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox