View Issue Details

IDProjectCategoryView StatusLast Update
0000717Pgpool-IIBugpublic2021-07-19 12:00
Reporterdavid.peters Assigned Topengbo  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionopen 
Product Version4.2.2 
Summary0000717: pgpool-II-pg96-extensions.x86_64 missing files
Descriptioncannot create pgpool_recovery as the template is not present
Steps To Reproducebash-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$
TagsNo tags attached.

Activities

david.peters

2021-06-04 12:58

reporter   ~0003864

# 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

pengbo

2021-06-04 13:48

developer   ~0003865

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.

david.peters

2021-06-04 19:19

reporter   ~0003866

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

pengbo

2021-06-04 20:49

developer   ~0003867

Last edited: 2021-06-04 20:56

> 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?

pengbo

2021-07-19 10:36

developer   ~0003901

Have you resolved this issue?
May I close this issue?

david.peters

2021-07-19 11:50

reporter   ~0003902

this has been fixed, we can now close it

Issue History

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