postgresql.conf
file. To find your postgresql.conf
file, use SHOW
.
- By editing the
postgresql.conf
file and restarting Postgres. This makes the setting permanent for all sessions. - By running
SET
. This temporarily changes the setting for the current session. Note that Postgres does not allow allpostgresql.conf
settings to be changed withSET
.