identifying local connections
От
Scott Ribe
Тема
identifying local connections
Дата
Msg-id
E059EC3E-2F17-4C54-B35B-5CA0A38A25A3@elevated-dev.com
Список
Дерево обсуждения
identifying local connections Scott Ribe <scott_ribe@elevated-dev.com>
Re: identifying local connections Tom Lane <tgl@sss.pgh.pa.us>
Re: identifying local connections Scott Ribe <scott_ribe@elevated-dev.com>
Re: identifying local connections Tom Lane <tgl@sss.pgh.pa.us>
Re: identifying local connections Scott Ribe <scott_ribe@elevated-dev.com>
Re: identifying local connections Steve Clark <sclark@netwolves.com>
Re: identifying local connections Scott Ribe <scott_ribe@elevated-dev.com>
Assume I have a local process which leaves a transaction open & idle for an extended period of time. Is there any way to identify the local process connected to a particular backend? pg_stat_activity is fine for TCP connections but does not provide useful identifying information for domain socket connections. I just upgraded to 9, and will implement set application_name in my various server daemons, but was wondering if there's a way to identify this process right now. -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice
В списке pgsql-general по дате отправления
