6.2 Modifying the postgresql.conf File

Table of Contents Previous Next


6 Managing an Advanced Server Installation : 6.2 Modifying the postgresql.conf File

Configuration parameters in the postgresql.conf file specify server behavior with regards to auditing, authentication, encryption, and other behaviors. The postgresql.conf file resides in the data directory under your Advanced Server installation.
Parameters that are preceded by a pound sign (#) are set to their default value (as shown in the parameter setting). To change a parameter value, remove the pound sign and enter a new value. After setting or changing a parameter, you must either reload or restart the server for the new parameter value to take effect.
Within the postgresql.conf file, some parameters contain comments that indicate change requires restart (see Figure 6.1). To view a list of the parameters that require a server restart, execute the following query at the psql command line:

6 Managing an Advanced Server Installation : 6.2 Modifying the postgresql.conf File

Table of Contents Previous Next