[OPEN-ILS-GENERAL] Ripping slony out for replication

[Justin Hopkins]

We also use Postgres native streaming replication with success.

Regards,
Justin Hopkins
Manager, Information Technology
MOBIUS Consortium Office
c: 573-808-2309

--sent from a mobile device--

On Dec 21, 2012, at 2:31 PM, "Joshua D. Drake" <jd at commandprompt.com> wrote:

>
> 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