Re: How to detect if Postgres needs a restart when configuration changes

Поиск
Список
Период
Сортировка
От Payal Singh
Тема Re: How to detect if Postgres needs a restart when configuration changes
Дата
Msg-id CANUg7LDCXN_xkrUPb3JEBY7uaChduqs+xX+pbJ78uR99isFEtQ@mail.gmail.com
обсуждение исходный текст
Ответ на How to detect if Postgres needs a restart when configuration changes  (Strahinja Kustudić <strahinjak@nordeus.com>)
Список pgsql-admin
Дерево обсуждения
you can query the context value of the particular setting in pg_settings table. http://www.postgresql.org/docs/9.1/static/view-pg-settings.html

Payal Singh,
Junior Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Tue, Sep 30, 2014 at 7:51 PM, Strahinja Kustudić <strahinjak@nordeus.com> wrote:
I am automating Postgres deployment on Linux and I need to check if Postgres needs to be restarted when a configuration parameter that requires a restart changes, e.g. when you change wal_level. Is there a way to detect a parameter which requires a restart was changed?

Reading the log file after sending SIGHUP is not possible to automate. I know I can query pg_settings and then compare relevant parameters from the conf file, but that means I will need to check all parameters which I set and which require a restart. I only need to know if postgres requires a restart.

Strahinja Kustudić | Lead System Engineer | Nordeus

В списке pgsql-admin по дате отправления:

Предыдущее
От: Strahinja Kustudić
Дата:
Сообщение: How to detect if Postgres needs a restart when configuration changes
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: How to detect if Postgres needs a restart when configuration changes