varieties means ports?! branches of the original pgsql
source?! or are these
thridparty solutions which add external functionalities
which pgsql does not
provide? however, i would prefer a native replication
instead a workaround.
;) especially on productive environments. ;)
however dbmail/mysql provides a tested and working
clustering (circle
replication) with on fail solution for all those who may
need it. so why
using a pgsql with non-native replication if there is a
stable native mysql
replication solution available?
regards
Simon
Simon Lange //Director
========================
www.polynaturedesign.com
+49[0]4131 220121 PHONE
+49[0]4131 224730 FAX
+49[0]16090300077 CELL
========================
-----Original Message-----
From: dbmail-bounces dbmail.org [mailto:dbmail-bouncesdbmail.org] On Behalf
Of Matthew T. O'Connor
Sent: Wednesday, May 18, 2005 5:58 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] DbMail in a ISP Cluster
Postgresql does support replication, in fact there are
several different
varieties of it available, check out slony1 among others.
What it doesn't
support is automatic failover.
Simon Lange wrote:
>pgsql does not support replication. thats why we do use
mysql -
>clustering is announced for mysql5 
>
>if a database goes down, exim recognizes this and
temporaly refuses any
>mails which causing foreign mta to address the other
mta...
>
>regards
>
>Simon
>
>
>Simon Lange //Director
>========================
>www.polynaturedesign.com
>+49[0]4131 220121 PHONE
>+49[0]4131 224730 FAX
>+49[0]16090300077 CELL
>========================
>
>-----Original Message-----
>From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
>Behalf Of Niblett, David A
>Sent: Wednesday, May 18, 2005 5:04 PM
>To: 'dbmaildbmail.org'
>Subject: [Dbmail] DbMail in a ISP Cluster
>
>What are you all using to cluster PostgreSQL? I looked
at the
>master/slave replication that comes with Postgres. It
seems fine if
>you want to replicate the data, but how do you get
dbmail to switch
>databases when there is a failure?
>
>I'm currently using drbd to replicate the disk block
device that my
>postgres database is stored on, then only run postgres
on the "primary"
machine.
>Linux heartbeat fails and starts the services on the
"secondary"
>machine shold the first one croak.
>
>--
>David A. Niblett | email: niblettdagru.net
>Network Administrator | Phone: (352) 334-3400
>Gainesville Regional Utilities | Web: http://www.gru.net/
>
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>_______________________________________________
>Dbmail mailing list
>Dbmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
>
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|