Skip to main content
If additional edits to the database’s configuration file are desired, e.g., UDFs (procs), auditing, etc., the database will need to be stopped and the file will need to be updated. System configuration is done primarily through the configuration file /opt/gpudb/core/etc/gpudb.conf, and while all nodes in a cluster have this file, only the copy on the head node needs to be modified. The configuration file can be edited via GAdmin or via a text editor on the command line.
Only edit the /opt/gpudb/core/etc/gpudb.conf on the head node. Editing the file on worker nodes is not supported and may lead to unexpected results.
Some common configuration options to consider updating:
  • Enabling auditing
  • Changing the persist directory
    The directory should meet the following criteria:
    • Available disk space that is at least 4x memory
    • Writable by the gpudb user
    • Consist of raided SSDs
    • Not be part of a network share or NFS mount
  • Enabling UDFs (procs)
  • Adjusting storage tiers and resource groups
To edit the configuration file via GAdmin:
  1. Log into GAdmin
    1. Enter admin for the Username
    2. Enter the Admin Password provided to KAgent for the Password (refer to KAgent UI for more information)
    3. Click Log In
  2. Stop the system.
  3. Navigate to Cluster —> Config
  4. Edit the file in the text window.
  5. Click Update, then click Start Service.
To edit the configuration file via command line:
  1. Stop the system.
  2. Open /opt/gpudb/core/etc/gpudb.conf in the desired text editor.
  3. Edit and save the file.
  4. Start the system.