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" <[email protected]> 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
