This note is about the problems that I met while using PostgreSQL.
Install
Follow official user guide.
Access
// Modify pg_hba.conf
$ sudo vim /etc/postgresql/10/main/pg_hba.conf
// local all postgress trues
// Restart service
$ sudo service postgresql restart
// Connect
$ psql -U postgres
Create User
$ CREATE ROLE username WITH LOGIN PASSWORD 'password';
Grant
$ ALTER ROLE username CREATEDB;
Create Database
$ CREATE DATABASE db_name;
竟然无法拒绝你的打赏
