[DEV] AGE 16 with Postgres 16

Hello

The following blog is for AGE developers

In the following post I will introduce you to a starter guide for PG-16 project. I am currently starting as well and got into some troubles I would like to save your time from getting into there.

Firstly we are going to work in making Postgresql v16 beta compatible with our AGE extension; That is our goal.

THE SCRIPT to get started read comments carefully :

# Download
wget https://ftp.postgresql.org/pub/source/v16beta1/postgresql-16beta1.tar.bz2
# Extract
tar zxf postgresql-16beta1.tar.bz2
# Get into the postgresql directory
cd postgresql-16beta1
# Make sure there is no postgresql servers are opened
pkill postgres
# start the installation
# packages needs for pg16
sudo apt install pkg-config
sudo apt install libicu-dev
# make sure your bison version is above 3.2
bison --version
# if below upgrade it
sudo apt remove bison
sudo apt install bison
# recheck
bison --version
./configure --prefix=$(pwd) --enable-cassert --enable-debug
make
make install
mkdir data
chown $(whoami) ./data
./bin/initdb -D ./data
bin/pg_ctl -D ./data -l logfile start
./bin/createdb test
./bin/psql test
\q
export PG_PATH=$(pwd)
cd ..

# Install age 
git clone  https://github.com/panosfol/age
git checkout PG16
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$(PG_PATH)/lib
make install PG_CONFIG=$(PG_PATH)/bin/pg_config
make installcheck PG_CONFIG=$(PG_PATH)/bin/pg_config
# you will get some errors don't worry that would be our work solving them

Have a nice day :)

References

• Postgresql : https://ftp.postgresql.org/pub/source/v16beta1
• AGE : https://github.com/panosfol/age/tree/PG16
• APACHE AGE: https://age.apache.org/