Check the number of potential synchronous standbys

From: 张文杰 <757634191(at)qq(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Check the number of potential synchronous standbys
Date: 2019-06-14 11:00:09
Message-ID: tencent_9102665063EC73FE8A037FEA09563D832306@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

When the number of potential synchronous standbys is smaller than num_sync, such as 'FIRST 3 (1,2)', 'ANY 4 (1,2,3)' in the synchronous_standby_names, the processes will wait for synchronous replication forever.


Obviously, it's not expected. I think return false and a error message may be better. And attached is a patch that implements the simple check.

What do you think about this?

--
Zhang Wenjie

Attachment Content-Type Size
check_synchronous_standby_names.patch application/octet-stream 1.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Khandekar 2019-06-14 11:24:19 Re: Minimal logical decoding on standbys
Previous Message Amit Kapila 2019-06-14 10:46:46 Re: POC: Cleaning up orphaned files using undo logs