pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: S Bob <sbob@quadratum-braccas.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Odd config issue, cannot set log_min_duration_statement
Date: Thu, 14 Jan 2021 21:53:46 -0500
Message-ID: <1624198.1610679226@sss.pgh.pa.us> (raw)
In-Reply-To: <fbb0f2cc-29e6-89f2-8395-f58067353c23@quadratum-braccas.com>
References: <2a31bc9d-5c9b-b76e-083d-c4fb392f0834@quadratum-braccas.com>
	<1623237.1610677900@sss.pgh.pa.us>
	<fbb0f2cc-29e6-89f2-8395-f58067353c23@quadratum-braccas.com>

S Bob <sbob@quadratum-braccas.com> writes:
> On 1/14/21 7:31 PM, Tom Lane wrote:
>> Hmm, that should have worked.  What do you see in
>> select * from pg_settings where name = 'log_min_duration_statement';

> source          | user

IIRC, that means you've applied a setting via ALTER USER,
which'd override the default from the config file.

			regards, tom lane





view thread (8+ messages)  latest in thread

Message-ID: <1624198.1610679226@sss.pgh.pa.us>
Permalink:  ../1624198.1610679226@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1624198.1610679226@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Odd config issue, cannot set log_min_duration_statement
  In-Reply-To: <1624198.1610679226@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox