pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Donald Fraser <postgres@kiwi-fraser.net>
To: [ADMIN] <pgsql-admin@postgresql.org>
Subject: problem with connection logging
Date: Fri, 25 Mar 2005 14:30:15 -0000
Message-ID: <000c01c53147$2c324c20$0264a8c0@demolish1> (raw)

I'm running PostgreSQL 7.4.7 and have the following problem.
I have "log connections" enabled in the configuration file so that I can keep track of who's been logging on.
The problem is that I also have pg_autovacuum running which logs on an off constantly and fills up the log with its own database connections. I'm not interested in pg_autovacuum's connections - they just clog up my log files.

Is there a way of filtering out say Unix socket or localhost connections whilst logging all other connections?

My guess is no, does anyone else suffer from this problem and if so have you found a solution for dealing with it?

thanks
Donald Fraser

Message-ID: <000c01c53147$2c324c20$0264a8c0@demolish1>
Permalink:  ../000c01c53147$2c324c20$0264a8c0@demolish1/
Also on:    postgresql.org/message-id/000c01c53147$2c324c20$0264a8c0@demolish1

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: postgres@kiwi-fraser.net
  Subject: Re: problem with connection logging
  In-Reply-To: <000c01c53147$2c324c20$0264a8c0@demolish1>
  References: <000c01c53147$2c324c20$0264a8c0@demolish1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox