Re: Non-default postgresql.conf values to log

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Non-default postgresql.conf values to log
Дата
Msg-id 20160407133546.GA1613@elch.exwg.net
обсуждение исходный текст
Ответ на Non-default postgresql.conf values to log  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Список pgsql-general
## Alex Ignatov (a.ignatov@postgrespro.ru):

> My question is: is there any option(s) to log non-default
> postgresql.conf values to log file?

Depending on your use case, I'd start with a simple query:
SELECT name, setting FROM pg_settings WHERE source <> 'default'
Wrap that in a COPY, or perhaps it's good enough to have it in
the database at all times anyway...

Regards,
Christoph

--
Spare Space


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