Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVrNv-00C9Cb-Jh for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Jan 2025 12:11:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tVrNu-000lfm-Sn for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Jan 2025 12:11:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVrNu-000lfd-KM for pgsql-bugs@lists.postgresql.org; Thu, 09 Jan 2025 12:11:34 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tVrNr-000jFL-0F for pgsql-bugs@lists.postgresql.org; Thu, 09 Jan 2025 12:11:33 +0000 Received: from [192.168.11.6] (p4062048-ipxg13601funabasi.chiba.ocn.ne.jp [153.216.203.48]) by oss.nttdata.com (Postfix) with ESMTPSA id 6D5DE61A12; Thu, 9 Jan 2025 21:11:26 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Message-ID: <10e94fed-70ab-4269-8145-41d05e55fa10@oss.nttdata.com> Date: Thu, 9 Jan 2025 21:11:25 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #18663: synchronous_standby_names vs synchronous_commit vs pg_stat_replication Content-Language: en-US From: Fujii Masao To: asphator@gmail.com, pgsql-bugs@lists.postgresql.org References: <18663-b02f75cb919f1b60@postgresql.org> <614200e4-9434-4aad-b44d-078bc6d5e65a@oss.nttdata.com> In-Reply-To: <614200e4-9434-4aad-b44d-078bc6d5e65a@oss.nttdata.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025/01/09 9:35, Fujii Masao wrote: > > > On 2024/10/21 18:43, Fujii Masao wrote: >> >> >> On 2024/10/18 23:48, PG Bug reporting form wrote: >>> The following bug has been logged on the website: >>> >>> Bug reference:      18663 >>> Logged by:          Asphator >>> Email address:      asphator@gmail.com >>> PostgreSQL version: 15.7 >>> Operating system:   RHEL7+ >>> Description: >>> >>> Hello >>> >>> I would like to raise 2 issues: >>> - documentation issue >>> - pg_stat_replication view issue in a very specific use case >>> >>> 1. Documentation >>> Regarding parameter synchronous_standby_names, I did not manage to find >>> anything in documentation preventing from setting value 0. The only thing >>> I've found is a comment in a commit of 2016. Would be nice to mention in >>> documentation that value must be a "positive" integer. >> >> Agreed. I've attached the patch. > > I made a slight wording adjustment. > Unless there are objections, I'll commit the attached patch. Pushed. Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION