GUC 매개변수를 업데이트하고 추가하는 방법에는 여러 가지가 있습니다. 이 문서에서는 postgresql.conf 파일을 수정하는 가장 기본적인 방법을 설명합니다. 자세한 내용은 PostgreSQL 문서의 매개변수 설정을 참고하세요.
postgresql.config 파일을 수정하여 GUC 매개변수를 추가하거나 업데이트하려면 다음 단계를 따르세요.
AlloyDB Omni 설치의 postgresql.conf 구성 파일을 찾습니다.
텍스트 편집기를 사용하여 postgresql.conf에 데이터베이스 플래그를 추가하거나 업데이트합니다.
예를 들어 비밀번호 만료를 시행하려면 postgresql.conf 파일에서 다음 플래그를 설정합니다.
password.enforce_expiration=ON
데이터베이스 플래그를 추가하거나 수정한 후 변경사항이 적용되도록 postgresql.conf 파일을 다시 로드합니다. 예를 들어 Docker를 사용하여 AlloyDB Omni를 설치한 경우 다음을 실행하여 Docker 인스턴스를 다시 시작하고 postgresql.conf를 다시 로드합니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(UTC)"],[[["\u003cp\u003eDatabase flags for AlloyDB Omni are configured by adding or updating Grand Unified Configuration (GUC) parameters in the \u003ccode\u003epostgresql.conf\u003c/code\u003e file.\u003c/p\u003e\n"],["\u003cp\u003eThe primary method for modifying GUC parameters is through direct edits to the \u003ccode\u003epostgresql.conf\u003c/code\u003e file.\u003c/p\u003e\n"],["\u003cp\u003eTo update a flag, locate the \u003ccode\u003epostgresql.conf\u003c/code\u003e file, use a text editor to add or modify the desired GUC parameter, such as \u003ccode\u003epassword.enforce_expiration = ON\u003c/code\u003e to enforce password expiration.\u003c/p\u003e\n"],["\u003cp\u003eAfter modifying \u003ccode\u003epostgresql.conf\u003c/code\u003e, the file must be reloaded for changes to take effect, which may involve restarting the Docker instance in some cases.\u003c/p\u003e\n"]]],[],null,["# Configure AlloyDB Omni database flags\n\nSelect a documentation version: 15.5.5keyboard_arrow_down\n\n- [Current (16.8.0)](/alloydb/omni/current/docs/configure-database-flags)\n- [16.8.0](/alloydb/omni/16.8.0/docs/configure-database-flags)\n- [16.3.0](/alloydb/omni/16.3.0/docs/configure-database-flags)\n- [15.12.0](/alloydb/omni/15.12.0/docs/configure-database-flags)\n- [15.7.1](/alloydb/omni/15.7.1/docs/configure-database-flags)\n- [15.7.0](/alloydb/omni/15.7.0/docs/configure-database-flags)\n- [15.5.5](/alloydb/omni/15.5.5/docs/configure-database-flags)\n\n\u003cbr /\u003e\n\nTo configure a database flag for AlloyDB Omni, you add or update [Grand Unified Configuration (GUC)](https://www.postgresql.org/docs/current/config-setting.html) parameters in the `postgresql.conf` file.\n\n\u003cbr /\u003e\n\nAdd or update a GUC parameter\n-----------------------------\n\nThere are a few ways to update and add GUC parameters. This document covers the\nmost fundamental way, which is to edit your `postgresql.conf` file. For more\ninformation, see\n[Setting parameters](https://www.postgresql.org/docs/current/config-setting.html)\nin PostgreSQL documentation.\n\nTo add or update a GUC parameter by editing the `postgresql.config` file, do the\nfollowing:\n\n1. Locate the `postgresql.conf` configuration file for your installation of\n AlloyDB Omni.\n\n2. Use a text editor to add or update a database flag in `postgresql.conf`.\n\n For example, to\n [enforce password expiration](/alloydb/omni/15.5.5/docs/manage-password-policy#enforce-password-expiration),\n set the following flag in the `postgresql.conf` file: \n\n password.enforce_expiration = ON\n\n3. After your database flags are added or edited, reload the `postgresql.conf`\n file for the changes to take effect. For example, if you\n [installed AlloyDB Omni using Docker](/alloydb/omni/15.5.5/docs/quickstart#install-using-docker),\n run the following to restart your Docker instance and reload\n `postgresql.conf`:\n\n docker restart \u003cvar translate=\"no\"\u003eCONTAINER-NAME\u003c/var\u003e"]]
