pgsql: Implement "pg_ctl logrotate" command

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Implement "pg_ctl logrotate" command
Date: 2018-09-01 16:51:40
Message-ID: E1fw97c-0003QR-9f@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2018-09-01 19:13:13 pgsql: Add Greek characters to unaccent.rules.
Previous Message Noah Misch 2018-09-01 06:03:35 pgsql: Ignore server-side delays when enforcing wal_sender_timeout.