[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