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
