nativeInstallerpostgresql

Connect to PostgreSQL from a different machine

IMPORTANT: Bitnami Native Installers do not modify the firewall configuration of your computer, therefore the PostgreSQL ports could be open which is a significant security risk. You are strongly advised to close the PostgreSQL ports (refer to the FAQ for more information on this).

Once you have an active SSH tunnel or if you did not close the port for remote access, you can then connect to PostgreSQL using a command like the one below.

Remember to replace SOURCE-PORT with the source port number specified in the SSH tunnel configuration or 5432 if you did not close the port for remote access.

$ psql -h 127.0.0.1 -U postgres -p SOURCE-PORT

You will be prompted to enter the postgres user password. This is the same as the application password.

Last modification October 1, 2018