Skip to main content

Postgres (Detection)

Following are the options specific to Postgres:

  • Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.

  • SSL: For an additional layer of security, check the SSL (Secure Socket Layer) checkbox.

  • Hostname: Enter the Hostname of the Postgres database or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS.

  • Group/IP Range: Select the Group/IP range from the drop-down. For details on how to create and assign an IP range, refer to section Group/IP Range Management in Linux and Group/IP Range Management in in Windows.

  • Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.

  • Database Name: Enter the name of the database.

  • Username: Enter the database username.

  • Password: Enter the database password.

  • Use Connection String: It specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to authenticate the connection using a connection string instead of username and password.

  • Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags for the created connection.

  • Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box and press enter. This lists down the existing databases for the selected connection. Check the Include System Schema/DB Name checkbox if you want to include the system schema in the panel. It will list down the available databases/schemas for the connection.


    To select a database, check the checkbox next to the name of the databases/schemas that you want to add as the target databases/schemas. Once checked, the selected databases or schemas will appear in the Target Databases/Schemas panel.

*Note: To create a GCP Postgres connection when SSL option is enabled, perform the below steps:

  1. Copy the following certificate files on the system: sslRootCert, sslCert, and sslKey.
    For more details, refer to the below link:
    https://cloud.google.com/sql/docs/postgres/configure-ssl-instance

  2. Convert sslKey file to PKCS#5 (.p5k) or PKCS#8 (.der) format, using OpenSSL command-line tool and execute the following command:

    openssl pkcs8 -topk8 -inform PEM -outform DER -in client-key.pem -out client-key.der -nocrypt

  3. Once sslKey file is converted from .pem to .der format, include it in the connection string along with other certificate files.

  4. Now, establish a secure GCP Postgres connection with all certificate files in the connection string.

    Given below is an example connection string to create secure GCP Postgres connection:

    jdbc:postgresql://34.30.92.216:5432/postgres?sslmode=verify ca&sslrootcert=C:\Work\SSL_Cert\server-ca.pem&sslcert=C:\Work\SSL_Cert\client-cert.pem&sslkey=C:\Work\SSL_Cert\client-key.der

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.