How to install AGE extension of postgresql from source code in ubuntu?-CodePudding

As I want to try out Apache Age of postgresql, I got lost when reading the documentation.

Is there any easy solutions ?

CodePudding user response：

First, you would need to clone PostgreSQL v11 or v12, only those are supported by AGE. Then, clone Apache AGE. // A few more steps but can you be specific as to where you got lost so that I can provide a specific solution.

CodePudding user response：

PostgreSQL versions 11 & 12 are supported for AGE extension. After installing postgresql from source code make sure bin and lib folder are in your environment variable. If not you can set it as below in cmd.

export PATH="$PATH:/home/pg/dist/postgresql-11.18/bin/"

export LD_LIBRARY_PATH="/home/pg/dist/postgresql-11.18/lib/"

export PG_CONFIG="/home/pg/dist/postgresql-11.18/bin/pg_config"

Just replace the path with your installation directory

After that clone the age in your ubuntu. Go to the directory and run

sudo make install

From now on you can run AGE extension after running pgsql as follow :

CREATE EXTENSION age;

LOAD 'age';

SET search_path = ag_catalog, "$user", public;