[GENERAL] Proxy for postgres

2009-08-14 Thread Martin Spinassi
Hi list! 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

Re: [GENERAL] Proxy for postgres

2009-08-14 Thread Martin Spinassi
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

Re: [GENERAL] Proxy for postgres

2009-08-14 Thread Martin Spinassi
On Fri, 2009-08-14 at 11:04 -0700, John R Pierce wrote: Martin Spinassi wrote: I've been playing around with slony, and as far it didn't make me jump of happiness, I think is my better option to use slony for that, updating just the master, let slony do his job, but allowing the proxy

Re: [GENERAL] Proxy for postgres

2009-08-14 Thread Martin Spinassi
On Fri, 2009-08-14 at 11:36 -0700, John R Pierce wrote: Martin Spinassi wrote: So, what you suggest is: |- Master ---| pg_pool2 ---||- Slony |- Slave---| Can't figure out if this is gonna work, configuring