Configure AlloyDB Omni database parameters

Select a documentation version: 18.1.0 keyboard_arrow_down

• Current (18.1.0)
• 18.1.0
• 17.7.0
• 17.5.0
• 16.11.0
• 16.9.0
• 16.8.0
• 16.3.0
• 15.15.0
• 15.13.0
• 15.12.0
• 15.7.1
• 15.7.0
• 15.5.5

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.