PostgreSQL configuration files

When you install the PostgreSQL database, the postgresql.conf file is automatically created in the following directory:

The configuration parameters in the postgresql.conf file define the default values of the server properties related to auditing, authentication, encryption, and other behaviors.

The postgresql.conf file is overwritten every time you install or upgrade to a new version of the PostgreSQL database. Do not update the postgresql.conf file for any customized behavior, because the changes are lost when the file is overwritten.

Use the user.conf file to override the default values that are defined in the postgresql.conf file.

If the user.conf file does not already exist, create the file in the same directory as the postgresql.conf file, and override the values. Changes take effect after you restart the PostgreSQL database.