Installing PostgreSQL 9.6 on CentOS 7 / Red Hat 7

The installation of PostgreSQL 9.6 needs to be done before installing Newired Portal

Below are listed all the commands to execute on the terminal of the server.

1. Add the PostgreSQL 9.6 Repository
   

   yum install  https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm -y

   
   
2. Install PostgreSQL 9.6
   

   yum install postgresql96 postgresql96-server postgresql96-contrib postgresql96-libs -y

   
   
3. Init the PostgreSQL 9.6 service
   

   /usr/pgsql-9.6/bin/postgresql96-setup initdb

   
   
4. Enable the PostgreSQL 9.6 service
   

   systemctl enable postgresql-9.6.service

   
   
5. Start the PostgreSQL 9.6 service
   

   systemctl start postgresql-9.6.service

   
   
6. Set the password for superuser postgres
   

   echo "ALTER USER postgres WITH PASSWORD '__NEW_PASSWORD__';" | su postgres -c "psql"

   
   
7. Now, you need to allow the connection from localhost to the database over password.
   To do that, edit the file /var/lib/pgsql/9.6/data/pg_hba.conf and change
   
   

   host    all         all 127.0.0.1/32            indent

   
   to
   

   host    all         all 127.0.0.1/32            md5

   
   
8. Restart the service
   

   systemctl restart postgresql-9.6.service

   
   
9. Test the connection superuser (postgres) over password
   

   psql -h 127.0.0.1 -U postgres -W