You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/11/02 07:06:48 UTC
[GitHub] [age] ass77 opened a new issue, #347: Unable to create AGE extension on postgres 11 and 12
ass77 opened a new issue, #347:
URL: https://github.com/apache/age/issues/347
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
`
a. psql "postgresql://postgres:postgres@localhost:5432/postgres"
b. create database test;
c. \c test
d. 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
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] ass77 commented on issue #347: Unable to create AGE extension on postgres 11 and 12
Posted by GitBox <gi...@apache.org>.
ass77 commented on issue #347:
URL: https://github.com/apache/age/issues/347#issuecomment-1312756409
> 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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] ass77 commented on issue #347: Unable to create AGE extension on postgres 11 and 12
Posted by GitBox <gi...@apache.org>.
ass77 commented on issue #347:
URL: https://github.com/apache/age/issues/347#issuecomment-1299681313
well... i did a `make clean` and it works fine now.
https://github.com/apache/age/issues/305#issuecomment-1258469444
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] ass77 closed issue #347: Unable to create AGE extension on postgres 11 and 12
Posted by GitBox <gi...@apache.org>.
ass77 closed issue #347: Unable to create AGE extension on postgres 11 and 12
URL: https://github.com/apache/age/issues/347
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] MatheusFarias03 commented on issue #347: Unable to create AGE extension on postgres 11 and 12
Posted by GitBox <gi...@apache.org>.
MatheusFarias03 commented on issue #347:
URL: https://github.com/apache/age/issues/347#issuecomment-1312742414
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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org