keeping track of connections

Поиск
Список
Период
Сортировка
От Brett McCormick
Тема keeping track of connections
Дата
Msg-id 13684.49862.833361.460921@web0.speakeasy.org
обсуждение исходный текст
Ответы Re: [HACKERS] keeping track of connections  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Brett McCormick
Дата:
Сообщение: Re: [HACKERS] dump/reload
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] keeping track of connections