Re: Logging connections, not queries
| От | Sameer Kumar |
|---|---|
| Тема | Re: Logging connections, not queries |
| Дата | |
| 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
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
В списке pgsql-novice по дате отправления: