Postgresql

Postgresql

Authorize external connection

• • Modify /etc/postgresql/12/main/postgresql.conf

listen_addresses = '*'

• • Modify /etc/postgresql/12/main/pg_hba.conf

host all all 0.0.0.0/0 md5

Change postgres password

sudo -u postgres psql

then

\password postgres

Manage User

• • Create user with login

CREATE ROLE username WITH LOGIN PASSWORD 'mysecret';

• • Provide Superuser to a user

ALTER ROLE username SUPERUSER 

• • List users

select rolname,rolsuper,rolcanlogin FROM pg_roles; 

PgAdmin4

Url

http://localhost/pgadmin4

Reset Web Password

• Clear /var/lib/pgamdin folder
• Reconfigure the web interface

 dpkg-reconfigure pgamin4-apache2