max_worker_processes on the standby - Mailing list pgsql-docs

From Fujii Masao
Subject max_worker_processes on the standby
Date
Msg-id CAHGQGwE48ViDkwybpxjXuf-trC87Ar1jdCHZ+ogtduoo3uvB8w@mail.gmail.com
Whole thread Raw
Responses Re: max_worker_processes on the standby  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-docs
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.

Regards,

--
Fujii Masao

Attachment

pgsql-docs by date:

Previous
From: Ian Barwick
Date:
Subject: Clarification for schema and schema object privileges
Next
From: Alvaro Herrera
Date:
Subject: Re: max_worker_processes on the standby