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 1kcvx5-0003r2-TW for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Nov 2020 19:38:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kcvx4-0004DW-RC for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Nov 2020 19:38:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kcvx4-0004DP-Cq for pgsql-hackers@lists.postgresql.org; Wed, 11 Nov 2020 19:38:42 +0000 Received: from forward501j.mail.yandex.net ([2a02:6b8:0:801:2::111]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kcvwy-0006A0-Hl for pgsql-hackers@postgresql.org; Wed, 11 Nov 2020 19:38:41 +0000 Received: from mxback13g.mail.yandex.net (mxback13g.mail.yandex.net [IPv6:2a02:6b8:0:1472:2741:0:8b7:92]) by forward501j.mail.yandex.net (Yandex) with ESMTP id 665E933802B6; Wed, 11 Nov 2020 22:38:32 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback13g.mail.yandex.net (mxback/Yandex) with ESMTP id 9VnvkE1UfB-cUYWW44g; Wed, 11 Nov 2020 22:38:31 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail; t=1605123511; bh=5cpJw5yw6veqYq/w6bh7ePZbAOnupwInFv3K/RnZtIA=; h=Message-Id:Cc:Subject:In-Reply-To:Date:References:To:From; b=PhaLKK5cWBMp9NYZWaw8nsjFdKJKeHYKHfGsRPVoMV2B7lzA+0XTgOiUV5aVkvlb2 gVIM0emepwJQqcii2NAe6nx1VwaGAVbfWfrq2OewuW6X+KcNTAF7ea02/k8LG8DO5S 0Dh86BSfTxmC3K/XeI5iM4ZgM7VKvmMEu8fWD0PU= Authentication-Results: mxback13g.mail.yandex.net; dkim=pass header.i=@zsrv.org Received: by iva4-35f072fa8e4e.qloud-c.yandex.net with HTTP; Wed, 11 Nov 2020 22:38:30 +0300 From: Sergei Kornilov To: Fujii Masao , Kyotaro Horiguchi , "a.lubennikova@postgrespro.ru" Cc: "robertmhaas@gmail.com" , "michael@paquier.xyz" , "andres@anarazel.de" , "peter.eisentraut@2ndquadrant.com" , "pgsql-hackers@postgresql.org" In-Reply-To: References: <20200809052149.GB17986@paquier.xyz> <1741c40b-73e3-133b-77e6-05ebc7bf3c0f@postgrespro.ru> <20201022.110026.524650499365127827.horikyota.ntt@gmail.com> <4920201603879284@mail.yandex.ru> <0e0d5982-ac64-818d-1ec6-18a80b9300b1@oss.nttdata.com> <56311604665173@mail.yandex.ru> <108021604695421@mail.yandex.ru> Subject: Re: Allow some recovery parameters to be changed with reload MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 11 Nov 2020 22:38:30 +0300 Message-Id: <194171605123306@mail.yandex.ru> Content-Type: multipart/mixed; boundary="----==--bound.108815.iva4-35f072fa8e4e.qloud-c.yandex.net" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------==--bound.108815.iva4-35f072fa8e4e.qloud-c.yandex.net Content-Transfer-Encoding: 7bit Content-Type: text/plain Hello > Anyway, for now I think that your first patch would be enough, i.e., > just change the context of restore_command to PGC_SIGHUP. Glad to hear. Attached a rebased version of the original proposal. regards, Sergei ------==--bound.108815.iva4-35f072fa8e4e.qloud-c.yandex.net Content-Disposition: attachment; filename="v3_restore_command_reload.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name="v3_restore_command_reload.patch" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbCBiL2RvYy9zcmMvc2dtbC9jb25m aWcuc2dtbAppbmRleCBmMDQzNDMzZTMxLi5lYzc0Y2I0M2FkIDEwMDY0NAotLS0gYS9kb2Mvc3Jj L3NnbWwvY29uZmlnLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCkBAIC0zNTQy LDcgKzM1NDIsOCBAQCByZXN0b3JlX2NvbW1hbmQgPSAnY29weSAiQzpcXHNlcnZlclxcYXJjaGl2 ZWRpclxcJWYiICIlcCInICAjIFdpbmRvd3MKICAgICAgICA8L3BhcmE+CiAKICAgICAgICA8cGFy YT4KLSAgICAgICAgVGhpcyBwYXJhbWV0ZXIgY2FuIG9ubHkgYmUgc2V0IGF0IHNlcnZlciBzdGFy dC4KKyAgICAgICAgVGhpcyBwYXJhbWV0ZXIgY2FuIG9ubHkgYmUgc2V0IGluIHRoZSA8ZmlsZW5h bWU+cG9zdGdyZXNxbC5jb25mPC9maWxlbmFtZT4KKyAgICAgICAgZmlsZSBvciBvbiB0aGUgc2Vy dmVyIGNvbW1hbmQgbGluZS4KICAgICAgICA8L3BhcmE+CiAgICAgICA8L2xpc3RpdGVtPgogICAg ICA8L3Zhcmxpc3RlbnRyeT4KZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3Vj LmMgYi9zcmMvYmFja2VuZC91dGlscy9taXNjL2d1Yy5jCmluZGV4IGJiMzQ2MzBlOGUuLmE3MzIy NzlmNTIgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjLmMKKysrIGIvc3Jj L2JhY2tlbmQvdXRpbHMvbWlzYy9ndWMuYwpAQCAtMzY5OSw3ICszNjk5LDcgQEAgc3RhdGljIHN0 cnVjdCBjb25maWdfc3RyaW5nIENvbmZpZ3VyZU5hbWVzU3RyaW5nW10gPQogCX0sCiAKIAl7Ci0J CXsicmVzdG9yZV9jb21tYW5kIiwgUEdDX1BPU1RNQVNURVIsIFdBTF9BUkNISVZFX1JFQ09WRVJZ LAorCQl7InJlc3RvcmVfY29tbWFuZCIsIFBHQ19TSUdIVVAsIFdBTF9BUkNISVZFX1JFQ09WRVJZ LAogCQkJZ2V0dGV4dF9ub29wKCJTZXRzIHRoZSBzaGVsbCBjb21tYW5kIHRoYXQgd2lsbCBiZSBj YWxsZWQgdG8gcmV0cmlldmUgYW4gYXJjaGl2ZWQgV0FMIGZpbGUuIiksCiAJCQlOVUxMCiAJCX0s CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1w bGUgYi9zcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUKaW5kZXgg OWNiNTcxZjdjYy4uOWM5MDkxZTYwMSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvbWlz Yy9wb3N0Z3Jlc3FsLmNvbmYuc2FtcGxlCisrKyBiL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9z dGdyZXNxbC5jb25mLnNhbXBsZQpAQCAtMjUzLDcgKzI1Myw2IEBACiAJCQkJIyBwbGFjZWhvbGRl cnM6ICVwID0gcGF0aCBvZiBmaWxlIHRvIHJlc3RvcmUKIAkJCQkjICAgICAgICAgICAgICAgJWYg PSBmaWxlIG5hbWUgb25seQogCQkJCSMgZS5nLiAnY3AgL21udC9zZXJ2ZXIvYXJjaGl2ZWRpci8l ZiAlcCcKLQkJCQkjIChjaGFuZ2UgcmVxdWlyZXMgcmVzdGFydCkKICNhcmNoaXZlX2NsZWFudXBf Y29tbWFuZCA9ICcnCSMgY29tbWFuZCB0byBleGVjdXRlIGF0IGV2ZXJ5IHJlc3RhcnRwb2ludAog I3JlY292ZXJ5X2VuZF9jb21tYW5kID0gJycJIyBjb21tYW5kIHRvIGV4ZWN1dGUgYXQgY29tcGxl dGlvbiBvZiByZWNvdmVyeQogCg== ------==--bound.108815.iva4-35f072fa8e4e.qloud-c.yandex.net--