View Issue Details

IDProjectCategoryView StatusLast Update
0000580Pgpool-IIBugpublic2020-01-28 11:45
ReportergiminniAssigned Topengbo 
PrioritynormalSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Product Version4.1.0 
Target VersionFixed in Version 
Summary0000580: 4.1: BUG: Pgpool_recovery extension protocol has two more parameters
DescriptionDownloaded and compiled source tarball results in beeing unable to create the pgpool_recovery extension.

Looked into pgpool_recovery.sql I found this:
CREATE OR REPLACE FUNCTION pgpool_recovery(text, text, text, text)

New protocol has two more parameter, so I added integer and text
CREATE OR REPLACE FUNCTION pgpool_recovery(text, text, text, text, integer, text)

After creating the extension I was able to execute pcp_recovery_node
TagsNo tags attached.

Activities

pengbo

2020-01-28 11:44

developer   ~0003092

"pgpool_recovery.sql" is the old version, you need to use "pgpool_recovery--1.3.sql" for the latest version.

$ ll src/sql/pgpool-recovery/
合計 56
-rw-rw-r-- 1 pengbo pengbo 790 1月 28 11:20 Makefile
-rw-rw-r-- 1 pengbo pengbo 10460 1月 28 11:20 pgpool-recovery.c
-rw-rw-r-- 1 pengbo pengbo 533 1月 28 11:12 pgpool-recovery.sql.in
-rw-rw-r-- 1 pengbo pengbo 407 1月 28 11:12 pgpool_recovery--1.0--1.1.sql
-rw-rw-r-- 1 pengbo pengbo 791 1月 28 11:12 pgpool_recovery--1.0.sql
-rw-rw-r-- 1 pengbo pengbo 429 1月 28 11:20 pgpool_recovery--1.1--1.2.sql
-rw-rw-r-- 1 pengbo pengbo 1002 1月 28 11:12 pgpool_recovery--1.1.sql
-rw-rw-r-- 1 pengbo pengbo 447 1月 28 11:20 pgpool_recovery--1.2--1.3.sql
-rw-rw-r-- 1 pengbo pengbo 1243 1月 28 11:20 pgpool_recovery--1.2.sql
-rw-rw-r-- 1 pengbo pengbo 1508 1月 28 11:20 pgpool_recovery--1.3.sql
-rw-rw-r-- 1 pengbo pengbo 178 1月 28 11:20 pgpool_recovery.control
-rw-rw-r-- 1 pengbo pengbo 136 1月 28 11:12 uninstall_pgpool-recovery.sql

$ cat src/sql/pgpool-recovery/pgpool_recovery.control
# pgpool-recovery extension
comment = 'recovery functions for pgpool-II for V4.1 or later'
default_version = '1.3'
...


To install all of the pgpool_recovery function, you can also use "CREATE EXTENSION" instead of executing "pgpool_recovery--1.3.sql".

(1) Install pgpool-recoevry
# cd src/sql/pgpool-recovery/
# make && make install

(2) Create extension on PostgreSQL backend server
# psql
=# CREATE EXTENSION pgpool_recovery;

Issue History

Date Modified Username Field Change
2020-01-28 02:23 giminni New Issue
2020-01-28 11:44 pengbo Note Added: 0003092
2020-01-28 11:45 pengbo Assigned To => pengbo
2020-01-28 11:45 pengbo Status new => feedback