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 22:09:06 -0500
Message-ID: <1624857.1610680146@sss.pgh.pa.us> (raw)
In-Reply-To: <aafc6974-65b7-2891-0966-88f5fd83a423@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>
	<1624198.1610679226@sss.pgh.pa.us>
	<aafc6974-65b7-2891-0966-88f5fd83a423@quadratum-braccas.com>

S Bob <sbob@quadratum-braccas.com> writes:
> On 1/14/21 7:53 PM, Tom Lane wrote:
>> IIRC, that means you've applied a setting via ALTER USER,
>> which'd override the default from the config file.

> Yup, that's the last thing I tried:
> postgres=# ALTER SYSTEM SET log_min_duration_statement = 0;

But somewhere you did "ALTER *USER* yourself", and that's
overriding the ALTER SYSTEM for your sessions.  ALTER USER RESET
should get rid of that.

			regards, tom lane

view thread (8+ messages)

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

copy link · copy postgr.es

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: <1624857.1610680146@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