Re: [Sqlrelay-discussion] pgpool - II

[Kalyan R. <kal...@gm...>]

Hi Frank,
 thanks for your reply.
 As you said, I am working in the second way,  client <--> sqlrelay  <-->
pgpool <-->   postgresql DB.

 It was only a small problem in the configuration of sqlrelay because of
which I couldn't connect to the pgpool.
 Now, everything is working fine.

 Thanks,
 Kalyan.

On Thu, Jul 10, 2008 at 6:23 PM, Frank Joerdens <fr...@jo...> wrote:

> 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
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>