Postgresql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 22: | Line 22: | ||
* Clear /var/lib/pgamdin folder | * Clear /var/lib/pgamdin folder | ||
* Reconfigure the web interface | * Reconfigure the web interface | ||
<pre> dpkg-reconfigure pgamin4- | <pre> dpkg-reconfigure pgamin4-apache2 </pre> | ||
Revision as of 23:24, 7 October 2020
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-apache2