Table of Contents Previous Next


5 Configuring Advanced Server : 5.1 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.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\eb0a2b62\Screen Shot 2018-07-12 at 7.36.14 AM.png
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 5.2). To view a list of the parameters that require a server restart, execute the following query at the psql command line:

5 Configuring Advanced Server : 5.1 Modifying the postgresql.conf File

Table of Contents Previous Next