Editing the Server Configuration

Editing the Server Configuration

The pgAdmin III interface provides two ways to update the server configuration in postgresql.conf: locally, through the File menu, and remotely on the server through the Tools menu. Editing the server configuration remotely may be more convenient in many cases, because it does not require you to upload or copy postgresql.conf.

To edit server configuration remotely

  1. Connect to the server whose configuration you want to edit. If you are connected to multiple servers, make sure that the correct server is highlighted in the object browser in the left pane.
  2. Select Tools > Server Configuration > postgresql.conf. The Backend Configuration Editor opens, displaying the list of available and enabled server configuration parameters.
  3. Locate the parameter you want to edit, and double click on the entry to open the Configuration settings dialog.
  4. Enter the new value for the parameter, or select/deselect Enabled as desired and click OK.
  5. If the parameter can be enabled by reloading server configuration, click the green reload icon, or select File > Reload server. Many parameters require a full restart of the server.