Advanced configuration

This topic details customizing PostgreSQL connector logging and controlling supported dataset configurations. You can modify the following parameters at any stage of the dataset lifecycle.

Parameter value	Usage
MAX_FILE_SIZE_KB	This parameter allows you to set the maximum size for the connector log files.
NUM_OF_FILES_TO_KEEP	This parameter allows you to define the maximum number of connector log files to retain.
LOG_LEVEL	This parameter allows you to adjust the connector debug log levels.
PGCTLTIMEOUT	This parameter allows you to set the PG_CTL timeout value for the database. This parameter defines the time (in seconds) to wait for the PostgreSQL start/stop (using pg_ctl) operation to complete. It can be customized to compensate for any network latency between the Delphix Continuous Data Engine and the remote environment. The default value is 600 seconds.
PIT_VDB_RECOVERY_MAX_WAIT_TIME	This parameter allows you to set the maximum wait time for PiT VDB recovery. Provisioning of VDB PiT with External Logs has a time-bounded wait for the recovery to complete. The PIT_VDB_RECOVERY_MAX_WAIT_TIME defines the maximum period (in seconds) the connector will wait for the recovery operation to successfully complete. The default value is 7200 seconds (i.e. 2 hours).

Connector config file

After adding the environment to Delphix Continuous Data Engine, you can find the connector configuration file, "dlpx_postgres_config.ini," on the remote environment. It is typically located at the following specified path:

CODE

<toolkit path>/Delphix_COMMON_<long id>/plugin/postgres-vsdk_12c9a11f-fab6-4792-a5da-49d726c004df/dlpx_postgres_config.ini

This file is divided into 3 sections - log_config, database_config, and plugin_config.

CODE

# Sample of file dlpx_postgres_config.ini
[log_config]
MAX_FILE_SIZE_KB = 10240
NUM_OF_FILES_TO_KEEP = 50
LOG_LEVEL = INFO # Accepted values: DEBUG, INFO, WARNING and ERROR

[database_config]
PGCTLTIMEOUT = 600


[plugin_config]
PIT_VDB_RECOVERY_MAX_WAIT_TIME = 7200