Unable to create AGE extension on postgres 11 and 12

[ass77]

This is what I've done

1/ purge and remove current postgres 14

sudo apt-get --purge remove postgresql postgresql-\*

2/ install postgres 11 ++ VERSION = PostgreSQL 11.17 (Ubuntu 11.17-1.pgdg18.04+1)

sudo apt-get install postgresql-server-dev-11 postgresql-11 postgresql-client-11 postgresql-contrib-11

3/ clone apache age

git clone https://github.com/apache/age

4/ change postgres port from 5433 to 5432 at etc/postgresql/11/main/postgresql.conf

5/ change PGBINROOT from /usr/lib/postgresql to /usr/lib/postgresql/11

6/ restart postgres service
sudo systemctl restart postgres

7/ install age extension with makefile
sudo make PG_CONFIG=/usr/bin/pg_config install

8/ connect to postgres with psql and create AGE extension

• psql "postgresql://postgres:postgres@localhost:5432/postgres"
• create database test;
• \c test
• create extension age;

The error at point no 8
ERROR: incompatible library "/usr/lib/postgresql/11/lib/age.so": version mismatch DETAIL: Server is version 11, library is version 12.

Then I repeat again from step 1 till 8 but with postgres 12 VERSION = PostgreSQL 12.12 (Ubuntu 12.12-1.pgdg18.04+1) (except cloning the age again) but it shows me this error
ERROR: tables declared WITH OIDS are not supported

[ass77]

well... i did a make clean and it works fine now.

#305 (comment)

[MatheusFarias03]

Hello! Where did you run the make clean command? It was after the make PG_CONFIG=/path/to/postgres/bin/pg_config install or before it? Or it was in the postgresql directory?

[ass77]

Hello! Where did you run the make clean command? It was after the make PG_CONFIG=/path/to/postgres/bin/pg_config install or before it? Or it was in the postgresql directory?

Hi. I reverted back the postgres version back to 11. and repeat again from step 1 to 8, pretty much the make clean command is going to be on step 9 and did it in the age directory.