Re: pg_recvlogical use of SIGHUP

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: pg_recvlogical use of SIGHUP
Дата
Msg-id CADK3HHKC9hC9oo9qSi1JJHEVML9iHQ+=69H+rar4fsGsOym6UA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_recvlogical use of SIGHUP  (Andres Freund <andres@anarazel.de>)
Ответы Re: pg_recvlogical use of SIGHUP
Список pgsql-hackers
Дерево обсуждения




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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pgbench issue
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: "interesting" issue with restore from a pg_dump with adatabase-wide search_path