[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] Sync Postgres to second server for fault tolerance
- Subject: [ale] Sync Postgres to second server for fault tolerance
- From: lists at serioustechnology.com (Geoffrey)
- Date: Tue, 28 Jul 2009 14:02:34 -0400
- In-reply-to: <[email protected]>
- References: <[email protected]>
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