Re: Further Hot Standby documentation required

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Further Hot Standby documentation required
Date: 2010-05-03 17:03:27
Message-ID: 1272906207.4161.35011.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2010-05-03 at 10:50 +0100, Simon Riggs wrote:
> On Mon, 2010-05-03 at 12:17 +0300, Heikki Linnakangas wrote:
>
> > >> * wal_level doesn't describe what the impacts are on a standby if the
> > >> level is changed on the primary, nor is there a caution or a warning of
> > >> any kind. For example, if a standby is setup with hot_standby = on and
> > >> the primary is set wal_level = archive, does the standby start working
> > >> if the primary changes wal_level = hot_standby? What happens if the
> > >> primary is set wal_level = hot_standby and is then changed to archive?
> >
> > Hmm, feels like it should rather be documented in the hot_standby
> > setting, it affects the standby not the master after all.
>
> Danger of action at a distance. The change is on the master, but the
> effect is on the standby. The person changing the master must be warned
> of the danger that they will bring down the standby, so it must go with
> the parameter, not only with the HS docs.

Don't really understand why you left that bit out.

Are you just leaving this for me, or is there a specific objection to
adding the warning?

--
Simon Riggs www.2ndQuadrant.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-05-03 17:06:03 Re: missing file in git repo
Previous Message Simon Riggs 2010-05-03 17:02:47 Re: max_standby_delay considered harmful