Install Postgresql 9.3 on centos 6.5

I used to have Mysql installed on my webserver, however recently I came across some examples where the worst side of mysql was shown. And I was convinced I should be using postgresql instead.

Therefor underneath you’ll find a short guide on howto install postgresql.

Edit pg_hba.conf for access

To:

Furthermore you should also edit postgresql.conf for access

If it’s needed you can apply this iptables rule:

Tips and tricks:
* service postgresql-9.3 restart
* If you forget the password of postgres, simply use sudo passwd postgres on the cli.
* Create a superuser with the following command:

Leave a Reply

Your email address will not be published. Required fields are marked *