PostgreSQL Configurations

Configurations save in postgresql.conf , Located in <postgresqlFolder>\12\data.

Configurations can be set:
Edit postgresql.conf file itself.

• Via postgres command in the command-line.
• Some parameters can be changed in individual SQL sessions with the SET command.
• Some parameters can be changed with “ALTER SYSTEM” command.
• ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }
• ALTER SYSTEM RESET configuration_parameter
• ALTER SYSTEM RESET ALL

Configurations can be viewed:

• select * from pg_settings
• At pgAdmin.