Connection Configuration for PostgreSQL

summary

This is the help page for Connection Configuration of PostgreSQL.

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.
Connecting via AWS Systems Manager Session Manager	No	For more information, see Connecting 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)`

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.