keeping track of connections
Brett McCormick <brett@work.chicken.org>
From: Brett McCormick <brett@work.chicken.org>
To: pgsql-hackers@hub.org
Date: 1998-06-03T03:28:06Z
Lists: 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.