How to reload PostgreSQL configuration

Question

I am trying to enable the transaction logs in PostgreSQL, where query run time is more than 3 seconds, by setting this flag

log_min_duration_statement = 3000

How to reload the configuration file without restarting the Postgres?

I've tried the below options and got these errors

1) postgres=# select pg_reload_config();
**ERROR:  function pg_reload_config() does not exist**
LINE 1: select pg_reload_config();
2) postgres@ospostgresql:/$ /usr/lib/postgresql/11/bin/pg_ctl reload
pg_ctl: no database directory specified and environment variable PGDATA unset
Try "pg_ctl --help" for more information.

Thank you so much, I've followed that article only, but I've given the wrong syntax by following genric names like config() — Suresh
– Suresh, Commented Mar 1, 2022 at 14:19

Pavel Chuchuva · Accepted Answer · 2025-01-24 22:37:10Z

21

1) postgres=# select pg_reload_conf();

2) 
    1) su postgres
    2) /usr/lib/postgresql/11/bin/pg_ctl -D /var/lib/postgresql/11/main reload

Incorrect:

select pg_reload_config();
**ERROR:  function pg_reload_config() does not exist**
**-->** This is resolved by giving correct function name

postgres@ospostgresql:/$ /usr/lib/postgresql/11/bin/pg_ctl reload
pg_ctl: no database directory specified and environment variable PGDATA unset
Try "pg_ctl --help" for more information.
**-->** This error is resolved by changing the user to postgres

Thank you @a_horse_with_no_name in helping to identify the typo which causes issue-1

edited Jan 24 at 22:37

Pavel Chuchuva

22.6k11 gold badges103 silver badges119 bronze badges

answered Mar 2, 2022 at 12:27

Suresh

5852 gold badges6 silver badges27 bronze badges

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

Comments

tdy · Accepted Answer · 2024-06-28 21:24:46Z

6

Please use:

SELECT pg_reload_conf();

Or simply:

postgres@server:$ psql -c "SELECT pg_reload_conf()"

edited Jun 28, 2024 at 21:24

tdy

42k42 gold badges124 silver badges125 bronze badges

answered Jun 28, 2024 at 10:59

Alf Normann Klausen

611 silver badge1 bronze badge

Comments

spsquared123 · Accepted Answer · 2023-06-19 20:33:48Z

3

The above answer shows 2 ways to do this, but I found that there are 3 different ways to load Postgresql configuration. Apparently systemctl reload postgresql will also work.

Reference: https://www.heatware.net/postgresql/postgresql-reload-config-without-restarting/

answered Jun 19, 2023 at 20:33

spsquared123

1431 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to reload PostgreSQL configuration

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related