top of page

PostgreSQL:

ALTER SYSTEM

ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }

ALTER SYSTEM RESET configuration_parameter
ALTER SYSTEM RESET ALL

ALTER SYSTEM SET wal_level = hot_standby;
ALTER SYSTEM RESET wal_level;

bottom of page