installed postgres via store app.

aaP_vonwallace

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

aaP_vonwallace

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

aaPanel_Kern

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?