PostgreSQL does not currently support replication. There are a couple trigger based solutions that provide master-slave or peer-peer operation, but these all provide Lazy syncronization.

The few integrated solutions only work in Master-Slave operation now.

The project that I am following is Postgres-R. It uses Ensamble or Spread to provide group communication, and will eventually provide Peer to Peer Eager sync. But currently they have only managed Master to Many Slave Eager sync, though they don't seem to be too far away from Master to Master.

http://gborg.postgresql.org/project/pgreplication/projdisplay.php

Page with links to other projects:
http://gborg.postgresql.org/genpage?replication_research

jbw

armin langhofer wrote:
hi

i'm trying to set up 2 redundant dbmail hosts. the main goal is, that the first host retreives [smtp] and provides [pop3] all mails if the second host went down and the other way round.

dbmail doesn't support mysql4; mysql3 doesn't support two master databases afaik so i compiled dbmail with postgresql support. i know that postgresql supports two master databases but i dont know how to configure psql.

has anyone experiences with that?
any other ideas?

dbmail + postgres + postfix is currently working on both machines.

thanx, armin.


_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to