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