Online Documentation for SQL Manager for PostgreSQL

Setting up Configuration Files

The Configuration File tab of the Server Configuration manager allows you to edit parameters set starting and run-time parameters.


Common PostgreSQL configuration information is typically stored in postgresql.conf file. Each parameter can be edited and enabled for the database system to take effect. To obtain more information on specific parameters, refer to PostgreSQL documentation.


Server Configuration - Setting up Configuration Files



The Configuration File displays the configuration parameters as a grid with the following columns: Enabled, Parameter Name, Parameter Setting, Current Setting. If more convenient, you can change the order of the columns by dragging their headers horizontally.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.


Right-click an item within the list to call the context menu allowing you to refresh the list, edit a parameter, or save current settings.


Configuration file management tools are also available through the Navigation bar of the Server Configuration manager.


The Edit Parameter dialog allows you to change the parameter name, set its value, browse parameter info and supply a description, if necessary.


Server Configuration - Setting up Configuration Files - Edit parameter