PostgreSQL

CentOS 7

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Installation

source : https://tecadmin.net/install-postgresql-11-on-centos/

sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

yum install postgresql${version}-server

/usr/pgsql-${version}/bin/postgresql-${version}-setup initdb

systemctl enable postgresql-${version}.service systemctl start postgresql-${version}.service

postgres=# \password postgres

Upgrade

https://www.postgresql.org/docs/11/upgrading.html

Minor version

1. Stopper le service postgreSQL

$ systemctl stop postgresql-11.service

2. Faire un dump global

$ pg_dumpall > db.out

3. Upgrader la version de postgreSQL

yum install postgresql11-${MINOR_VERSION}
yum install postgresql11-server-11.11-1PGDG.rhel7

Show available minor version 
yum list postgresql11 --showduplicates

4. Relancer le service

$ systemctl start postgresql-11.service

Major version (WIP)