When I type the following I get error
root@mail:~# psql postgres postgres
\password postgres or whatever the super user is
I want to connect with PGadmin and do stuff like create databases and users so I need to reset the super user passoword using
Command 'psql' not found, but can be installed with:
snap install postgresql # version 9.3.25, or
apt install postgresql-client-common # version 214ubuntu0.1
Here is what I did
host postgres postgres ipaddress/32 trust
To the auth file
Connect with no password
Set password with pgadmin (docker instance)
Change it to
host postgres postgres ipaddress/32 md5
aaP_vonwallace
Log in:
su - postgres
enter the database
psql
View all database information
SELECT * FROM pg_database ORDER BY datname;
Unable to remote, please check whether the permission is open? Does the server provider open the relevant ports?
