--- title: "Connection Configuration for PostgreSQL" slug: "connection-configuration-postgresql" updated: 2024-10-07T05:27:06Z published: 2024-10-07T05:27:06Z canonical: "documents.trocco.io/connection-configuration-postgresql" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Connection Configuration for PostgreSQL ## summary This is the help page for Connection Configuration of PostgreSQL. ## entry | item name | indispensable | Contents | | --- | --- | --- | | Name | Yes | Enter the name of the Connection Configuration to be used inside TROCCO. | | memo | No | Enter a note of Connection Configuration to be used inside TROCCO. | | host | Yes | Enter a host name or IP address. | | destination port | Yes | Enter the port number of the database to connect to. The default port number for PostgreSQL is `5432`. | | user | Yes | Enter a user name for authentication. | | (computer) password | Yes | Please enter your password for authentication. | | SSL | Yes | Select whether to use SSL (TLS) communication. Please refer to the **case when SSL is enabled** described below for the input items when enabled. | | Connecting via SSH | No | Select this option if you wish to connect via SSH (using SSH tunnel). For more information, please see [Connecting via SSH Tunnel](/docs/connection-with-ssh-tunnel). | | Connecting via AWS Systems Manager Session Manager | No | For more information, see [Connecting with AWS Systems Manager Session Manager](/docs/connection-with-aws-systems-manager-session-manager). | | JDBC Driver | Yes | Select the version of the JDBC driver that connects to the PostgreSQL server. Depending on the version of PostgreSQL you are using, you can choose from the following options `JDBC Driver 42.5.1 (PostgreSQL 8.2 or higher)``9.4 1205 JDBC 41 (under PostgreSQL 8.2)` | ### When SSL is enabled | item name | indispensable | Contents | | --- | --- | --- | | CA certificate | No | You can enter a root certificate issued by a certification authority (CA). Please enter in pem file format. | | client certificate | No | You can enter a certificate for authentication to be used when the client accesses the server. Please enter in pem file format. | | client private key | No | You can enter the private key corresponding to the client certificate. Please enter in pem file format. | | SSL mode | No | Sets the level of verification for server certificates during SSL connections.`Default`: "0 CA certificate verification is not performed.`require`: SSL connection is required.`verify-ca`: SSL connection shall be mandatory and CA certificate verification shall also be mandatory. |