6.1 Modifying the postgresql.conf File

Table of Contents Previous Next


6 Configuring Advanced Server : 6.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; you can use your editor of choice to open the postgresql.conf file directly, or navigate through the Postgres Plus Advanced Server menu to the Expert Configuration menu, and select the Edit postgresql.conf menu selection.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\465c92c8\pg_conf.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. To view a list of the parameters that require a server restart, execute the following query at the EDB-PSQL command line (see Figure 6.3):
cf2
If you are changing a parameter that requires a server restart, see Section 5.1, Starting and Stopping Advanced Server for information about restarting Advanced Server.
You can reload the system configuration parameter values by navigating through the Postgres Plus Advanced Server 9.5 menu to the Expert Configuration menu, and choosing the Reload Configuration menu selection. Reloading the configuration parameters does not require Advanced Server users to log out of their current Advanced Server sessions.

6 Configuring Advanced Server : 6.1 Modifying the postgresql.conf File

Table of Contents Previous Next