Skip to content

Unable to install pg_pathman to PosgreSQL13 on Ubuntu 18.04 LTS #232

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
drednout opened this issue Sep 22, 2021 · 1 comment
Closed

Unable to install pg_pathman to PosgreSQL13 on Ubuntu 18.04 LTS #232

drednout opened this issue Sep 22, 2021 · 1 comment

Comments

@drednout
Copy link

drednout commented Sep 22, 2021

Problem description

Unable to install pg_pathman on Ubuntu 18.04 LTS

  1. git clone https://github.com/postgrespro/pg_pathman
  2. cd pg_pathman
  3. git checkout 1.5.12
  4. PG_CONFIG=/usr/lib/postgresql/13/bin/pg_config sudo make install USE_PGXS=1
  5. Modify postgresql.conf: shared_preload_libraries = 'pg_pathman'
  6. Restart PostgreSQL: sudo service postgresql start 13
  7. Visit logs, see
2021-09-22 17:51:02.882 +03 [3965] FATAL:  could not load library "/usr/lib/postgresql/13/lib/pg_pathman.so": /usr/lib/postgresql/13/lib/pg_pathman.so: undefined symbol: elog_finish
2021-09-22 17:51:02.882 +03 [3965] LOG:  database system is shut down
pg_ctl: could not start server

Environment

OS:

╰─$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 18.04.5 LTS
Release:        18.04
Codename:       bionic

PostgreSQL:

postgres=# select version();
                                                             version
---------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
(1 row)

postgres=# SELECT * FROM pg_extension
postgres-# ;

  oid  | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+---------+----------+--------------+----------------+------------+-----------+--------------
 13407 | plpgsql |       10 |           11 | f              | 1.0        |           |
@drednout drednout changed the title Unable to install pg_pathmon to PosgreSQL13 on Ubuntu 18.04 LTS Unable to install pg_pathman to PosgreSQL13 on Ubuntu 18.04 LTS Oct 5, 2021
@drednout
Copy link
Author

drednout commented Oct 5, 2021

I cleaned all files in build directory and tried to build one more time with command:

PG_CONFIG=/usr/lib/postgresql/13/bin/pg_config sudo make install USE_PGXS=1

And it works! The issue above happened likely because I have several version of PostgreSQL server on my host and by default I have 11.9.

@drednout drednout closed this as completed Oct 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant