The best way to manipulate databases is to use the psql client tool.
Once connected to the machine via ssh, you can connect to the PostgreSQL database from the same computer where it is installed with the psql client tool.
psql -U postgres
You will be prompted to enter the postgres user password.
- In case you deployed your server using the Google Cloud Launcher, you can find the postgres user password following this document.
- In case you deployed your server using the Bitnami Launchpad, you can find the password following this document.
PostgreSQL command line CheatSheet
I hope this information is useful for you.
Carlos R. Hernández
Was my answer helpful? Click on