Connect to PostgreSQL

Retrieve connection detailsCopy Anchor Link

1. Open the database detail page.
2. Under Connection details, select a Connection account. Use an application account for normal workloads; see Manage database accounts.
3. Select Load connection details.
4. Record the hostname, port, database name, and username. Reveal or copy the password only when needed.

Keep connection strings containing passwords in application secrets, not source control or shared logs.

Connect over the private networkCopy Anchor Link

Use the private endpoint from an application on the same server and project network. It is not reachable from the public internet and does not use TLS.

With psql installed in that environment, replace the uppercase placeholders with values from the Console:

psql "host=PRIVATE_HOST port=5432 dbname=DATABASE_NAME user=APP_USERNAME sslmode=disable" -W

Enter the password at the prompt. Use the actual port shown by the Console if it differs.

Connect from outside the projectCopy Anchor Link

First enable external connections. Use the external hostname, not its IP address: the managed route requires TLS and SNI.

Configure your client to verify the server certificate and hostname using an appropriate trusted CA. For a configured psql trust store:

psql "host=EXTERNAL_HOST port=5432 dbname=DATABASE_NAME user=APP_USERNAME sslmode=verify-full" -W

The Console's generated external URI uses sslmode=require. Certificate and hostname verification require the corresponding client settings, such as verify-full and a trusted root certificate.

Verify the connectionCopy Anchor Link

Run:

SELECT current_database(), current_user;

Confirm the database and account match your selection. See the psql reference for client options and Troubleshooting for connection failures.