PostgreSQL 9 supports master/master.<br><br><div class="gmail_quote">On Mon, Feb 20, 2012 at 11:32 AM, Geoffrey Myers <span dir="ltr"><<a href="mailto:lists@serioustechnology.com">lists@serioustechnology.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="im">Chris Fowler wrote:<br>
> On Sat, 2012-02-18 at 15:05 -0500, Michael Trausch wrote:<br>
>> You need some way to take out an atomic lock... or, use a message<br>
>> queue.<br>
>><br>
>> E.g., one system processes the new things and inserts their data into<br>
>> a message queue, and you can then have N workers (where "N" is "as<br>
>> many as needed on average) to pop things off the queue and send mails<br>
>> based on the content of the message.<br>
>><br>
>> --<br>
><br>
> Yea I know, but have one system (server) put things in a queue for the<br>
> other servers to process would defeat the cluster. I'd like to have 3<br>
> servers anywhere in the US and then still run if 2 die. These apps<br>
> would need to know the health of the others. Bunch of work.<br>
><br>
> Normally this is one process on one server. I want to make it redundant<br>
> and am ready to do Master-Master-N cluster. I now do Master-Slave and<br>
> then promote the slave manually.<br>
<br>
</div>I don't think Postgresql supports master-master, but I've not looked<br>
into it for a while.<br>
<div class="im HOEnZb"><br>
--<br>
Until later, Geoffrey<br>
<br>
"I predict future happiness for America if they can prevent<br>
the government from wasting the labors of the people under<br>
the pretense of taking care of them."<br>
- Thomas Jefferson<br>
</div><div class="HOEnZb"><div class="h5">_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>-- <br>James P. Kinney III<br><br>As long as the general population is passive, apathetic, diverted to
consumerism or hatred of the vulnerable, then the powerful can do as
they please, and those who survive will be left to contemplate the
outcome.<br>- <i><i><i><i>2011 Noam Chomsky<br><br><a href="http://heretothereideas.blogspot.com/" target="_blank">http://heretothereideas.blogspot.com/</a><br></i></i></i></i><br>