Postgresql on Fedora 22

postgreSQL-fedora-22

# see: https://fedoraproject.org/wiki/PostgreSQL
# install latest postgresql
sudo dnf install postgresql-server postgresql-contrib

# init database
sudo postgresql-setup initdb

# start postgresql
sudo systemctl start postgresql

# change postgres user password
sudo passwd postgres

# create a database and create a new user
## switch to postgres user
su postgres

## create a database
createdb forge

## log-in forge database
psql forge

## create a new user
CREATE ROLE forge WITH SUPERUSER LOGIN PASSWORD 'forge';

## exit
\q
exit

# configuration
## postgresql.conf
sudo vim /var/lib/pgsql/data/postgresql.conf

### uncomment
listen_addresses = 'localhost'
port = 5432

## pg_hba.conf
sudo vim /var/lib/pgsql/data/pg_hba.conf

### change all to md5
local   all             all                                     md5
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

# restart postgresql service
sudo systemctl restart postgresql.service

# test connection from localhost
psql -h localhost -U forge forge

For CentOS, see: http://www.if-not-true-then-false.com/2012/install-postgresql-on-fedora-centos-red-hat-rhel/