Install postgresql on centos 7

Primary tabs

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 method of the 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
    • In Debian, Ubuntu, Mint, or similar OS, the file location is /etc/postgresql/$version/main/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. Return method of the address 127.0.0.1 and ::1 to md5 at the pg_hba.conf file.

    • Just revert the action on Step #1
  6. Restart postgres service:

    # service postgresql restart
    
  7. Login to psql shell again with the password you set.

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

    This action should prompt you with password.

:warning: Command service postgresql restart might not work. Enable first the postgres service:

# systemctl enable postgresql.service


QR Code for https://setupexample.com/install-postgresql-centos-7