Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0FAm-00040u-Bt for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jan 2021 02:49:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l0FAl-0007fR-9f for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jan 2021 02:49:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0FAl-0007f6-2D for pgsql-admin@lists.postgresql.org; Fri, 15 Jan 2021 02:49:11 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0FAi-0004Va-D1 for pgsql-admin@lists.postgresql.org; Fri, 15 Jan 2021 02:49:10 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 9B04C1012; Thu, 14 Jan 2021 21:49:05 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 14 Jan 2021 21:49:05 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=subject:to:cc:references:from :message-id:date:mime-version:in-reply-to:content-type :content-transfer-encoding; s=fm1; bh=UTxwYsvyQLDF8MA6WCLmYYR40B urEphGvTkA9F4UinI=; b=t+u+JvQ1HI4cFgAlI+tDF2r4EvtTU4DOmO8oHesqeZ 6bNMLSgIZQRb6UB+f8NK9cNPNfCuNWcHoirElUvFu2N9XtRVPqB7Zp2yYnYOpk6s vRoV7iLPXpHANmktuu5Mban8g9ff6IqEW2b8eBVXncnh2JwPChVsXQbUxnI84bw0 ma3bEXB0wXBkH7j+5zYg1O1a0614KrYF4AyUQaFJBAlFQrwXQlaX8S5fexpl5t5b P/DFhGM8pxIp6OzDZG15jLTVaWjZa2wMtf3sIVd7NH/VeASYBcDFKQFWEXicWQ+H UGfzgtgD+7P/hlFauY/IwirpOQZD/WZSBkumTbUryPHw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=UTxwYsvyQLDF8MA6WCLmYYR40BurEphGvTkA9F4Ui nI=; b=j1PwkiraYqJjspUhYg6Glg/k+3IcvK0pWPDsl0VC0qHguz9tC6Ni9L5Gs hLwIRjWOeoN8ZSTzG6tn8cgAC/AcEPty5Q8OosHk+85FdQEKq3lhee/S3IhoOc6B IjL17DDIdF/y/6bkzNSyCN4wNnxAFTxz6tsuiUAlfdjhXGm4g6BovZJvRoT2yn0H Ho/ab+NKwCJROiJDDR4UGeS3Nt112f235wmFOF+QKHuuqPK6zong6qQwf/tl5Jxm iwgRLGcrxBpJQtgMDXYpKajyXObYeNE5l0FTEILvBpzcmsfYcWg6GnguT46YIJe6 HIOFawXJoyrS4cLZ9huybfThkjrTg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrtddugdehtdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefuvfhfhffkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefuuceuohgs uceoshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghsrdgtohhmqeenucggtffrrg htthgvrhhnpeegiedtfeevtdefudeuueelffejfefggeeggeeljefguedvtdegkeeileef feekveenucfkphephedtrddvgeefrdduhedtrdekudenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgrthhumhdqsghr rggttggrshdrtghomh X-ME-Proxy: Received: from [10.16.0.101] (50-243-150-81-static.hfc.comcastbusiness.net [50.243.150.81]) by mail.messagingengine.com (Postfix) with ESMTPA id D0E24240057; Thu, 14 Jan 2021 21:49:04 -0500 (EST) Subject: Re: Odd config issue, cannot set log_min_duration_statement To: Scott Ribe Cc: pgsql-admin@lists.postgresql.org References: <2a31bc9d-5c9b-b76e-083d-c4fb392f0834@quadratum-braccas.com> <59F98425-16F4-4759-8958-6AF98B5E8F82@elevated-dev.com> From: S Bob Message-ID: <963dc698-5404-93b0-57bc-bb5eb9b2e05c@quadratum-braccas.com> Date: Thu, 14 Jan 2021 19:49:04 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.6.0 MIME-Version: 1.0 In-Reply-To: <59F98425-16F4-4759-8958-6AF98B5E8F82@elevated-dev.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/14/21 7:37 PM, Scott Ribe wrote: >> On Jan 14, 2021, at 7:12 PM, S Bob wrote: >> >> and restarted the cluster but if I connect via psql and check it's still disabled > Sounds to me like maybe the config file PG loads is not where you think it is... > Actually I thought about that too, verified it, and I also changed the shared_buffers setting at the same time I tried to change log_min_duration_statement, the shared_buffers change was successful