keeping track of connections - Mailing list pgsql-hackers

From Brett McCormick
Subject keeping track of connections
Date
Msg-id 13684.49862.833361.460921@web0.speakeasy.org
Whole thread Raw
Responses Re: [HACKERS] keeping track of connections  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
I would love a way to keep track of the connections/attempted
connections to the postmaster.  I'm thinking that when the postmaster
accept()s a connection, it can just insert a record into a table
(system catalog or not) with the information, which can be updated
after the authentication succeeds/fails or whatnot.

something like 'smbstatus' for the samba system.

So, my question is: how should I go about doing this?  should I look
into SPI, which I know nothing about?  or, what..  I don't think the
catalog cache stuff needs to be changed, it isn't as if this info
needs to be immediately accessible.

pgsql-hackers by date:

Previous
From: Brett McCormick
Date:
Subject: Re: [HACKERS] dump/reload
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] keeping track of connections