Contents x
    Connection Configuration for PostgreSQL
      • Print
      • PDF
      Contents

      Connection Configuration for PostgreSQL

        • Print
        • PDF
        Article summary

        summary

        This is the help page for Connection Configuration of PostgreSQL.

        entry

        item nameindispensableContents
        NameYesEnter the name of the Connection Configuration to be used inside TROCCO.
        memoNoEnter a note of Connection Configuration to be used inside TROCCO.
        hostYesEnter a host name or IP address.
        destination portYesEnter the port number of the database to connect to.
        The default port number for PostgreSQL is 5432.
        userYesEnter a user name for authentication.
        (computer) passwordYesPlease enter your password for authentication.
        SSLYesSelect 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 SSHNoSelect 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 ManagerNoFor more information, see Connecting with AWS Systems Manager Session Manager.
        JDBC DriverYesSelect 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 nameindispensableContents
        CA certificateNoYou can enter a root certificate issued by a certification authority (CA). Please enter in pem file format.
        client certificateNoYou can enter a certificate for authentication to be used when the client accesses the server. Please enter in pem file format.
        client private keyNoYou can enter the private key corresponding to the client certificate. Please enter in pem file format.
        SSL modeNoSets 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.
        • Was this article helpful?
        What's Next