log_connections = on
log_disconnections = on
and this will log all the connections and disconnections to your database server in the db server log files.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 7/27/06, Richard Huxton <
dev@archonet.com> wrote:
Jasbinder Bali wrote:
> How do i turn on the connection logging and then how do you actually check
> it?
Log settings are in your postgresql.conf file and are detailed in this
part of the manual:
http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html
Where your logfiles are stored will depend on your settings, but
typically on a unix-style system they will be in /var/log/.
I recommend you stop what you're doing for an hour or two and quickly
read through section III (Server Administration) of the manuals. That
will save you a lot of time later.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
