This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ===== pgadmin 4 ===== <code> apt-get install pgadmin4 pgadmin4-apache2 apache2 libapache2-mod-wsgi-py3 </code> vim /etc/postgresql/9.6/main/pg_hba.conf <code> # 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 </code> vim /etc/postgresql/9.6/main/postgresql.conf <code> # - 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) </code> <code> 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; </code>