PG Admin

1. Download and install pgAdmin pgAdmin.
2. Go to your postgres databases.
3. In External Credentials, enter the External Port (Internet) make sure the port is not in use by another service eg. 5433 and click Save.
4. It will display the External Connection URL eg. postgres://user:[email protected]:5433/database.

Open pgAdmin and follow the steps:

1. Click on Add New Server.
2. Enter the Server Name eg. dokploy.
3. Enter to Connection.
4. In Hostname/Address enter the IP from the server where the database is hosted eg. 1.2.4.5.
5. In Port enter the port where the database is running eg. 5433.
6. In Database enter the name of the database eg. database.
7. In Username enter the username eg. user.
8. In Password enter the password eg. password.
9. Click on Save.

Done! now you can manage the database from pgAdmin.