View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000717 | Pgpool-II | Bug | public | 2021-06-04 12:55 | 2021-07-19 12:00 |
| Reporter | david.peters | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.2.2 | ||||
| Summary | 0000717: pgpool-II-pg96-extensions.x86_64 missing files | ||||
| Description | cannot create pgpool_recovery as the template is not present | ||||
| Steps To Reproduce | bash-4.4$ psql template1 psql (9.6.20) Type "help" for help. template1=# CREATE EXTENSION pgpool_recovery; ERROR: could not open extension control file "/usr/share/pgsql/extension/pgpool_recovery.control": No such file or directory template1=# \q bash-4.4$ | ||||
| Tags | No tags attached. | ||||
|
|
# rpm -qa |grep pgpool pgpool-II-release-4.2-1.noarch pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 pgpool-II-pg96-devel-4.2.3-1pgdg.rhel8.x86_64 pgpool-II-pg96-extensions-debuginfo-4.2.3-1pgdg.rhel8.x86_64 pgpool-II-pg96-4.2.3-1pgdg.rhel8.x86_64 pgpool-II-pg96-debuginfo-4.2.3-1pgdg.rhel8.x86_64 |
|
|
Pgpool-II RPM is built using PostgreSQL distributed by PostgreSQL community (https://www.postgresql.org/download/linux/redhat/). If you are using PostgreSQL distributed by redhat, you need to build Pgpool-II RPM by yourself. |
|
|
Hi there, The older version of pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 has the missing files needed, this is a package by pgpool not RH, I have downloaded the older pgpool rpm and extracted that package and it contains the missing files but the pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 packages does not |
|
|
> The older version of pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 has the missing files needed, this is a package by pgpool not RH, I have downloaded the older pgpool rpm and extracted that package and it contains the missing files but the pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 packages does not The "pgpool_recovery.control" file will be installed under "/usr/pgsql-9.6/share/extension/" directory, not "/usr/share/pgsql/extension/". 4.2.2 and 4.2.3 include the same files. --- # rpm -qs pgpool-II-pg96-extensions-4.2.3-1pgdg.rhel8.x86_64 | grep pgpool_recovery.control ... /usr/pgsql-9.6/share/extension/pgpool_recovery.control --- --- rpm -qs pgpool-II-pg96-extensions-4.2.2-1pgdg.rhel8.x86_64 | grep pgpool_recovery.control ... /usr/pgsql-9.6/share/extension/pgpool_recovery.control --- Did you install 4.2.2 using the RPM provided by PostgreSQL community? |
|
|
Have you resolved this issue? May I close this issue? |
|
|
this has been fixed, we can now close it |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-06-04 12:55 | david.peters | New Issue | |
| 2021-06-04 12:58 | david.peters | Note Added: 0003864 | |
| 2021-06-04 13:09 | pengbo | Assigned To | => pengbo |
| 2021-06-04 13:09 | pengbo | Status | new => assigned |
| 2021-06-04 13:48 | pengbo | Note Added: 0003865 | |
| 2021-06-04 13:49 | pengbo | Status | assigned => feedback |
| 2021-06-04 19:19 | david.peters | Note Added: 0003866 | |
| 2021-06-04 19:19 | david.peters | Status | feedback => assigned |
| 2021-06-04 20:49 | pengbo | Note Added: 0003867 | |
| 2021-06-04 20:56 | pengbo | Note Edited: 0003867 | |
| 2021-06-08 13:41 | pengbo | Status | assigned => feedback |
| 2021-07-19 10:36 | pengbo | Note Added: 0003901 | |
| 2021-07-19 11:50 | david.peters | Note Added: 0003902 | |
| 2021-07-19 11:50 | david.peters | Status | feedback => assigned |
| 2021-07-19 12:00 | pengbo | Status | assigned => closed |