How to Get the Location of the Configuration File of a PostgreSQL Database Server

In this article, we show how to get the location of the configuration file of postgresql database server.

This is the postgresql.conf file, which contains the configuration settings of the postgresql database server.

To get the location of this posgresql.conf file, we use the following statement below.


postgres=# SHOW config_file;

As a response, this is the data that we get.

If we go to the directory, then we should see the postgresql.conf file, which contains the configuration settings of the postgresql database server.

With this file, you can change many settings of the postgresql database server that you're operating.

After making changes, you can go to the psql tool and type in, SELECT pg_reload_conf();

This will reload the new configuration settings.

Now if you restart the server, all changes will take effect.

Related Resources

How to Create Your Own PostgreSQL Server on Your Own Computer in Windows