I have followed all steps to install apache age with postgres 12 but i have encountered error while setting extension
CREATE EXTENSION age; ERROR: could not open extension control file "/usr/local/share/postgresql@14/extension/age.control": No such file or directory postgres=# LOAD 'age'; ERROR: could not access file "age": No such file or directory postgres=#
Probably something related to where you have configured the Apache AGE pg_config directory. You have to make sure you've installed Postgres 12 and located in which folder it was installed. Additionally, make sure you have changed the branch of Apache AGE's repository to match your Postgres' version.
git checkout PG12
Run the following command to install Apache AGE again:
sudo make PG_CONFIG=~/path_to_postgres/bin/pg_config install
Your AGE may not have been installed correctly. Try running a regression test to see if there are any issues using:
make PG_CONFIG={path to pgsql directory}/bin/pg_config installcheck
Also make sure you have set the paths to your pgsql directory with:
export PATH={path to pgsql directory}/bin/:$PATH
export PGDATA={path to pgsql directory}/bin/data
Whenever I encounter an unusual error when installing AGE, reinstalling it with a new repo clone will usually resolve my issues. Perhaps you could try this as well if the above do not help.
I think Age is not installed properly on your machine. Executing the below command might actually provide you with a description of the problem you are facing.
make PG_CONFIG=/home/talhastinyasylum/Desktop/age_installation/pg/postgresql-8/bin/pg_config installcheck
I also faced many errors while installing. Someone recommended that it the error persists you should start the installation all over again.
Try reinstalling AGE, remembering to use the right branch. Exit psql and do this inside AGE repository folder:
make clean && make uninstall && make install
Make sure that you are in the correct branch of PostgreSQL version, don't forget to install the libraries running:
sudo apt install git libreadline-dev zlib1g-dev bison flex build-essential
after that, enter in your postgres path and run the commands:
git checkout REL_12_STABLE
./configure –prefix=/usr/local/pgsql-12
make
it will define your version of psql. Finally you can give the permissions to the path and install the POSTGRESQL in version 12
sudo mkdir /usr/local/pgsql-12
sudo chown youruser /usr/local/pgsql-12
make install
I have replicated this error by creating a PostgreSQL database incompatible with Apache AGE. Please, make sure the Apache AGE version you are using is compatible with your database. By the path printed in the error message in the terminal, the PostgreSQL version you are using is 14. So far, AGE supports PostgreSQL 11, 12, and 13.
It seems there is an error with how you installed apacheAGE. Use :
make distclean
git clean -fdx
then reinstalling it. Follow the official apacheAGE guide here.
