Re: Logging connections, not queries

Поиск

Список

Период

Сортировка

От	Sameer Kumar
Тема	Re: Logging connections, not queries
Дата	28 апреля 2016 г. 02:05:38
Msg-id	CADp-Sm4tAHarisHabHsgo2AQ=DyyYNK00aNut+kU_4R6u4XD_g@mail.gmail.com обсуждение исходный текст
Ответ на	Logging connections, not queries (Hassan Schroeder <hassan.schroeder@gmail.com>)
Список	pgsql-novice

Дерево обсуждения

On Wed, 27 Apr 2016 23:56 Hassan Schroeder, <hassan.schroeder@gmail.com> wrote:

PostgreSQL 9.3.12 on Ubuntu 14.04.4 LTS

I'd like to log connections for performance/security reasons but so
far I'm unable to log them *without* getting queries logged as well.

By any chance do you have log_statement set to 'all'? Or log_min_duration_statement to a non-negative value?

IOW I'd like to see only results of these in the logging output -

log_connections = on
log_disconnections = on

Any suggestions?

TIA!
--
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
http://about.me/hassanschroeder
twitter: @hassan
Consulting Availability : Silicon Valley or remote

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice