[ale] Sync Postgres to second server for fault tolerance

Geoffrey lists at serioustechnology.com
Tue Jul 28 14:02:34 EDT 2009


James Taylor wrote:
> I need a method to keep a second postgres database in sync so that I
> can quickly make the second server live in the event of a system
> failure, or if I need to do maintenance.
> 
> I found this, which looks fairly easy to implement.
> 
> https://developer.skype.com/SkypeGarage/DbProjects/SkyTools Is
> recommended, or is the another, better solution?

Sorry, never heard of it.

I've done extensive research as well as two different implementations 
for just such a situation.  Wal shipping or slony.  Both have their pros 
and cons.  Both are relatively painless to set up.

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


More information about the Ale mailing list