Re: [Sqlrelay-discussion] pgpool - II
Brought to you by:
mused
|
From: Frank J. <fr...@jo...> - 2008-07-10 22:23:39
|
On 7/10/08, Kalyan Raghu <kal...@gm...> wrote: > Hi all, > Is SQLRelay compatible with pgpool - II ? > > When I run a "normal" instance which connects to pgpool - II, it is > working fine. I am able to send queries to pgpool - II via this instance. > > When I run a query router instance, which connects to this normal > instance, I am not able to send the queries to pgpool - II. I may have been trying something very similar with pgbouncer (a more lightweight pgpool competitor) just now. What is your setup like? If it is sth like client <-> pgpool <-> sqlrelay <-> pg then we are maybe facing the same problem, which is to talk to sqlrelay somehow from a client that is set up to talk to postgres directly. For which there is a compatibility driver: http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html but it doesn't work for me from either Python via psycopg2 or trying to let pgbouncer talk to sqlrelay via this SQL Relay drop-in replacement library for PostgreSQL ... But it sounds more like you are trying someting like client <-> sqlrelay <-> pgpool <-> pg I think my problem is that it may be difficult for us to quickly replace the psycopg2 driver with the native SQL Relay python driver. Hence trying with the compatibility layer. I am curious about how you are doing it?! Cheers, Frank |