Installation from CentOS repository:

1. To install the PostgreSQL server, run:

   sudo yum install postgresql-server postgresql-contrib

   
   

2. To initialize the database, run:

   sudo postgresql-setup initdb

   
   

3. To start PostgreSQL, run:

   sudo systemctl start postgresql

   
   

4. Turn on automatic PostgreSQL startup after OS startup:

   sudo systemctl enable postgresql

   
   

5. To install the PostgreSQL ODBC driver, run:

   sudo yum install postgresql-odbc