Locating the PostgreSQL server configuration files
The main configuration file of the PostgreSQL server is usually named postgresql.conf
, and is stored in the database cluster data directory by default. Various system distributions move this configuration outside of the data directory and place it in a different location, for example, in the /etc/
directory. In this recipe, we will demonstrate how to find the postgresql.conf
and change it to modify the server's configuration. Webmin does not assist you in the modification of the basic settings of PostgreSQL, so you will need to edit the configuration file manually.
Getting ready
Make sure that the PostgreSQL server is installed and running, and that you are able to connect to it via Webmin before starting. The recipe, Installing the PostgreSQL database server, provides more information.
How to do it...
Follow these steps to locate PostgreSQL's main configuration file on your system:
Navigate to Servers | PostgreSQL Database Server.
Click the icon...