Stay organized with collections
Save and categorize content based on your preferences.
To configure a database flag for AlloyDB Omni, you add or update
Grand Unified Configuration (GUC)
parameters in the postgresql.conf file.
Add or update a GUC parameter
There are a few ways to update and add GUC parameters. This document covers the
most fundamental way, which is to edit your postgresql.conf file. For more
information, see
Setting parameters
in PostgreSQL documentation.
To add or update a GUC parameter by editing the postgresql.config file, do the
following:
Locate the postgresql.conf configuration file for your installation of
AlloyDB Omni.
Use a text editor to add or update a database flag in postgresql.conf.
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:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-04-02 UTC."],[[["Database flags for AlloyDB Omni are configured by adding or updating Grand Unified Configuration (GUC) parameters in the `postgresql.conf` file."],["The primary method for modifying GUC parameters is through direct edits to the `postgresql.conf` file."],["To update a flag, locate the `postgresql.conf` file, use a text editor to add or modify the desired GUC parameter, such as `password.enforce_expiration = ON` to enforce password expiration."],["After modifying `postgresql.conf`, the file must be reloaded for changes to take effect, which may involve restarting the Docker instance in some cases."]]],[]]