avkosme/postgresql repository overview

$ /usr/pgsql-10/bin/postgresql-10-setup initdb
$ systemctl start postgresql-10

# 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