PostgreSQL – List settings defined in postgresql.conf and overriden by postgresql.auto.conf

Tested On

PostgreSQL 10.5

SQL Statements Used

List settings defined in postgresql.conf and overriden by postgresql.auto.conf

Alter settings

If context equal to postmaster, changing this parameter requires a restart of the PostgreSQL service. If it’s equal to user, changes just require a reload to take effect globally.

Note that restarting PostgreSQL terminates active connections.

Reloading after settings change

When we check the settings again, we will have:

Karl San Gabriel

Karl San Gabriel

Java and Enterprise Technologies Expert