Re: Use LISTEN/NOTIFY between different databases

On 05/07/12 1:40 PM, Igor wrote:
>
>
> 2012/5/7 John R Pierce <pierce(at)hogranch(dot)com <mailto:pierce(at)hogranch(dot)com>>
>
> On 05/07/12 1:13 PM, Igor wrote:
>
>
> 1.Is this possible in future releases ?
> 2. How I can organize interconnectbetween two clients
> connected to different DB? I need call NOTIFY from pgsql
> function in one database to another LISTEN client in another
> database.
>
>
>
> a listener isn't 'in a database', its a client application thats
> polling for the notifications from the database its connected to.
>
>
> I understand this. But I need "link" between two clients, connected to
> different databases.
>
> Its real situation. We use sharded cluster based on plproxy. The
> calling function for DB queries is equal in all databases (see plproxy
> documentation). Now we need to release some internal logic between
> clients based on certain events which occurred in this functions. The
> LISTEN/NOTIFY mechanism is very good feature, but event occur NOT in
> connected DB - i.e. in destination DB via plproxy wrapper. I.e. wee
> need subject.

then maybe you could have a process to do this work which connects to
all the databases and issues the LISTENs and initiates whatever actions
you need in the other database(s) ?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast