From:
Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To:
Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>,
"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Cascading replication: should we detect/prevent cycles?
Date:
2013-02-01 08:16:10
Message-ID:
510B79CA.6060108@catalyst.net.nz (view raw or flat )
Thread:
2012-12-19 03:03:43 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-19 07:57:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-19 08:11:55 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2012-12-19 08:34:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-19 17:08:59 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2012-12-19 22:14:56 from Joshua Berkus <josh(at)agliodbs(dot)com>
2012-12-20 13:04:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-20 22:28:43 from Joshua Berkus <josh(at)agliodbs(dot)com>
2012-12-21 14:08:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-05 20:50:05 from Joshua Berkus <josh(at)agliodbs(dot)com>
2013-01-05 21:21:11 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2013-01-08 18:46:12 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-01-08 19:51:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-08 22:06:43 from Daniel Farina <daniel(at)heroku(dot)com>
2013-01-09 01:51:58 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-01-09 01:59:43 from Daniel Farina <daniel(at)heroku(dot)com>
2013-01-09 09:11:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-27 11:30:02 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-01-27 16:23:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-27 18:13:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-02-01 01:01:33 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-02-01 02:48:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-02-02 18:41:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-02-01 07:43:03 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2013-02-01 08:16:10 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2013-02-01 10:19:05 from Craig Ringer <craig(at)2ndquadrant(dot)com>
2013-01-08 19:53:38 from David Fetter <david(at)fetter(dot)org>
2013-01-08 20:30:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-20 00:18:40 from Daniel Farina <daniel(at)heroku(dot)com>
Lists:
pgsql-hackers
On 01/02/13 20:43, Peter Geoghegan wrote:
>
>
> On Sunday, 27 January 2013, Robert Haas <robertmhaas(at)gmail(dot)com
> <mailto:robertmhaas(at)gmail(dot)com>> wrote:
> > If we're going to start installing safeguards against doing stupid
> > things, there's a long list of scenarios that happen far more
> > regularly than this ever will and cause far more damage.
>
> +1
+1
...and there are other areas that we could spend our energy on that
would be more worthwhile I think. One I'd like to see is the opposite of:
$ pg_ctl promote
i.e:
$ pg_ctl demote
So a "retired" master would read a (newly supplied perhaps)
recovery.conf and start to apply changes from there (with suitable
safeguards). We have failover pretty painless now... but reconstruction
of the original primary as a new standby is still too
fiddly/resource/time consuming etc.
Regards
Mark
In response to
pgsql-hackers by date
Next :From: Pavel StehuleDate: 2013-02-01 08:29:23Subject : Re: Unusually high IO for autovacuum workerPrevious :From : Vlad BailescuDate : 2013-02-01 08:14:29Subject : Unusually high IO for autovacuum worker
