View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000580 | Pgpool-II | Bug | public | 2020-01-28 02:23 | 2020-04-14 13:15 |
| Reporter | giminni | Assigned To | pengbo | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.1.0 | ||||
| Summary | 0000580: 4.1: BUG: Pgpool_recovery extension protocol has two more parameters | ||||
| Description | Downloaded 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 | ||||
| Tags | No tags attached. | ||||
|
|
"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; |
|
|
If you have resolved this issue, may I close it? |
| 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 |
| 2020-04-14 12:58 | pengbo | Note Added: 0003316 | |
| 2020-04-14 13:15 | pengbo | Status | feedback => closed |
