Postgresql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
=== Postgresql === | === Postgresql === | ||
==== Authorize external connection ==== | ==== Authorize external connection ==== | ||
| Line 13: | Line 12: | ||
then | then | ||
<pre>\password postgres</pre> | <pre>\password postgres</pre> | ||
=== Manage User === | |||
** Create Super User | |||
<pre>CREATE USER username WITH LOGIN SUPERUSER PASSWORD 'thesecret';</pre> | |||
=== PgAdmin4=== | === PgAdmin4=== | ||
Revision as of 16:42, 17 April 2022
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
Reset Web Password
- Clear /var/lib/pgamdin folder
- Reconfigure the web interface
dpkg-reconfigure pgamin4-apache2