postgresql10をcentos7にインストール

# yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
# yum install postgresql10-devel postgresql10-contrib
# /usr/pgsql-10/bin/postgresql-10-setup initdb

postgres=# create role username with createdb login password '***';
postgres=# create database dbname OWNER username;