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 Super User

CREATE USER username WITH LOGIN SUPERUSER PASSWORD 'thesecret';

PgAdmin4

Url

http://localhost/pgadmin4

Reset Web Password

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

 dpkg-reconfigure pgamin4-apache2