Madison Kelly <linux@xxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
