Hello Thomas,

> I have one question left: I have a project with a very low budget
> (because it's private) and need a database with multimaster
> synchronisation, what should I use?

I believe that there is no ready to use application to do multimaster
database replication with a low budget.  We have written our own
replication service which synchronizes also large systems with several
master databases, however this is probably not suitable for you
(depends on how low your budget is;).

Basically we use the 'Latest Timestamp' method to do asynchron
replication.

However, there is one real 'master' where special tasks are running.
So it is possible to restore every other database from the 'master'
database.  E.g. if we update the database structure we delete every
database but the master (after all replication between peers is
finished), do the updates in the master and deploy the 'reference'
database to the several locations.

I'm sure you know this site, anyway it is a good point to start:
http://gborg.postgresql.org/genpage?replication_research

The most interesting I found is here:
http://snaga.org/pgsql/

HTHs,
Gerrit
-- 
=^..^=


Reply via email to