pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL vs. Oracle vs. Microsoft
Date: Tue, 25 Jan 2005 16:46:48 -0500
Message-ID: <m3acqxtc53.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <Xns95D671D321E39rr8xca@200.46.204.72>
	<20050109180452.03723387.frank@wiles.org>
	<Xns95E45B94EC0Brr8xca@200.46.204.72>
	<41EFF265.40902@cheapcomplexdevices.com>
	<Xns95E48DBC11D84rr8xca@200.46.204.72>
	<12826.1106290803@sss.pgh.pa.us>
	<Xns95E5592AFCBFCrr8xca@200.46.204.72>
	<20050125175920.GA3392@gp.word-to-the-wise.com>

Centuries ago, Nostradamus foresaw when steve@blighty.com (Steve Atkins) would write:
> As a bit of obPostgresql, though... While the registry for .org is
> run on Postgresql, the actual DNS is run on Oracle. That choice was
> driven by the availability of multi-master replication.
>
> Like many of the cases where the problem looks like it needs
> multi-master replication, though, it doesn't really need it. A
> single master at any one time, but with the ability to dub any of
> the slaves a new master at any time would be adequate. If that were
> available for Postgresql I'd choose it over Oracle were I doing a
> big distributed database backed system again.

Well, this is something that actually _IS_ available for PostgreSQL in
the form of Slony-I.  Between "MOVE SET" (that does controlled
takeover) and "FAILOVER" (that recovers from the situation where a
'master' node craters), this has indeed become available.

Automating activation of the failover process isn't quite there yet,
though that's mostly a matter that the methodology would involve
considerable tuning of recovery scripts to system behaviour.
-- 
select 'cbbrowne' || '@' || 'ntlug.org';
http://cbbrowne.com/info/slony.html
Pay no attention to the PDP-11 behind the front panel.
-- PGS, in reference to OZ



view thread (46+ messages)  latest in thread

Message-ID: <m3acqxtc53.fsf@knuth.knuth.cbbrowne.com>
Permalink:  ../m3acqxtc53.fsf@knuth.knuth.cbbrowne.com/
Also on:    postgresql.org/message-id/m3acqxtc53.fsf@knuth.knuth.cbbrowne.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: PostgreSQL vs. Oracle vs. Microsoft
  In-Reply-To: <m3acqxtc53.fsf@knuth.knuth.cbbrowne.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox