[OPEN-ILS-GENERAL] Ripping slony out for replication
Joshua D. Drake
jd at commandprompt.com
Fri Dec 21 15:24:37 EST 2012
Hello,
So I was told that if I was able to rip slony out for replication of
PostgreSQL with Evergreen, that the Evergreen community would be
interested in this.
Well, you can, easily. If you are running PostgreSQL 9.0 or above, you
do not need Slony as long as you are replicating the full database.
Further, replication can be synchronous and yes, it works with PgPool
for load balancing. All you need is Hot Standby.
The benefits are:
Easier upgrades
Easier management
Better Stability
One less external component
Very easy backups
True High Availability
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579
More information about the Open-ils-general
mailing list