Connecting to the Postgres server

To connect to any of your nodes whether a master or a secondary node, retrieve the connection string of the instance from the Task manager by clicking on PGDB Actions > Connection string.

NodeChef uses the below format for the database connection string.

postgresql://[DatabaseRoleName]:[DatabaseRolePassword]@[HostName]:[Port]/[Database Name]

"Square brackets used above is only for demonstration purposes. Your connection string will not include them."

If SSL is enabled, the "POSTGRES_URL" environment variable which will be set for your App container will also contain this option.