Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfpRA-0003QJ-Mf for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Nov 2020 19:17:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfpR9-0007fg-El for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Nov 2020 19:17:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfpR9-0007fZ-2R for pgsql-hackers@lists.postgresql.org; Thu, 19 Nov 2020 19:17:43 +0000 Received: from forward501j.mail.yandex.net ([2a02:6b8:0:801:2::111]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfpR4-0003vJ-2J for pgsql-hackers@postgresql.org; Thu, 19 Nov 2020 19:17:41 +0000 Received: from mxback9g.mail.yandex.net (mxback9g.mail.yandex.net [IPv6:2a02:6b8:c03:7aa:0:640:d10:d80f]) by forward501j.mail.yandex.net (Yandex) with ESMTP id 03AB53380025; Thu, 19 Nov 2020 22:17:35 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback9g.mail.yandex.net (mxback/Yandex) with ESMTP id BMbJQw4LuI-HYdmmH1N; Thu, 19 Nov 2020 22:17:34 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail; t=1605813454; bh=X9ZIx4oKYk8JaxudO75tyyunQ7gS8QYBW3xTAlGNB0o=; h=Message-Id:Cc:Subject:In-Reply-To:Date:References:To:From; b=mioFpJPNn12GpEXjUOKIJCFWqq4ucUgV+MCEZSywGVa5VUielMuNun3HlV6uVeJ4C 8bemb4OQxP30FjLcSoUj66aLTnCI4k4Xv7ZPYL+p4hU9d4+sHXWtDY7clAUVw+Ya7c UMAr3v3NYK9ohGNwqDetPhe1eE1b8GCSI19BdYJo= Authentication-Results: mxback9g.mail.yandex.net; dkim=pass header.i=@zsrv.org Received: by iva6-22e79380f52c.qloud-c.yandex.net with HTTP; Thu, 19 Nov 2020 22:17:34 +0300 From: Sergei Kornilov To: Peter Eisentraut , PostgreSQL-development Cc: Masahiko Sawada , Kyotaro Horiguchi , =?utf-8?B?w4FsdmFybyBIZXJyZXJh?= In-Reply-To: <5e93f9f5-9572-38d0-b740-f8a20dfcc165@2ndquadrant.com> References: <20200310.175755.1250389993502025042.horikyota.ntt@gmail.com> <20200311.110637.1319131984113864409.horikyota.ntt@gmail.com> <2134a29f-e934-4585-e81f-ab416e1923be@2ndquadrant.com> <2808491585335240@iva3-67f911cb3a01.qloud-c.yandex.net> <5e93f9f5-9572-38d0-b740-f8a20dfcc165@2ndquadrant.com> Subject: Re: Improve handling of parameter differences in physical replication MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 19 Nov 2020 22:17:34 +0300 Message-Id: <2985371605808012@mail.yandex.ru> Content-Transfer-Encoding: 7bit Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello Thank you! I'm on vacation, so I was finally able to review the patch. Seems WAIT_EVENT_RECOVERY_PAUSE addition was lost during patch simplification. > ereport(FATAL, > (errmsg("recovery aborted because of insufficient parameter settings"), > errhint("You can restart the server after making the necessary configuration changes."))); I think we should repeat here conflicted param_name and minValue. pg_wal_replay_resume can be called days after recovery being paused. The initial message can be difficult to find. > errmsg("recovery will be paused") May be use the same "recovery has paused" as in recoveryPausesHere? It doesn't seem to make any difference since we set pause right after that, but there will be a little less work translators. Not sure about "If recovery is unpaused". The word "resumed" seems to have been usually used in docs. regards, Sergei