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<

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 slo

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 > > inst

[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 access