Re: Proxy for postgres

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 Master (or pg_pool2
> can be configured to write just in one of both?).
>

something like that.

see the pgpool-II tutorial at
http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html

note it also can do replication, but it does it at the front end rather
than the back end like slony. each has its advantages and disadvantages.
(I've also heard, repeatedly, that pgpool-II's replication isn't that great)