age Build and install the appropriate AGE build into both PostgreSQL development versions.

Build and install the appropriate AGE build into both PostgreSQL development versions.

Open jrgemignani opened this issue 1 year ago • 11 comments

Sep 19 '22 23:09 jrgemignani

This task is identical to #294, except that you will be building and installing the appropriate AGE extension into PG 11.17 & 12.12.

Sep 19 '22 23:09 jrgemignani

PG11.17

Sep 21 '22 01:09 susano0

PG 12.12

Sep 21 '22 01:09 susano0

Installed, the same test is failing. Will fix these issues newAGEinstall

Sep 21 '22 02:09 PragyanD

We definitely need to correct the issue with the expr regression test.

Sep 21 '22 17:09 jrgemignani

Installed AGE extension into both PG(11.17 & 12.12) versions. Apparently all tests are passed. But my pg11.5 & 12.10 had test expr failed. weird because I didn't change anything in between.

Sep 22 '22 06:09 skkk98

Installed AGE into PG11.17. Installcheck passes all 20 tests.

However, for PG12.12, installcheck gives the following error. What I did was checked into branch AGE_PG12.1.0_ALPHA, and run make install with appropriate PG_CONFIG.

$ make PG_CONFIG=/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/bin/pg_config installcheck
/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/bin'    --load-extension=age --inputdir=.//regress --outputdir=.//regress --temp-instance=.//regress/instance --port=61958 --encoding=UTF-8 --dbname=contrib_regression scan graphid agtype catalog cypher expr cypher_create cypher_match cypher_unwind cypher_set cypher_remove cypher_delete cypher_with cypher_vle cypher_union cypher_merge age_load index drop
============== removing existing temp instance        ==============
============== creating temporary instance            ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 61958 with PID 418801
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== installing age                         ==============
ERROR:  incompatible library "/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/lib/age.so": version mismatch
DETAIL:  Server is version 12, library is version 11.
command failed: "/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"age\"" "contrib_regression"
make: *** [/home/rafsun82/postgresql-src/postgresql-12.12/new_build_dir/lib/pgxs/src/makefiles/pgxs.mk:420: installcheck] Error 2

Sep 25 '22 00:09 rafsun42

I'm not sure whether it'll help, but try running make clean and run the installcheck command again.

If it still doesn't work, try testing pg12.12 by running bin/psql in the postgresql-12.12 folder. it says version 11 is being used, so you can also try reinstalling pg12.12.

Sep 25 '22 15:09 skkk98

Did you switch to the Postgres 12 supported branch of AGE, AGE_PG12.1.0_ALPHA? Also you should run make clean when switching between versions.