Re: Document reopen of output file via SIGHUP in pg_recvlogical

From: Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Document reopen of output file via SIGHUP in pg_recvlogical
Date: 2025-07-18 02:35:19
Message-ID: CAOzEurQ9fZKw+Ydr2=LUBr=XCmXzjA+u=xmKjj=7bA=BGNharA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, Jul 10, 2025 at 4:48 PM Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> wrote:
>
> 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?

Agreed.
I have confirmed the behavior and I think it should be documented.

Your patch looks good, except that you should use "specified by"
instead of "given with" to be consistent with the other documents.

--
Best regards,
Shinya Kato
NTT OSS Center

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2025-07-18 03:33:36 Re: Document reopen of output file via SIGHUP in pg_recvlogical
Previous Message Fujii Masao 2025-07-17 23:30:31 Re: 2.4 Tutorial COPY weather.txt -- From where?