Configure AlloyDB Omni database parameters

Select a documentation version:

To configure a database parameter for AlloyDB Omni, you can update Grand Unified Configuration (GUC) parameters in either of the following:

  • The postgresql.conf file for environments running AlloyDB Omni on a VM.

Update a parameter in AlloyDB Omni RPM package

In an AlloyDB Omni for Linux installation, you can update a parameter by editing the postgresql.conf file as follows:

  1. Locate the postgresql.conf configuration file for your installation of AlloyDB Omni.

  2. Use a text editor to add or update a database flag in postgresql.conf.

    For example, to enforce password expiration, set the following flag in the postgresql.conf file:

    password.enforce_expiration = ON
    
  3. After your database flags are added or edited, reload the postgresql.conf file for the changes to take effect by restarting the AlloyDB Omni service:

    sudo systemctl restart alloydbomni18