Tip of the Day: Customizing PostgreSQL VDB Configuration Settings

  • 1
  • Announcement
  • Updated 5 years ago
When you create a VDB, configuration settings are copied from the dSource and used to create the VDB. Most settings are copied directly, and you can see these settings by clicking the Advanced link in the Target Environment screen in the VDB Provisioning Wizard. When a VDB is provisioned, you can specify configuration parameters directly. It is important to know, however, that some configuration parameters are not customizable, and some are stripped out during the provisioning process but are customizable. The list of restricted and customizable parameters can be found below.
VDB Access Control *By default, VDBs are provisioning with a pg_hba.conf file that only permits local connections to the VDB. To enable remote connections to VDBs, customize the pg_hba.conf settings in the provisioning wizard.

Restricted Parameters These parameters are restricted for use by the Delphix Engine. Attempting to customize these parameters will cause an error during the provisioning process.

  • archive_command
  • archive_mode
  • wal_level
  • port
  • data_directory
  • config_file
  • hba_file
  • ident_file
  • max_stack_depth
  • wal_segment_size
  • block_size
  • lc_ctype
  • segment_size
  • wal_block_size
  • lc_collate
  • server_version
  • integer_datetimes
  • server_encoding
  • server_version_num
  • max_identifier_length
  • max_index_keys
  • max_function_args
  • include
  • include_if_exists
Photo of Delphix FAQs

Delphix FAQs, Official Rep

  • 4,000 Points 4k badge 2x thumb

Posted 5 years ago

  • 1

Be the first to post a reply!