Settings for PostgreSQL

This topic describes how to set up a PostgreSQL connection for DataSync.

  1. In DataSync, create a new source connection for PostgreSQL.

  2. Fill out the fields in the New Connection dialog box as described below.

  3. Click Save.

Connection Properties Description
Description Enter a name for the source connection.
Server The host name or IP address of the server.
Database Name of the PostSQL database.
Port Port number of the PostSQL server.
Username The user name for the connection.
Password The password for the specified user.
Timezone Sets the time zone for the session.
Verbosity

The verbosity level that determines the amount of detail included in the log file. Verbosity levels range from 1 to 5; the default is 3.
Enable Pooling

This parameter enables connection pooling. When it is selected, the three following properties are displayed:

  • Pool idle timeout: The allowed idle time for a connection before it is closed.

  • Max pool size: The maximum number of connections in the pool.

  • Pool wait time: The maximum number of seconds to wait for an available connection.