Skip to content
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

no installation script nor update path #252

Open
john047 opened this issue Aug 18, 2022 · 1 comment
Open

no installation script nor update path #252

john047 opened this issue Aug 18, 2022 · 1 comment

Comments

@john047
Copy link

john047 commented Aug 18, 2022

Problem description

Hello,

I installed the extension according to the instructions but when creating it (CREATE EXTENSION pg_pathman WITH SCHEMA pathman;) I get an error:
ERROR: extension "pg_pathman" has no installation script nor update path for version "1.5"

Environment

SELECT * FROM pg_extension;
plpgsql
btree_gist
dblink
pg_stat_statements

SELECT version();
PostgreSQL 10.17 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit

SELECT pgpro_version();
ERROR: function pgpro_version() does not exist

SELECT pgpro_edition();
ERROR: function pgpro_edition() does not exist

SELECT get_pathman_lib_version();
ERROR: function get_pathman_lib_version() does not exist

Help, please!

@kovdb75
Copy link
Collaborator

kovdb75 commented Sep 21, 2022

Hi!

Unfortunately I don't have your configuration Red Hat 8.3.1-5, gcc 8.3.1.
I tried to see problem on my Ubuntu 22.04 + gcc-11.
I created directory "builds" and then:

  1. Commands inside directory "builds":
git clone git://git.postgresql.org/git/postgresql.git
git clone https://github.com/postgrespro/pg_pathman
  1. Commands inside "postgresql" directory:
git checkout REL_10_STABLE
./configure --enable-debug --enable-tap-tests --enable-cassert --with-icu --prefix `pwd`/install >/dev/null && make -j4 -s && make -j4 -C contrib -s && make install -s && make install -C contrib -s
  1. Command inside "pg_pathman" directory:
PATH=../postgresql/install/bin:$PATH make install USE_PGXS=1 
  1. Commands inside "postgresql" directory (database creation in "builds/postgresql/data-10" directory):
./install/bin/pg_ctl initdb -w -D data-10 --options="-A trust -D data-10 -E utf-8 --no-locale -N -n"
./install/bin/pg_ctl -D data-10 start
./install/bin/createdb test
./install/bin/pg_ctl -D data-10 stop
  1. Add "shared_preload_libraries='pg_pathman'" into end of file ./data-10/postgresql.conf and start server again:
./install/bin/pg_ctl -D data-10 start
./install/bin/psql test
  1. And execute queries in psql:
CREATE SCHEMA pathman;
GRANT USAGE ON SCHEMA pathman TO PUBLIC;
CREATE EXTENSION pg_pathman WITH SCHEMA pathman;

And I don't see any error after last query ...
Could you repeat the same steps on Red Hat?

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

2 participants