Content-Type: multipart/mixed; boundary="------------eb9N07q0qGebA6lJi95bcXxm"
Message-ID: <0977fc4f-1523-4ecd-8a0e-391af4976367@oss.nttdata.com>
Date: Thu, 10 Jul 2025 16:47:49 +0900
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-docs@lists.postgresql.org
From: Fujii Masao <masao.fujii@oss.nttdata.com>
Subject: Document reopen of output file via SIGHUP in pg_recvlogical
Archived-At: 
 <https://www.postgresql.org/message-id/0977fc4f-1523-4ecd-8a0e-391af4976367%40oss.nttdata.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------eb9N07q0qGebA6lJi95bcXxm
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

pg_recvlogical continuously writes to the file specified with the --file option,
which means the output file can grow indefinitely. To manage file size,
some users may want to rotate the output periodically.

While reviewing the source code to find the way to rotate the file, I noticed
that pg_recvlogical reopens the output file when it receives a SIGHUP signal.
This makes file rotation possible: we can rename the current output file and
then send a SIGHUP to pg_recvlogical, which will close the renamed file and
open a new one with the same original name.

This is a useful feature, but it's currently undocumented. So I'd like to
apply the attached patch that adds this information to the documentation.
Thought?

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation

--------------eb9N07q0qGebA6lJi95bcXxm
Content-Type: text/plain; charset=UTF-8;
 name="v1-0001-doc-Document-reopen-of-output-file-via-SIGHUP-in-.patch"
Content-Disposition: attachment;
 filename*0="v1-0001-doc-Document-reopen-of-output-file-via-SIGHUP-in-.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSAzZDBiMGRmNWQyMWI1NzBiYmRhNzUzNTNjOWJhMjMwZDA5MDdlMjUzIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v
cmc+CkRhdGU6IFRodSwgMTAgSnVsIDIwMjUgMTY6MjU6MTIgKzA5MDAKU3ViamVjdDogW1BB
VENIIHYxXSBkb2M6IERvY3VtZW50IHJlb3BlbiBvZiBvdXRwdXQgZmlsZSB2aWEgU0lHSFVQ
IGluCiBwZ19yZWN2bG9naWNhbC4KCldoZW4gcGdfcmVjdmxvZ2ljYWwgcmVjZWl2ZXMgYSBT
SUdIVVAgc2lnbmFsLCBpdCBjbG9zZXMgdGhlIGN1cnJlbnQKb3V0cHV0IGZpbGUgYW5kIHJl
b3BlbnMgYSBuZXcgb25lLiBUaGlzIGlzIHVzZWZ1bCBzaW5jZSBpdCBhbGxvd3MgdXMgdG8K
cm90YXRlIHRoZSBvdXRwdXQgZmlsZSBieSByZW5hbWluZyB0aGUgY3VycmVudCBmaWxlIGFu
ZCBzZW5kaW5nIGEgU0lHSFVQLgoKVGhpcyBiZWhhdmlvciB3YXMgcHJldmlvdXNseSB1bmRv
Y3VtZW50ZWQuIFRoaXMgY29tbWl0IGFkZHMKdGhlIG1pc3NpbmcgZG9jdW1lbnRhdGlvbi4K
LS0tCiBkb2Mvc3JjL3NnbWwvcmVmL3BnX3JlY3Zsb2dpY2FsLnNnbWwgfCAxMCArKysrKysr
KysrCiAxIGZpbGUgY2hhbmdlZCwgMTAgaW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL2Rv
Yy9zcmMvc2dtbC9yZWYvcGdfcmVjdmxvZ2ljYWwuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYv
cGdfcmVjdmxvZ2ljYWwuc2dtbAppbmRleCBmNjgxODIyNjZhOS4uM2M2NjcxNDE0OTUgMTAw
NjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvcGdfcmVjdmxvZ2ljYWwuc2dtbAorKysgYi9k
b2Mvc3JjL3NnbWwvcmVmL3BnX3JlY3Zsb2dpY2FsLnNnbWwKQEAgLTUzLDYgKzUzLDE2IEBA
IFBvc3RncmVTUUwgZG9jdW1lbnRhdGlvbgogICAgKDxrZXljb21ibyBhY3Rpb249InNpbXVs
Ij48a2V5Y2FwPkNvbnRyb2w8L2tleWNhcD48a2V5Y2FwPkM8L2tleWNhcD48L2tleWNvbWJv
PikKICAgIG9yIDxzeXN0ZW1pdGVtPlNJR1RFUk08L3N5c3RlbWl0ZW0+IHNpZ25hbC4KICAg
PC9wYXJhPgorCisgIDxwYXJhPgorICAgV2hlbiA8YXBwbGljYXRpb24+cGdfcmVjdmxvZ2lj
YWw8L2FwcGxpY2F0aW9uPiByZWNlaXZlcworICAgYSA8c3lzdGVtaXRlbT5TSUdIVVA8L3N5
c3RlbWl0ZW0+IHNpZ25hbCwgaXQgY2xvc2VzIHRoZSBjdXJyZW50IG91dHB1dCBmaWxlCisg
ICBhbmQgb3BlbnMgYSBuZXcgb25lIHVzaW5nIHRoZSBmaWxlbmFtZSBnaXZlbiB3aXRoCisg
ICB0aGUgPG9wdGlvbj4tLWZpbGU8L29wdGlvbj4gb3B0aW9uLiAgVGhpcyBhbGxvd3MgdXMg
dG8gcm90YXRlCisgICB0aGUgb3V0cHV0IGZpbGUgYnkgZmlyc3QgcmVuYW1pbmcgdGhlIGN1
cnJlbnQgZmlsZSBhbmQgdGhlbiBzZW5kaW5nCisgICBhIDxzeXN0ZW1pdGVtPlNJR0hVUDwv
c3lzdGVtaXRlbT4gc2lnbmFsIHRvCisgICA8YXBwbGljYXRpb24+cGdfcmVjdmxvZ2ljYWw8
L2FwcGxpY2F0aW9uPi4KKyAgPC9wYXJhPgogIDwvcmVmc2VjdDE+CiAKICA8cmVmc2VjdDE+
Ci0tIAoyLjQ5LjAKCg==

--------------eb9N07q0qGebA6lJi95bcXxm--