PostgreSQL

Created Thursday 10 December 2020

On Centos7:

After building/installing, you need to open a port in the firewall.
firewall-cmd --permanent --add-port=5432/tcp
firewall-cmd --reload

Build client only:

mkdir Downloads build
cd Downloads/
wget https://ftp.postgresql.org/pub/source/v13.2/postgresql-13.2.tar.bz2
cd ../build/
tar -xvjf ../Downloads/postgresql-13.2.tar.bz2
cd postgresql-13.2/
./configure --prefix=/opt/postgres/13.2
make -j4 -C src/bin install && make -j4 src/include install && make -j4 -C src/interfaces install && make -j4 -C doc install
cd /opt/postgres/
ls
ln -s 13.2 current