Postgresql
Jump to navigation
Jump to search
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
PgAdmin4
Url
Reset Web Password
- Clear /var/lib/pgamdin folder
- Reconfigure the web interface
dpkg-reconfigure pgamin4-apache