Re: Use LISTEN/NOTIFY between different databases

On 05/07/12 1:40 PM, Igor wrote:
>
>
> 2012/5/7 John R Pierce >
>
>     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