Logging connections, not queries

From: Hassan Schroeder <hassan(dot)schroeder(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Logging connections, not queries
Date: 2016-04-27 15:56:19
Message-ID: CACmC4yCguDgkMDuPK-3v1zYAehgJwfPANWcvwJG1Sh+0iKULVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

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(dot)schroeder(at)gmail(dot)com
http://about.me/hassanschroeder
twitter: @hassan
Consulting Availability : Silicon Valley or remote

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sameer Kumar 2016-04-27 23:05:23 Re: Logging connections, not queries
Previous Message Kip Warner 2016-04-27 07:09:44 Re: Tricky math in PSQL