BUG #17904: Inconsistent value of max_worker_processes parameter in the config file and running cluster

Lists: Postg메이저 토토 사이트SQL : Postg메이저 토토 사이트SQL 메일 링리스트 : 2023-04-19 이후 PGSQL-BUGS 19:54
From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: psadm999(at)gmail(dot)com
Subject: BUG #17904: Inconsistent value of max_worker_processes parameter in the config file and running cluster
Date: 2023-04-19 19:54:38
Message-ID: 17904-05f2c291bab3ffb7@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg메이저 토토 사이트SQL : Postg메이저 토토 사이트SQL 메일 링리스트 : 2023-04-19 이후 PGSQL-BUGS 19:54

The following bug has been logged on the website:

Bug reference: 17904
Logged by: Pawel
Email address: psadm999(at)gmail(dot)com
PostgreSQL version: 11.19
Operating system: Rocky8
Description:

Hi,
I'd like to report an issue I discovered recently.

Today I noticed very weird behavior when I was setting up PostgreSQL 11.19
cluster with binary replication.
The exact version: "PostgreSQL 11.19 on x86_64-pc-linux-gnu, compiled by gcc
(GCC) 8.5.0 20210514 (Red Hat 8.5.0-16), 64-bit" running on Rocky Linux
8.7.

Basically my primary server is starting with `max_worker_processes = 4`.
Unfortunately the secondary one created with pg_basebackup was not able to
start complaining:

"FATAL: hot standby is not possible because max_worker_processes = 4 is a
lower setting than on the master server (its value was 8)."

I double checked the configs on the primary (they were correct, ie.
max_worker_processes = 4, didn't forgot to remove the comment :) ). I
restarted the cluster, etc. Still the primary was showing
max_worker_processes=4 in psql but the secondary was complaining as before,
saying:
"FATAL: hot standby is not possible because max_worker_processes = 4 is a
lower setting than on the master server (its value was 8).".

My final attempt was to put the value in single quotes and after that it
worked - primary was showing 4 and the secondary managed to connect with the
same settings.

The documentation reg. postgresql.conf file states:
"Numeric (integer and floating point): A decimal point is permitted only for
floating-point parameters. Do not use thousands separators. Quotes are not
required."

It looks that the quotes actually are required, or it's a bug? This
particular case shows the parameter value without quotes is automatically
set to default value of 8, while the dbas see the value from the
configuration file.

BR,
Pawel