Config reload/restart preview

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Config reload/restart preview
Date: 2013-06-20 11:04:56
Message-ID: CAA-aLv56XFhsg1b9wiQvbvyw27_wc3ZkJendKnKo6xKeWnG5oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've noticed that there's no easy way of checking which settings will
change if the config is reloaded, and I think not being able to do this can
cause some unfortunate problems.

For example, a customer went to change their configuration, just setting
log_autovacuum_min_duration to about 20 seconds, and reloaded the server.
However, the log file swelled to over 5GB in size before they realised
something was wrong, and then reverted the change. It transpired that the
reload also pulled in a log_statements change from 'ddl' to 'all' that
someone must have changed at some point without applying it.

Should we have a way of previewing changes that would be applied if we
reloaded/restarted the server?

For example:

pg_ctl previewconfig

SIGHUP: log_statements will change from 'ddl' to 'all'
SIGHUP: log_vacuum_min_duration will change from -1 to 20000
POSTMASTER: fsync will change from 'on' to 'off'

I'm not proposing this specifically, but something that would provide such
information.

--
Thom

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2013-06-20 11:12:32 Re: Bugfix and new feature for PGXS
Previous Message Marko Tiikkaja 2013-06-20 10:27:13 Re: Change authentication error message (patch)