enable database user login/logout information

From: muthu krishnan <muthu(dot)krishnan(dot)linux(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: enable database user login/logout information
Date: 2011-06-09 07:50:32
Message-ID: BANLkTinoSsbi_3xBp-8=_tX8nmSgHuynWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

We are running postgresql database server on itanium box.

Database - Postgresql 8.3.9
OS - SUSE Linux 11 SP 3
Server - Itanium (ia64)

We are trying to enable user login / logout information in postgresql log
file, to do this we enabled the following in postgresql.conf,

log_connections = on

log_disconnections = on

After this we are getting both database user login / logout information as
well as getting SQL queries executed by the application which increase the
log file size.

Please guide me how to get only the database user connection (without SQL
statements) information in logfile.

Thank you for spending your valuable time to read this.

Regards

Muthu

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Shulgin 2011-06-09 07:54:55 Re: enable database user login/logout information
Previous Message anthony.shipman 2011-06-09 06:16:26 Re: strange query plan with LIMIT