On Wed, Jun 1, 2011 at 12:45 PM, Greg Sabino Mullane <g...@turnstep.com> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > > >> The pg_listener table was removed in 9.0 in the revamp of >> LISTEN/NOTIFY. In pgAdmin we used to perform a number of selects from >> the table to get information about Slony clusters - for example, the >> PID of the slon process or to check if a process is listening for a >> specific notification. This allows the app to indicate to the user if >> there is something wrong with their replication cluster. >> >> I can't find any way to get that information now - any ideas? > > Nope, you are out of luck: the information is locked away and cannot > be seen by other processes. I'm sure of this because Bucardo > went through the same questioning some time ago. We basically rewrote > the app a bit to use the on-disk PID files to replace some of the > lost functionality, and sucked up the rest. :)
:-( -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
