View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000784 | Pgpool-II | Bug | public | 2023-02-07 07:55 | 2023-02-10 09:42 |
| Reporter | Cidy Long | Assigned To | pengbo | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Platform | Linux | OS | Centos Stream | OS Version | 9 |
| Product Version | 4.4.1 | ||||
| Summary | 0000784: How to make pgpool-II extension work with postgresql-contrib together? | ||||
| Description | When we tried to use pgpool-II features with our existing project, we find there is conflict between [built-in postgresql] and [specific postgresql] for example postgresql15-server. We found there is no way to put postgresql-contrib (built in extension) and pgpool-II extension together. They are staying two separated locations such as: /usr/share/pgsql/extension and /usr/pgsql-15/share/extension | ||||
| Steps To Reproduce | Follow pgpool-II documentation (https://www.pgpool.net/docs/44/en/html/example-cluster.html) [8.2.3. Installation] Install PostgreSQL from PostgreSQL YUM repository. [all servers]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm [all servers]# yum install -y postgresql15-server Since Pgpool-II related packages are also included in PostgreSQL YUM repository, add the "exclude" settings to /etc/yum.repos.d/pgdg-redhat-all.repo so that Pgpool-II is not installed from PostgreSQL YUM repository. [all servers]# vi /etc/yum.repos.d/pgdg-redhat-all.repo The following is a setting example of /etc/yum.repos.d/pgdg-redhat-all.repo. [pgdg-common] ... exclude=pgpool* [pgdg15] ... exclude=pgpool* [pgdg14] ... exclude=pgpool* [pgdg13] ... exclude=pgpool* [pgdg12] ... exclude=pgpool* [pgdg11] ... exclude=pgpool* [pgdg10] ... exclude=pgpool* Install Pgpool-II from Pgpool-II YUM repository. [all servers]# yum install -y https://www.pgpool.net/yum/rpms/4.4/redhat/rhel-7-x86_64/pgpool-II-release-4.4-1.noarch.rpm [all servers]# yum install -y pgpool-II-pg15-* Up to here, we found pgpool-II related extensions (pgpool-recovery & pgpool_adm etc.) were installed into: /usr/pgsql-15/share/extension Then install postgresql-contrib by run [ dnf install postgresql-contrib ] But we found all extensions were installed into: /usr/share/pgsql/extension Problems started. if we start postgresql service with: init database by: [/usr/pgsql-15/bin/initdb -D $PGDATA] as document specified. start service by: [systemctl start postgresql15.service] when follow the procedure, postgresql con't found my postgresql-contrib extension if we start postgresql service with: init database by: [/usr/bin/initdb -D $PGDATA] as document specified. start service by: [systemctl start postgresql.service] when follow the procedure, postgresql con't found my pgpool-II extension Please advise a way to make pgpool-II and postgresql-contril wort together? | ||||
| Additional Information | This bug is a update and forward work for bug 783 | ||||
| Tags | No tags attached. | ||||
|
|
The best way is to build the source code to install Pgpool-II extensions. https://www.pgpool.net/docs/latest/en/html/install-pgpool-recovery.html |
