Re: Non-default postgresql.conf values to log

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Non-default postgresql.conf values to log
Date: 2016-04-07 13:35:46
Message-ID: 20160407133546.GA1613@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Alex Ignatov (a(dot)ignatov(at)postgrespro(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2016-04-07 13:40:25 Re: database is not accepting commands to avoid wraparound data loss in database
Previous Message Rakesh Kumar 2016-04-07 12:50:51 Re: Trying to understand page structures in PG