pgsql: Implement "pg_ctl logrotate" command - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Implement "pg_ctl logrotate" command
Date
Msg-id E1fw97c-0003QR-9f@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Implement "pg_ctl logrotate" command

Currently there are two ways to trigger log rotation in logging collector
process: call pg_rotate_logfile() SQL-function or send SIGUSR1 signal directly
to logging collector process.  However, it's nice to have more suitable way
for external tools to do that, which wouldn't require SQL connection or
knowledge of logging collector pid.  This commit implements triggering log
rotation by "pg_ctl logrotate" command.

Discussion: https://postgr.es/m/20180416.115435.28153375.horiguchi.kyotaro%40lab.ntt.co.jp
Author: Kyotaro Horiguchi, Alexander Kuzmenkov, Alexander Korotkov

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ec74369931687885cfb6ce9dac55deefdb410086

Modified Files
--------------
doc/src/sgml/maintenance.sgml       | 34 +++++++++++++-
doc/src/sgml/ref/pg_ctl-ref.sgml    | 13 ++++++
src/backend/postmaster/postmaster.c | 18 ++++++--
src/backend/postmaster/syslogger.c  | 29 +++++++++++-
src/bin/pg_ctl/pg_ctl.c             | 89 ++++++++++++++++++++++++++++++++-----
src/bin/pg_ctl/t/004_logrotate.pl   | 42 +++++++++++++++++
src/include/postmaster/syslogger.h  |  3 ++
src/test/perl/PostgresNode.pm       | 21 +++++++++
8 files changed, 230 insertions(+), 19 deletions(-)


pgsql-committers by date:

Previous
From: Noah Misch
Date:
Subject: pgsql: Ignore server-side delays when enforcing wal_sender_timeout.
Next
From: Thomas Munro
Date:
Subject: pgsql: Add Greek characters to unaccent.rules.