...
Similar to the MySQL Database Account, the PostgreSQL Database Account and PostgreSQL Dynamic Account support SSH tunneling to the database host. This article describes how the functionality can be tested using Docker.
...
You can use psql to set up tables, for testingtest, or to verify that the PostgreSQL instance is in order.
...
Now, you are set to configure a PostgreSQL account Account in your local SnapLogic application to connect to the Bastion host and PostgreSQL instance. You need to enter the private key (postgres-ssh.pem) either by uploading a file or pasting the string into the account.
A passphrase is required if you use the latter method.
Notice the use of port 5432, since you can access it within the bastion host, which is on the Docker network you created.
...