From 5e8a592135bf6c48f5a622acb8b365fc3b0579af Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Sun, 10 Jul 2022 10:28:06 +0900 Subject: [PATCH] Fix pgpool_recovery extension script. It lack 6-argument form of pgpool_recovery (used by v4.2). As a result, if 4.3 extension is already installed, pgpool_setup fails because it wants 6-argument form of pgpool_recovery. --- src/sql/pgpool-recovery/pgpool_recovery--1.4.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/src/sql/pgpool-recovery/pgpool_recovery--1.4.sql b/src/sql/pgpool-recovery/pgpool_recovery--1.4.sql index b82d827d5..7c15e3da2 100644 --- a/src/sql/pgpool-recovery/pgpool_recovery--1.4.sql +++ b/src/sql/pgpool-recovery/pgpool_recovery--1.4.sql @@ -12,6 +12,16 @@ RETURNS bool AS 'MODULE_PATHNAME', 'pgpool_recovery' LANGUAGE C STRICT; +CREATE FUNCTION pgpool_recovery(IN script_name text, + IN remote_host text, + IN remote_data_directory text, + IN primary_port text, + IN remote_node integer, + IN remote_port text) +RETURNS bool +AS '$libdir/pgpool-recovery', 'pgpool_recovery' +LANGUAGE C STRICT; + CREATE FUNCTION pgpool_recovery(IN script_name text, IN remote_host text, IN remote_data_directory text, -- 2.39.5