Date: Wed, 15 Jul 2015 11:57:52 +0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: max_worker_processes on the standby
Message-ID: <20150715085751.GD2301@postgresql.org>
References: 
 <CAHGQGwE48ViDkwybpxjXuf-trC87Ar1jdCHZ+ogtduoo3uvB8w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAHGQGwE48ViDkwybpxjXuf-trC87Ar1jdCHZ+ogtduoo3uvB8w@mail.gmail.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Fujii Masao wrote:
> Hi,
> 
> "25.5.3. Administrator's Overview" in the document
> -----------------------------------------------------
> The setting of some parameters on the standby will need reconfiguration
> if they have been changed on the primary. For these parameters,
> the value on the standby must be equal to or greater than the value
> on the primary. If these parameters are not set high enough then
> the standby will refuse to start. Higher values can then be supplied
> and the server restarted to begin recovery again. These parameters are:
>     max_connections
>     max_prepared_transactions
>     max_locks_per_transaction
> -----------------------------------------------------
> 
> I found that the value of max_worker_processes on the standby also
> must be equal to or greater than the value on the master. So we should
> just add max_worker_processes to this paragraph. Patch attached.

True.  Also track_commit_timestamp.  Can you add a comment somewhere in
CheckRequiredParameterValues(void) that the set of parameters is listed
in section such-and-such in the docs, so that next time there's a higher
chance that the docs are kept up to date?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs