Re: Who is LISTENing?

On Tue, Oct 16, 2012 at 11:01 AM, Sim Zacks <sim(at)compulab(dot)co(dot)il> wrote:

> On 10/15/2012 06:11 PM, rektide wrote:
>
> Hi pgsql-general,
>
> I'm interested in writing a supervisory process that can insure worker processes are
> running/spawn new ones if not. These workers will mainly be responsible for LISTENing to
> the db, which is emitting triggered_change_notification s.
>
> Is there any means to check a NOTIFY queue to see who or if anyone is LISTEN ing on it?
>
> Links:http://www.postgresql.org/docs/9.2/interactive/sql-notify.htmlhttp://www.postgresql.org/docs/9.2/interactive/tcn.html
>
> Regards,
>
> You can look in the pg_listener table. The relname is the Listen/notify
> code that you call and the listenerpid is the OS pid. You can see more
> details of that in the pg_stat_activity
>
> Sim
>

I guess pg_listener table is deprecated and no longer exist in PG 9.0
onwards.

--Raghav