Thread: pg_recvlogical use of SIGHUP
There is some undocumented (nothing in the docs) code that allows for closing reopening the output file for pg_recvlogical.
Since this doesn't change the name of the file in the process I'm wondering how one might actually use this "feature" ?
I could see it being useful if we were to be able to change the file name and create a new file based on some form of template ?
Am I missing something ?
Dave Cramer
Hi, On 2018-07-06 13:49:37 -0400, Dave Cramer wrote: > There is some undocumented (nothing in the docs) code that allows for > closing reopening the output file for pg_recvlogical. > > Since this doesn't change the name of the file in the process I'm wondering > how one might actually use this "feature" ? You can rename the file, then sighup, no? Renaming while the file is open will continue to write into the renamed file, but sighup'ing will use the original name. Greetings, Andres Freund
On 6 July 2018 at 14:11, Andres Freund <andres@anarazel.de> wrote:
Hi,
On 2018-07-06 13:49:37 -0400, Dave Cramer wrote:
> There is some undocumented (nothing in the docs) code that allows for
> closing reopening the output file for pg_recvlogical.
>
> Since this doesn't change the name of the file in the process I'm wondering
> how one might actually use this "feature" ?
You can rename the file, then sighup, no? Renaming while the file is
open will continue to write into the renamed file, but sighup'ing will
use the original name.
That is the missing piece, thanks!
I'll prepare a patch for the docs
Dave Cramer
On 6 July 2018 at 14:11, Andres Freund <andres@anarazel.de> wrote:Hi,
On 2018-07-06 13:49:37 -0400, Dave Cramer wrote:
> There is some undocumented (nothing in the docs) code that allows for
> closing reopening the output file for pg_recvlogical.
>
> Since this doesn't change the name of the file in the process I'm wondering
> how one might actually use this "feature" ?
You can rename the file, then sighup, no? Renaming while the file is
open will continue to write into the renamed file, but sighup'ing will
use the original name.That is the missing piece, thanks!I'll prepare a patch for the docs
See attached patch.