Date: Thu, 27 Feb 2003 13:05:07 -0500
From: Wei Weng <wweng@kencast.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: debug a mess
Message-ID: <20030227130507.A31962@example.com>
Reply-To: Wei Weng <wweng@kencast.com>
References: <20030225155820.B24120@example.com>
	<13032.1046208448@sss.pgh.pa.us>
	<20030226161011.A28093@example.com> <6489.1046295261@sss.pgh.pa.us>
	<20030227121806.A31374@example.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5.1i
In-Reply-To: <20030227121806.A31374@example.com>;
	from wweng@kencast.com on Thu, Feb 27, 2003 at 12:18:06PM -0500

> 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!
> 
Actually, never mind that. :)

I changed the setting in postgresql.conf to syslog = 1 and everything now
spills out of both standard out (which directs to /var/log/pgsql) and syslog
(which I still don't know where it is being stored).

Wei