Re: [Sqlrelay-discussion] pgpool - II

[Frank J. <fr...@jo...>]

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