Modify the PostgreSQL Configurations in Your VMware Cloud Director Appliance

You can change your VMware Cloud Director appliance PostgreSQL configurations by using the PostgreSQL ALTER SYSTEM command.

The ALTER SYSTEM command writes the changes of the parameter settings to the postgresql.auto.conf file which takes precedence over the postgresql.conf file during the PostgreSQL initialization. Some settings require a restart of the PostgreSQL service while others are dynamically configured and do not require a restart. Do not change the postgresql.conf file, because the operation of the cluster requires periodic overwriting of the file and the changes are not persistent.

Procedure

1. Log in directly or by using an SSH client to the OS of the primary appliance as root.
2. Change the user to postgres.

   sudo -i -u postgres

3. Use the PostgreSQL ALTER SYSTEM command to change a parameter.

   psql -c "ALTER SYSTEM set parameter='value';"

4. Repeat Step 3 for each configuration parameter you want to change.
5. If some of the parameters you want to change require a restart of the PostgreSQL service, restart the vpostgres process.

   systemctl restart vpostgres

6. Repeat Step 1 through Step 5 on each standby node.