Re: Proxy for postgres

On Fri, 2009-08-14 at 10:03 -0700, John R Pierce wrote:
> Martin Spinassi wrote:
> > I'm searching for something to use as a proxy for different instances of
> > postgres.
> > ...
> > So the question is, what can I use as a proxy queries to different
> > instances of postgres?
> >
>
> perhaps if you better defined what you mean by 'proxy queries'... a
> 'proxy' is simply something authorized to act for another, and can mean
> many different things in computing.
>
> if your app needs to query different databases, it can simply open
> different connections to each of them.
>
> if your app needs to execute queries that join data stored in different
> databases, then there's really no solution that performs very well.
>

John,

Basically, what I'm searching for is something that relay sql to others
postgres instances.

The main goal is to have this proxy balancing, and better if it can
figure out when a postgres server is down. It would give me better
performance and will help mitigating the single point of failure, as I
can use HA for the proxy only.

The final idea is big, but I wanted to know what are the tools
available, end then start with it.

Cheers

Martin