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 containerized AlloyDB Omni

In an AlloyDB Omni running on a VM, 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. For example, if you installed AlloyDB Omni using Docker, run the following to restart your Docker instance and reload postgresql.conf:

    docker restart CONTAINER-NAME

For more information, see Setting parameters in PostgreSQL documentation.