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