Hi, I happened to notice a typo in pg_rotate_logfile in ipc/signalfuncs.c - the hint message wrongly mentions that pg_logfile_rotate is part of the core; which is actually not. pg_logfile_rotate is an adminpack's 1.0 SQL function dropped in 2.0. The core defines pg_rotate_logfile SQL function instead, so use that. Here's a patch to fix the typo.
-- Bharath Rupireddy PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
From 18854ba341d892750fc75b9988ba107fe44e7c63 Mon Sep 17 00:00:00 2001 From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> Date: Mon, 12 Feb 2024 13:30:31 +0000 Subject: [PATCH v1] Fix a typo in pg_rotate_logfile --- src/backend/storage/ipc/signalfuncs.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/backend/storage/ipc/signalfuncs.c b/src/backend/storage/ipc/signalfuncs.c index 81d1a59659..c05a2af48b 100644 --- a/src/backend/storage/ipc/signalfuncs.c +++ b/src/backend/storage/ipc/signalfuncs.c @@ -284,7 +284,7 @@ pg_rotate_logfile(PG_FUNCTION_ARGS) errmsg("must be superuser to rotate log files with adminpack 1.0"), /* translator: %s is a SQL function name */ errhint("Consider using %s, which is part of core, instead.", - "pg_logfile_rotate()"))); + "pg_rotate_logfile()"))); if (!Logging_collector) { -- 2.34.1