Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] keeping track of connections

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Hal Snyder <hal(at)enteract(dot)com>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] keeping track of connections
Date: 1998-06-03 15:52:35
Message-ID: Pine.BSF.3.96.980603115123.8597R-100000@hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, 3 Jun 1998, Hal Snyder wrote:

> > Date: Wed, 3 Jun 1998 02:37:58 -0700 (PDT)
> > From: Brett McCormick <brett(at)work(dot)chicken(dot)org>
> > Cc: maillist(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)hub(dot)org
> > Sender: owner-pgsql-hackers(at)hub(dot)org
> 
> > On Wed, 3 June 1998, at 01:05:17, David Gould wrote:
> > 
> > > I am curious, what is it you are trying to accomplish with this? Are you 
> > > trying to build a persistant log that you can query later for billing
> > > or load management/capacity planning information? Are you trying to monitor
> > > login attempts for security auditing? Are you trying to catch logins in
> > > real time for some sort of middleware integration?
> > 
> > The problem is that when I do a process listing for the postgres user,
> > I see many backends.  There's no (convenient) way to see what those
> > backends are doing, what db they're connected to or the remote
> > host/postgres user.
> > 
> > My required functionality is this: a list of all backends and
> > connection details.  IP, queries issued, listens/notifications
> > requested/served, bytes transfered, postgres user, db, current query,
> > client version, etcetcetc.
> ....
> 
> Can backend monitoring be compatible with one or more extant
> monitoring techniques?
> 
> 1. syslog
> 2. HTML (like Apache's real time status)

	I like this method the best...it makes it easier for clients to
monitor as well, without having access to the machines...but does it pose
any security implications?



In response to

pgsql-hackers by date

Next:From: Jose' Soares Da SilvaDate: 1998-06-03 16:25:27
Subject: Re: [INTERFACES] pgaccess 0.86
Previous:From: Patrice HédéDate: 1998-06-03 15:36:55
Subject: Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group