Re: Logging question

Tom Lane wrote:
> Madison Kelly <linux@alteeve.com> writes:
>
>>Where /is/ the log file?
>
>
> It depends.  If you selected syslog logging then it's wherever syslog is
> configured to put the messages.  Otherwise, it's wherever the
> postmaster's stderr output is being sent.
>
> A fairly annoying property of the current RPM packagings is that their
> startup script sends postmaster stderr to /dev/null.  We have (finally)
> fixed that for 8.0, but in current releases you need to alter the
> startup script in order to get useful log output.
>
>             regards, tom lane

woohoo!!

Thank you, I would have taken forever to figure that out on my own...
For the record on Fedora Core 1 the line to change is:

'/etc/rc.d/rc3.d/s85postgresql' line 171

Which I changed from:

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA -p
/usr/bin/postmaster -o '-p ${PGPORT}' start  > /dev/null 2>&1" < $

to...

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA -p
/usr/bin/postmaster -o '-p ${PGPORT}' start  > /var/log/psql.log $#


I had to touch the 'psql.log' file and then 'chown' it to
'postgres:postgres' but now my queries are being logged. Adding the earlier:

ALTER USER johndoe SET log_statement TO TRUE;

that Michael Fuhr mentioned and I have exactly what I wanted happening.
Thank you all -very- much!

Madison