Install postgresql on centos 7

Installing postgresql

Fedora, RHEL, CentOS, or similar OS

# yum install postgresql
# yum install postgresql-server

Initialize postgresql Files

# postgresql-setup initdb

Setup postgresql

1. Set address 127.0.0.1 and ::1 to trust at the pg_hba.conf file. The directory might not be visible to non-sudoers. Run sudo su first.

   • In Fedora, RHEL, CentOS, or similar OS, the file location is /var/lib/pgsql/data/pg_hba.conf

2. Login to psql shell:

   $ psql --host=localhost --user=postgres
   

3. Set password inside psql shell:

   \password
   

4. Logout of psql shell with \q or press Ctrl+D on your keyboard.

5. Restart postgres service:

   # service postgresql restart
   

6. Login to psql shell again with the password you set.

   $ psql --host=localhost --user=postgres
   

   This action should prompt you with password.

Enable first the postgres service:

# systemctl enable postgresql.service