Justin Pitts <justinpitts@gmail.com> wrote:
> I think adding
>
> UNION ALL SELECT 'postgres version', version();
>
> might be a good thing.
Good point. Added.
> Greg Smith <greg@2ndquadrant.com> wrote:
>> Kevin Grittner wrote:
>>>
>>> In fact, I wonder whether we shouldn't leave a couple items
>>> you've excluded, since they are sometimes germane to problems
>>> posted, like lc_collate and TimeZone.
>>
>> I pulled some of them out only because they're not really
>> postgresql.conf settings; lc_collate and lc_ctype for example are
>> set at initdb time. Feel free to hack on that example if you
>> feel it could be improved, just be aware which of those things
>> are not really in the main config file when pondering if they
>> should be included.
Basically, the ones I could remember us needing to ask about on
multiple occasions, I put back -- provisionally. If someone thinks
they're pointless, I won't worry about them being dropped again:
time zone, character encoding scheme, character set, and collation.
I'm pretty sure I've seen us ask about all of those in trying to
sort out a problem.
I also tried the query on a newly installed HEAD build which had no
manual changes to the postgresql.conf file and found a few others
which seemed to me to be worth suppressing.
I took my shot -- anyone else is welcome to do so.... :-)
-Kevin