The Postgresql development team made an intentional design decided not
to include any one replication system into the main CVS tree simply
because there are many types of fundamentally different replication that
serve different purposes.
Slony is well tested, and is used in many production environments. It
is a master-slave replication system, it works quite well and is
supported by the slony team. I would not call it non-native. In
addition there are several other replication implementation that serve
different purposes, some are commercially supported by a vendor.
Please don't spread FUD about a system you don't understand. I have not
and would not say a single negative thing about mysql or its replication
because I don't have experience with it.
Matt
Simon Lange wrote:
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 :D
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niblett, David A
Sent: Wednesday, May 18, 2005 5:04 PM
To: '[email protected]'
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: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
