PostgreSQL Minor Release Upgrade

Here I am going to explore performing a minor PostgreSQL upgrade from 11.2 to 11.3 . when we say “minor” which is digit after the base version release.

psql

postgres=# select * from version();

To check the location of your PostgreSQL binaries:

ps -ef | grep postgres

OR

From the environment variables profile:

PGHOME=/usr/lib/postgresql/11/bin

I will shutdown the PostgreSQL database engine:

pg_ctl stop

I have downloaded the source binary file and copied it:

https://www.postgresql.org/ftp/source/v11.3/

scp postgresql-11.3.tar.gz /usr/lib/postgresql

gunzip postgresql-11.3.tar.gz

tar -xvf postgresql-11.3.tar

mv postgresql-11.3 11.3

cd 11.3

./configure

./configure –without-readline –without-zlib

make all

make install

make install-docs

cd /usr/local/pgsql/bin

which pg_ctl

*** Remark: change your environment variables such PGHOME to reflect the new binary directory also you need to do this with you configuration file postgresql.conf

Start-up PostgreSQL service:

pg_ctl -D /var/lib/postgresql/PGDATA start