Setting up custom PostgreSQL configuration (VM)

Edit online

You can customize your PostgreSQL configuration settings. Concert offers the capability to create a custom.conf file for PostgreSQL configuration and mount it as a volume in the PostgreSQL deployment. This is an optional feature that allows you to tailor the external PostgreSQL databases to meet youspecific requirements. By creating a custom.conf file, you can define custom configuration settings, such as connection limits, memory allocation, and query optimization, which can then be applied to your PostgreSQL databases.

Instructions

  1. Set the $INSTALL_DIR variable. 
    export INSTALL_DIR=<install_directory>/ibm-concert
  2. Create a new custom.conf file in the following location: 
    $INSTALL_DIR/ibm-concert-std/localstorage/volumes/infra/pg-custom/
  3. Add the required configuration settings in the following format: 
    setting1=value1
setting2=value2
    Example: 
    max_connections=200
shared_buffers=3840MB

    Add each configuration setting on a new line using the setting=value format.

  4. Save the custom.conf file with the added configuration settings.
  5. Restart the container by using the following command: 
    $INSTALL_DIR/ibm-concert-std/systemd/start_service

Unsupported customizations

The following PostgreSQL configuration settings are not supported: 
ssl 
ssl_ca_file 
ssl_cert_file
ssl_key_file 
unix_socket_directories 
archive_mode 
archive_command 
listen_addresses 
shared_preload_libraries
log_directory
pg_auto_failover
port
hot_standby
password_encryption
hba_file