Determine all listeners subscribed to notifcations and what channels

From: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Determine all listeners subscribed to notifcations and what channels
Date: 2015-02-17 21:20:58
Message-ID: CAG_=8kAa5wxho+9FkYHwt3VPCr5Ce-T10pXYPL-8Pp5O9b1eAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm interested in trying to figure out which channels have been subscribed
to (using LISTEN). From what I could tell via a little Googling, there
used to be a table named pg_catalog.pg_listener that contained all this
information, but that seems to have disappeared somewhere in the 9.x
release (I'm using 9.3.x).

Is there a way to find out which channels have listeners?

thanks
--Cory

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2015-02-17 21:25:21 Re: Determine all listeners subscribed to notifcations and what channels
Previous Message Adrian Klaver 2015-02-17 21:12:28 Re: Issue dumping schema using readonly user