Re: Non-default postgresql.conf values to log - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Non-default postgresql.conf values to log
Date
Msg-id 20160407133546.GA1613@elch.exwg.net
Whole thread Raw
In response to Non-default postgresql.conf values to log  (Alex Ignatov <a.ignatov@postgrespro.ru>)
List 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 by date:

Previous
From: Lars Arvidson
Date:
Subject: Re: Problem after replication switchover
Next
From: Merlin Moncure
Date:
Subject: Re: database is not accepting commands to avoid wraparound data loss in database