How to set a configuration parameter at DB level in PostgreSQL permanently?

Question

I am aware of the below command:

ALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT }

On server restart, will these be overwritten by the parameter set in postgresql.conf

Laurenz Albe · Accepted Answer · 2017-11-16 10:22:12Z

1

The order of settings is like this:

answered Nov 16, 2017 at 10:22

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

session - user - database - system - postgres.conf

True. I bundled the last two as "default".

Vao Tsun · Accepted Answer · 2017-11-16 10:14:20Z

0

Set this database's session default for the specified configuration parameter to the given value.

so If configuration_parameter is set for database it overrides the postgres.conf. It should persist after db restart, yes

answered Nov 16, 2017 at 10:14

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges