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
Martin Spinassi wrote:
So, what you suggest is:
|-> Master <---|
pg_pool2 ---||- Slony
|-> Slave<---|
Can't figure out if this is gonna work, configuring pg_pool2 to read
both, making slony replicate, and app directly to
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
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
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 i
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 somet
Have you tried sql relay? They support may platforms:
http://sqlrelay.sourceforge.net/
-Said
Martin Spinassi wrote:
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)
functio
> 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
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
