Connection to PostgreSQL

image_pdfimage_print

Connection to a PostgreSQL database.

 

Main settings

Host

The host name (DNS name) or the IP address of the server on which the database is located.

Port

The TCP/IP port number used by the database.

Username

User name for the connection to the database.

Password

Password for the connection to the database.

Database

Name, schema, or instance of the relational database..


Advanced settings:
Fetch Mode

For a PostgreSQL database, you can adjust the fetch mode as follows:

  • Buffered (default): the query result is returned with buffering. In this case, no parallel queries to the same PostgreSQL Server are possible.
  • Full: PostgreSQL returns the query result in one block. This is potentially slower, with higher memory consumption. It should only be set if the connection is used in several components that are processed in parallel during a load, e.g. several PostgreSQL extracts that are joined in a transform, an extract, and a load on the same PostgreSQL connection or when using parallel jobs. (Note that in those cases, if the fetch mode is not set to “full” this might lead to an error message: “postgresql portal <x> does not exist”.)

Additional JDBC parameters can be set in advanced settings.

image_pdfimage_print
Was this post helpful?
NoYes (-3 rating, 3 votes)
Loading...