Re[2]: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-05 Thread Jeff Brenton
Hello Ryan, >> thanx for info; do you know if mysql4 supports what i want? i need the >> mysql4 configured on 2 hosts with master-master databases. both dbs >> should sync their data [replication] but it should be possible to write >> in both dbs. RB> I'm pretty sure it doesn't. I thought I re

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-05 Thread Joby Walker
armin langhofer wrote: hi roel thanx for info; do you know if mysql4 supports what i want? i need the mysql4 configured on 2 hosts with master-master databases. both dbs should sync their data [replication] but it should be possible to write in both dbs. armin. Doesn't look like it: ht

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-05 Thread Ryan Butler
On Thu, 2002-12-05 at 12:17, armin langhofer wrote: > hi roel > > thanx for info; do you know if mysql4 supports what i want? i need the > mysql4 configured on 2 hosts with master-master databases. both dbs > should sync their data [replication] but it should be possible to write > in both dbs.

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-05 Thread armin langhofer
hi roel thanx for info; do you know if mysql4 supports what i want? i need the mysql4 configured on 2 hosts with master-master databases. both dbs should sync their data [replication] but it should be possible to write in both dbs. armin. Roel Rozendaal - IC&S schrieb: Hi armin, haven't t

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-05 Thread
Hi armin, haven't tested it for myself yet but as the c interface has not changed dbmail should work with mysql 4 - in fact some people on this list are currently using it. Apparently you have to include the z library (-lz as a linker option) to have it build. Good luck! regards roel armin

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-04 Thread Joby Walker
You are looking at two different capabilities: Replication, Fallover. The Replication would be done with the database. Then Fallover would be done through some other system which would redirect the smtp or pop request to an available service. You might want to check out Wackamole: http://ww

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-04 Thread armin langhofer
hi hans, hi jbw i read the first terms of the drbd howto. the problem i figured out is, that dbmail would store the new mails only on one host and if that host fails the "secondary" host can not store the data. the same is for postgres-r, jbw i was looking for a solution which gives me the

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-04 Thread Hans Kula
: "armin langhofer" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 04, 2002 7:49 PM Subject: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix > hi > > i'm trying to set up 2 redundant dbmail hosts. the main goal is, that > the first host retreiv

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-04 Thread Joby Walker
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 P

[Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

2002-12-04 Thread armin langhofer
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 w