top of page
CerebroSQL

PostgreSQL:  

ALTER SYSTEM

Topic

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

ALTER SYSTEM RESET configuration_parameter
ALTER SYSTEM RESET ALL

Example

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

bottom of page