avkosme/postgresql96 repository overview

$ /usr/pgsql-9.6/bin/postgresql96-setup initdb
$ systemctl start postgresql-9.6

# CREATE DATABASE dbname;
# CREATE USER username WITH ENCRYPTED PASSWORD 'password';
# GRANT ALL PRIVILEGES ON DATABASE dbname TO username;

listen_addresses = '*'

host  all all 0.0.0.0/0 trust

$ pg_dump -h localhost -U username -d dbname > `date +%Y-%m-%d_%H:%M`-backup.sql

$ psql dbname < data_base_dump.sql