PostgreSQL Connection Information
- 17 Jul 2024
- Print
- PDF
PostgreSQL Connection Information
- Updated on 17 Jul 2024
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
summary
This is a help page for setting up PostgreSQL connection information.
entry
| item name | indispensable | Contents |
|---|---|---|
| Name | Yes | Enter the name of the connection information to be used inside TROCCO. |
| memo | No | Enter a note of connection information 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. |
| secure socket layer | 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. |
| Connect 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 select from the following options. JDBC Driver 42.5.1 (PostgreSQL 8.2 or higher)9.4 1205 JDBC 41 (PostgreSQL under 8.2) |
When SSL is enabled
| item name | indispensable | Contents |
|---|---|---|
| CA certificate | No | You can enter a root certificate issued by a Certificate 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 required. |
Was this article helpful?