I have a centos 7 vm that came with postgreSQL 9.2.24 and I recently installed postgreSQL 11 from the source from their site with the commands
./configure make su make install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data
And that worked without any errors. In /usr/local/pgsql/data there is a file called PG_VERSION which contains "11". However when I check what version I have with
It still returns the 9.2.24 version.
I'm going to install a postgres extension (timescaledb) which will use the postgres version shown by pg_config, and I want to install timescaledb with postgres 11. Also the machine has to be offline only, if that matters (which is why I installed from the source).
The part that I think may be confusing me is I don't currebtly have a database created, as I plan to create a new one when I have timescaledb ready to go.