Thread: db replication
hi..
i developing an aplication with a postgresql+postgis... i need to replicate the database to various pda, as well as insure the synchronization between all repliques...
can someone with experience tell me what is the best free solution to my problem?...
thanks...
andy...
i developing an aplication with a postgresql+postgis... i need to replicate the database to various pda, as well as insure the synchronization between all repliques...
can someone with experience tell me what is the best free solution to my problem?...
thanks...
andy...
On Fri, Jun 29, 2007 at 03:42:32PM +0100, andrew quaresma wrote: > hi.. > > i developing an aplication with a postgresql+postgis... i need to replicate > the database to various pda, as well as insure the synchronization between > all repliques... > > can someone with experience tell me what is the best free solution to my > problem?... AFAIK there isn't one. PDA replication requires disconnected multimaster asynchronous replication, and I don't know of a project that has delivered that yet. A -- Andrew Sullivan | ajs@crankycanuck.ca This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie
andrew quaresma wrote: > i developing an aplication with a postgresql+postgis... i need to replicate > the database to various pda, as well as insure the synchronization between > all repliques... > > can someone with experience tell me what is the best free solution to my > problem?... There is hardly experience with this out, as it does not exist :) You might abuse dblink or slony to hack that. -- Best regards, Hannes Dorbath