top of page
Волнистый абстрактный фон

PostgreSQL: DB Parameter Editor

The PostgreSQL cluster parameter editor allows you to quickly and conveniently edit the current parameters

​

PostgreSQL parameter editor

​

The " Filter " field is used to filter the list of parameters by the entered text. The text is searched in all columns and in any part of the line

The " Category " field is used for block filtering of the list

​

Changing the value of a parameter

  • highlight the parameter on the " Server parameter " tab

  • enter a new value in the field " Value "

  • press the " Apply " button

​

Parameter List

SELECT name,
      category,
      setting,
      unit,
      short_desc
 FROM pg_settings
order by category 

Changing the value of a parameter

alter system set $$PARAMETER_NAME = $$NEW_VALUE

SELECT pg_reload_conf()

bottom of page