Managing plugin configurations

The plugin config file dlpx_postgres_config.ini is available on the remote host and located at <toolkit path>/Delphix_COMMON_<long id>/plugin/postgres-vsdk_<long plugin id>/dlpx_postgres_config.ini.

Managing log rotation and log level

Delphix PostgreSQL plugin provides a feature that helps users to manage the log rotation for the plugin logs found within the scratch path, located at <toolkit path>/Delphix_COMMON_<long id>/plugin/postgres-vsdk_<long plugin id>/<os user>_logs/delphix_postgres_debug.log.

Delphix users can configure the logging mechanism by modifying the below parameters defined in the dlpx_postgres_config.ini file:

Setting maximum size

Delphix users can set the parameter MAX_FILE_SIZE_KB available in the dlpx_postgres_config.ini file to set the maximum size of the active log file in KB. Once this limit is reached, the plugin will rotate the log. The default/maximum value of this parameter is 10240 KB/10 MB. This parameter accepts only a positive integer value, such as 10240.

Setting number of log files to retention

Delphix users can set a retention number for the rotated log files using the parameter NUM_OF_FILES_TO_KEEP. The default value of the parameter is 50. That means, the maximum number of rotated log files that will be retained is 50 and each file will be of a size as defined in the MAX_FILE_SIZE_KB parameter. If the number of files exceeds this value, then the old files will be deleted in a FIFO order.

Setting the log level

Delphix users can set the amount of log being generated on the remote host by defining the LOG_LEVEL parameter. Accepted values are DEBUG, INFO, WARNING, and ERROR, with INFO being the default value.

Managing PostgreSQL timeouts

PGCTLTIMEOUT

The PGCTLTIMEOUT parameter defines the default limit on the number of seconds to wait for the Postgres startup to complete. This parameter is introduced to compensate for any network latency between the Delphix Engine & the remote host. The default value is set to 600 seconds.

Managing plugin timeouts

PIT_VDB_RECOVERY_MAX_WAIT_TIME

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 amount of time the plugin will wait for the operation to succeed. It is defined in seconds and the default value is 7200 seconds (i.e. 2 hours).

The wait cycles within the plugin are of 4 seconds each. So keeping the value of the parameter in multiples of 4 will result in a better experience.

dlpx_postgres_config.ini

CODE

[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