Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZFESz-0003mg-Rj for pgsql-docs@arkaria.postgresql.org; Wed, 15 Jul 2015 04:38:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZFESy-0000ap-P4 for pgsql-docs@arkaria.postgresql.org; Wed, 15 Jul 2015 04:38:44 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZFESc-0000DU-VC for pgsql-docs@postgresql.org; Wed, 15 Jul 2015 04:38:23 +0000 Received: from mail-ie0-x236.google.com ([2607:f8b0:4001:c03::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZFESa-0002ov-N1 for pgsql-docs@postgresql.org; Wed, 15 Jul 2015 04:38:21 +0000 Received: by ieik3 with SMTP id k3so25821099iei.3 for ; Tue, 14 Jul 2015 21:38:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=voodlHBkJBW8Ou1mMpUlLo5MpRX6hnXzFWRJD9s2fMg=; b=fqI/eTaEKkUilwjhgzpCYxuQ7jXJpYbFC24uRw3Cb8H+kHh60dflNN6FS7c2R/H+b/ D1DuhYvk4V9WyvyUh6UHVzPZ/WpFoOzF58ApYWMpR5+4/l3EiqXouNEG5a4IkswnM/nN y2OgeYopDAcOnoEdp3Ns+JbA6VesZgI95LOJC0DwfZko/zry9alR3bK4KYD02EtOKrIF NFSIwjIyKpdTC7uSybBIRTrvUmQEIuKEeTQhv/kJTfHGv1Bj6t3wh/dMmrrXkFf1UlXY i4HiFaMc/+dW7kw7GJH1b57/l/cFKgaRSgUqZuI4soXG2S0Zf+/QkykJ6X86F9AYro5m 0cxw== MIME-Version: 1.0 X-Received: by 10.50.62.148 with SMTP id y20mr23702708igr.17.1436935099589; Tue, 14 Jul 2015 21:38:19 -0700 (PDT) Received: by 10.79.90.193 with HTTP; Tue, 14 Jul 2015 21:38:19 -0700 (PDT) Date: Wed, 15 Jul 2015 13:38:19 +0900 Message-ID: Subject: max_worker_processes on the standby From: Fujii Masao To: pgsql-docs Content-Type: multipart/mixed; boundary=047d7bdcab342d516b051ae286de X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --047d7bdcab342d516b051ae286de Content-Type: text/plain; charset=UTF-8 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 --047d7bdcab342d516b051ae286de Content-Type: text/x-patch; charset=US-ASCII; name="doc.patch" Content-Disposition: attachment; filename="doc.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ic4a1zyt0 KioqIGEvZG9jL3NyYy9zZ21sL2hpZ2gtYXZhaWxhYmlsaXR5LnNnbWwKLS0t IGIvZG9jL3NyYy9zZ21sL2hpZ2gtYXZhaWxhYmlsaXR5LnNnbWwKKioqKioq KioqKioqKioqCioqKiAyMDM1LDIwNDAgKioqKiBMT0c6ICBkYXRhYmFzZSBz eXN0ZW0gaXMgcmVhZHkgdG8gYWNjZXB0IHJlYWQgb25seSBjb25uZWN0aW9u cwotLS0gMjAzNSwyMDQ1IC0tLS0KICAgICAgICAgICA8dmFybmFtZT5tYXhf bG9ja3NfcGVyX3RyYW5zYWN0aW9uPC8+CiAgICAgICAgICA8L3BhcmE+CiAg ICAgICAgIDwvbGlzdGl0ZW0+CisgICAgICAgIDxsaXN0aXRlbT4KKyAgICAg ICAgIDxwYXJhPgorICAgICAgICAgIDx2YXJuYW1lPm1heF93b3JrZXJfcHJv Y2Vzc2VzPC8+CisgICAgICAgICA8L3BhcmE+CisgICAgICAgIDwvbGlzdGl0 ZW0+CiAgICAgICAgPC9pdGVtaXplZGxpc3Q+CiAgICAgPC9wYXJhPgogIAo= --047d7bdcab342d516b051ae286de Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --047d7bdcab342d516b051ae286de--