From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Non-default postgresql.conf values to log |
Date: | 2016-04-07 14:59:56 |
Message-ID: | FFD11BE5-6B24-4733-B927-C41AA7F7526C@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Apr 7, 2016, at 8:26 AM, Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> wrote:
>
>
>
>> On 07.04.2016 16:53, Tom Lane wrote:
>> Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)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 say anything 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-04-07 16:31:48 | Re: 9.5 new features |
Previous Message | Alex Ignatov | 2016-04-07 14:26:27 | Re: Non-default postgresql.conf values to log |