From: | Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com> |
---|---|
To: | martins(dot)listz(at)gmail(dot)com |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Proxy for postgres |
Date: | 2009-08-14 16:42:27 |
Message-ID: | f205bb120908140942i18c36c6ex4f812270e1a2ed75@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I'm searching for something to use as a proxy for different instances of
> postgres.
>
> I've found pl/proxy, but it seems to work with (correct me if i'm wrong)
> functions, and some hard work would be needed in our applications in
> order to make them use those functions replacing direct access, an I'm
> trying to avoid this.
>
> Another option is pgpool, but I see too much lock in tables at
> transactional queries, and I'm pretty sure this will make my life a lot
> harder.
>
> So the question is, what can I use as a proxy queries to different
> instances of postgres?
>
You can use dblink. But could interference the performance
and is not really what you want.
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Eris J. Gómez | 2009-08-14 16:42:50 | Function doesn't work properly |
Previous Message | Martin Spinassi | 2009-08-14 16:30:39 | Proxy for postgres |