Installation from CentOS repository:
To install the PostgreSQL server, run:
sudo yum install postgresql-server postgresql-contrib
To initialize the database, run:
sudo postgresql-setup initdb
To start PostgreSQL, run:
sudo systemctl start postgresql
Turn on automatic PostgreSQL startup after OS startup:
sudo systemctl enable postgresql
To install the PostgreSQL ODBC driver, run:
sudo yum install postgresql-odbc