[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