On 07.04.2016 17:59, Rob Sargent wrote:
>
>> On Apr 7, 2016, at 8:26 AM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:
>>
>>
>>
>>> On 07.04.2016 16:53, Tom Lane wrote:
>>> Alex Ignatov <a.ignatov@postgrespro.ru> writes:
>>>> My question is: is there any option(s) to log non-default
>>>> postgresql.conf values to log file?
>>> No, but you can easily find all the non-default settings by querying
>>> the pg_settings view.
>>>
>>> regards, tom lane
>> Yeah, i know it but pg_settings is available only after pg is ready to accept client connections.
>> Also in some cases log file is placed on another server say, syslog. And if your pg server is not available you cant
sayanything about your pg_settings.
> At that point you're looking in a file: log file or config file. Does it matter which?
>> --
>> Alex Ignatov
>> Postgres Professional: http://www.postgrespro.com
>> The Russian Postgres Company
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
It matter when your pg host is down and all you have is log file. It is
very usual situation. You need historical info.
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company