Re: Postgresql replication
От | William Yu |
---|---|
Тема | Re: Postgresql replication |
Дата | |
Msg-id | dekc2c$1pqm$1@news.hub.org обсуждение исходный текст |
Ответ на | Re: Postgresql replication (Bohdan Linda <bohdan.linda@seznam.cz>) |
Ответы |
Re: Postgresql replication
|
Список | pgsql-general |
As far as I know, nobody has a generic solution for multi-master replication where servers are not in close proximity. Single master replication? Doable. Application specific conflict resolution? Doable. Off the shelf package that somehow knows financial transactions on a server shouldn't be duplicated on another? Uhh...I'd be wary of trying it out myself. Bohdan Linda wrote: > I would have a slight offtopic question, this is issue only of pgsql or > there are some other db solutions which have good performance when doing > this kind of replication across the world. > > Regards, > Bohdan > > On Thu, Aug 25, 2005 at 09:01:49AM +0200, William Yu wrote: > >>It provides pseudo relief if all your servers are in the same building. >>Having a front-end pgpool connector pointing to servers across the world >>is not workable -- performance ends up being completely decrepit due to >>the high latency. >> >>Which is the problem we face. Great, you've got multiple servers for >>failover. Too bad it doesn't do much good if your building gets hit by >>fire/earthquake/hurricane/etc.
В списке pgsql-general по дате отправления: