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...

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