View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000785 | Pgpool-II | Bug | public | 2023-02-12 07:41 | 2023-02-13 19:52 |
| Reporter | Cidy Long | Assigned To | pengbo | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Product Version | 4.4.1 | ||||
| Summary | 0000785: psql can't found $libdir/pgpool-recovery | ||||
| Description | built in Postgresql server was used, Additional extensions symbol links for pgpool-recovery from /usr/pgsql-15/share/extension to /usr/share/pgsql/extension/ re-run [su - postgres] & [psql template1 -p5433 -c "CREATE EXTENSION pgpool_recovery"] error throws: [ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory] | ||||
| Steps To Reproduce | Follow previous bug reports and Pengbo's feedback and note to add sql symbol link to centos 9 built in postgresql's extension directory. re-run [su - postgres] & [psql template1 -p5433 -c "CREATE EXTENSION pgpool_recovery"] error throws: [ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory] search pgpool-recovery lib, found it in /usr/pgsql-15/lib, file name as: pgpool-recovery.so update /etc/profile to add [LD_LIBRARY_PATH=$LD_LIBRARY_PAT:/usr/pgsql-15/lib] export LD_LIBRARY_PATH, reload profile, verified by run [printenv], LD_LIBRARY_PATH shows properly. re-run [psql template1 -p5433 -c "CREATE EXTENSION pgpool_recovery"] response same as previous error. [ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory] Very confused, check psql $libdir variables setting from postgresql document, seems there is nothing wrong. But not work. Please advise! | ||||
| Additional Information | This is an extension bug report for bug 783. | ||||
| Tags | No tags attached. | ||||
|
|
Pgpool-II extensions are not installed under LD_LIBRARY_PATH. If you wish to use the built in PostgreSQL, I think the only way is to install pgpool extensions using source code. |
|
|
> Follow previous bug reports and Pengbo's feedback and note to add sql symbol link to centos 9 built in postgresql's extension directory. Adding symbol link can't resolve this problem. Because $libdir is replaced by the PostgreSQL package library directory name, which is determined at build time, you can't set the it by using symbol link or LD_LIBRARY_PATH. |
