===== pgadmin 4 =====
apt-get install pgadmin4 pgadmin4-apache2 apache2 libapache2-mod-wsgi-py3
vim /etc/postgresql/9.6/main/pg_hba.conf
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.122.9/24 md5
# IPv6 local connections:
host all all ::1/128 md5
vim /etc/postgresql/9.6/main/postgresql.conf
# - Connection Settings -
listen_addresses = '192.168.122.9,localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
sudo -u postgres createuser -D -A -P myuser
su - postgres
psql
grant all privileges on database sempai to myuser;
grant all privileges on all tables in schema public to myuser;