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.

PostgreSQL connector 2026.1.1 and later

A new parameter is added in the dlpx_postgres_config.ini file located at the specified path: /<toolkit_directory>/Delphix_COMMON_<engineLongID>_<hostID>_host/plugin/postgres-vsdk_<pluginUUID>/dlpx_postgres_config.ini.

A stanza is added in the dlpx_postgres_config.ini config file

  • stanza name - [restore_optimization]

  • parameter name - OPTIMIZE_RESTORE_PARAMETERS, default value is false.

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). 

OPTIMIZE_RESTORE_PARAMETERS

(Starting from v2026.1.1 and later)

Only applicable to Single database ingestion workflow, if OPTIMIZE_RESTORE_PARAMETERS set to true, it will set the following parameters on staging dSource cluster:

  • shared_buffers 25% of RAM, clamped 128 MB – 32 GB

  • maintenance_work_mem 5% of RAM, clamped 256 MB – 8 GB

  • work_mem 25% of RAM ÷ max_connections, clamped 32 – 256 MB

  • wal_buffers 3% of shared_buffers, clamped 64 – 256 MB (never exceeds shared_buffers)

  • max_wal_size 40% of RAM, clamped 4 GB – 64 GB

  • max_worker_processes max(restore_jobs + 16, CPUs × 2, 32), capped at 99

  • max_parallel_workers max(4, max_worker_processes ÷ 2)

  • Fixed values

  • checkpoint_timeout=30min,

  • wal_compression=on,

  • synchronous_commit=off,

  • effective_io_concurrency=200,

  • maintenance_io_concurrency=200,

  • max_parallel_maintenance_workers=2,

  • max_parallel_workers_per_gather=2

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: 

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

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

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

[restore_optimization]
OPTIMIZE_RESTORE_PARAMETERS = false

PostgreSQL connector version 2026.1.0 and below

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:

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

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

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
Last updated
Oct 9, 2026