Skip to main content

PostgreSQL

PostgreSQL is a powerful, open-source relational database management system (RDBMS) that uses SQL for querying and managing data. It is known for its reliability, extensibility, and support for advanced features such as JSON, full-text search, and complex transactions, making it suitable for both small and enterprise-level applications.

Prerequisites​

The following prerequisites must be met in order for a user to create and test a successful connection.

  • The PostgreSQL server must be accessible from iceDQ server.
  • Valid credentials to access the database.
  • PostgreSQL version 9.4 or above.

Authentication Mechanism​

The following authentication mechanism is supported.

  • Username & Password

Connection Properties​

Use the following properties to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *       Name that uniquely identifies the connection.Sales_prod_conn
Driver *Driver used to establish the connection. By default, one driver is available.PostgreSQL Native JDBC
Custom JDBC URLStandardized string used to define the connection details. Use this format supported by the driver: jdbc:postgresql://[host]:[port]/[database]jdbc:postgresql://193.167.42.80:5432/prod_db
Host *IP address or hostname of the database server.postgres.acme.com or 193.167.42.80
Port *Port is the address on which the server listens. Default value is 5432 for PostgreSQL.5432
Database *Name of the target database.prod_db
Type *The connection type – either System Connection or User Connection. Refer Connections for more details.System or User
Username *Database login username with necessary privileges.john_doe
Password *Password associated with the specified username.Admin@123

Custom Properties​

Custom properties are optional connection parameters in the PostgreSQL driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the PostgreSQL JDBC driver in use.

Unsupported Datatypes​

The following datatypes are not supported.

  • INET6
  • TSVECTOR
  • TSQUERY
  • ENUM SET
  • BINARY
  • VARBINARY
  • RAW
  • LONG
  • CLOB
  • IMAGE
  • NTEXT
  • TEXT(n)
Last updated on