Re: Non-default postgresql.conf values to log

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

In response to

Responses

Browse pgsql-general by date

  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