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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
