enable database user login/logout information

Поиск
Список
Период
Сортировка
От muthu krishnan
Тема enable database user login/logout information
Дата
Msg-id BANLkTinoSsbi_3xBp-8=_tX8nmSgHuynWA@mail.gmail.com
обсуждение исходный текст
Ответы Re: enable database user login/logout information  (Alexander Shulgin <alex.shulgin@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: anthony.shipman@symstream.com
Дата:
Сообщение: Re: strange query plan with LIMIT
Следующее
От: Alexander Shulgin
Дата:
Сообщение: Re: enable database user login/logout information