you have to make some changes on the postgresql.conf file:
log_statements = true
log_timestamp = true
log_connections = true
server_min_messages defaults to notice, so any warning/error will be logged
too.
Of course, do a pg_ctl reload -mf for the postmaster to be aware of the
changes.
And remember to rotate your logs every day, as the log file will grow very
fast.
On Monday 14 April 2003 17:22, Daniel Seichter wrote:
> Hello,
>
> How I can start postgeSQL 7.3.2 and log everything. With everything I mean
> the following:
> - all SQL statements which are executed (statusmessages if statement was
> successfully or not)
> - all logged users (with date when login)
> - all error messages
>
> Everything with timestamps, so I can compare the errors and statements with
> the errorlog of my program.
>
> Is this possible?
>
> Thank you all in advanced
>
> Daniel Seichter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org