View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000783 | Pgpool-II | Bug | public | 2023-02-03 13:58 | 2023-02-10 09:40 |
| Reporter | Cidy Long | Assigned To | pengbo | ||
| Priority | urgent | Severity | crash | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Platform | Linux | OS | Centos Stream | OS Version | 9 |
| Product Version | 4.4.1 | ||||
| Summary | 0000783: "CREATE EXTENSION pgpool_recovery" failed. | ||||
| Description | Refer to [8.2.6.8. Pgpool-II Online Recovery Configurations] of pgpool 4.4.2 documentation. In order to use the online recovery functionality, the functions of pgpool_recovery, pgpool_remote_start, pgpool_switch_xlog are required, so we need to install pgpool_recovery on template1 of PostgreSQL server server1. on my postgresql master server. run: [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" -p 5433 failed. with error | ||||
| Steps To Reproduce | Follow instruction of pgpool-II documentation 4.4.2 until [8.2.6.8. Pgpool-II Online Recovery Configurations] In order to use the online recovery functionality, the functions of pgpool_recovery, pgpool_remote_start, pgpool_switch_xlog are required, so we need to install pgpool_recovery on template1 of PostgreSQL server server1. [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" -p 5433 response: ERROR: extension "pgpool_recovery" is not available DETAIL: Could not open extension control file "/usr/share/pgsql/extension/pgpool_recovery.control": No such file or directory. HINT: The extension must first be installed on the system where PostgreSQL is running. Try to find file [pgpool_recovery.control] by root user; response: /usr/pgsql-15/share/extension/pgpool_recovery.control Try to make a symbol link by root user ln -s /usr/pgsql-15/share/extension/pgpool_recovery.control /usr/share/pgsql/extension/pgpool_recovery.control run: [ [server1]# su - postgres [server1]$ psql template1 -c "CREATE EXTENSION pgpool_recovery" -p 5433 ] again. response: [ ERROR: extension "pgpool_recovery" has no installation script nor update path for version "1.4" ] | ||||
| Additional Information | Please advise a direction. | ||||
| Tags | No tags attached. | ||||
|
|
To run "CREATE EXTENSION pgpool_recovery" the srcipt "/usr/pgsql-15/share/extension/pgpool_recovery--1.4.sql" is required. Because Pgpool-II-pg15* pacakges are built for PostgreSQL 15 which is installed in /usr/pgsql-15, the scripts are installed under "/usr/pgsql-15/share/extension/". To install the extensions to other path, the best way is to build the source code to install pgpool extensions. https://www.pgpool.net/docs/latest/en/html/install-pgpool-recovery.html |
