Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u5X2P-0021UK-4p for pgsql-general@arkaria.postgresql.org; Thu, 17 Apr 2025 21:44:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u5X2K-0019GW-Sx for pgsql-general@arkaria.postgresql.org; Thu, 17 Apr 2025 21:44:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u5X2J-0019GO-MO for pgsql-general@lists.postgresql.org; Thu, 17 Apr 2025 21:44:45 +0000 Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u5X2H-000bXg-2I for pgsql-general@postgresql.org; Thu, 17 Apr 2025 21:44:43 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.stl.internal (Postfix) with ESMTP id 99B1A2540164; Thu, 17 Apr 2025 17:44:40 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Thu, 17 Apr 2025 17:44:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1744926280; x=1745012680; bh=e5xFwEZrZe7myoYfsq5uiBPEsGhJ54LM2W0UsnYxAiw=; b= UTPtm4HKcS2ck/1vHQO+aS/NpaeM5BGoX+fuXun7wNji7WOxxpPyhxWAaqKd9/NX Yy8ZhcZdeYCIVn1xbGJlEg4rkZdRyBfEVKIx9hHaO5vJhYkxgRlMutdix1kMmdWf wIzWZ8s3PIB5iuJT10oBkXNLGelReG/QebVqjGnRJXgxReZZ37sVaeQ/Y+GooQck cdyMYQh87AG+mMMzDI+Nz2hzKYysn1AeridwtiPHQfnLploZggWtpZ2k3tYCZOCJ /NVpNaWi3XS3K/pZeM7LJJIWKY6R7CdaMAul4TO9Fu77sdc9VEE9AYGRBHmrOqBg BFc13U/OZ6fJTOoa3lgVuA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1744926280; x= 1745012680; bh=e5xFwEZrZe7myoYfsq5uiBPEsGhJ54LM2W0UsnYxAiw=; b=f rrT6KucjM781pS4rEaNHU7HUAprd0VeArQPcSpzZMCtYafTsIoJ9HKw3LV3m6Xup h5l2GaOc6hQtuH+nhFUgtJ7LOcEztybK13MDnTyLyCXzThWQwwPSQQ4TTN43kifY n5vWUGlGr+oxq5SJnHL+S+ci096mUBqEbXgdR3nlI8SjK3HZFSAwLZEEJYnbPY6D mee/vqPG6/rT6bfDSTd/M5tUeoLGKLNrlDXUX9YD+WbqSigLG22VDMTF4xG/+Msx 5Rp5ehJ6r708+dCJv12W/c8jTlk/6TCZBRAomOB0of57CRh4bkYPlpXJgnPWDNMT pqB9wJIJk/xeaF2pnAlqA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvfedtfeejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff ggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghnucfmlhgr vhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtf frrghtthgvrhhnpeegueehhfffteeuudfhleevieeflefgteevvefhffevveeuleetvddv ueehffejgeenucffohhmrghinhepphhoshhtghhrvghsphhrohdrtghomhdpfihikhhiph gvughirgdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprh gtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhhtohhnrdht gihtsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesph hoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 17 Apr 2025 17:44:39 -0400 (EDT) Message-ID: <5d7257a9-9c1c-461e-b902-819a43b8c0b8@aklaver.com> Date: Thu, 17 Apr 2025 14:44:39 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Cannot turn track_counts on To: Anton Shepelev Cc: pgsql-general@postgresql.org References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com> <1900177.1744815217@sss.pgh.pa.us> <20250417170534.b2e919e950b77c4d4dbd5483@gmail.com> <1a99f488-9d24-41d1-a1a5-17ea4ce87899@aklaver.com> <20250418002307.a029379d2c0f781ca7726f91@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <20250418002307.a029379d2c0f781ca7726f91@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/17/25 14:23, Anton Shepelev wrote: > Adrian Klaver to Anton Shepelev: > >>> db=# show shared_preload_libraries; >>> shared_preload_libraries >>> --------------------------- >>> online_analyze, plantuner >> >> Are you running PostgresPro? >> >> Both those modules are associated with it: >> >> https://postgrespro.com/docs/postgrespro/17/contrib.html > > Not at all. Whereas `pg_config --version' answers with an > irrelevant quip: The below does not look like a Postgres message to me. > > You need to install postgresql-server-dev-NN for building > a server-side extension or libpq-dev for building a > client-side application. > How was this Postgres instance installed or built? > The version() SQL function returns: > > PostgreSQL 11.21 (Debian 1:11.21-astra.se6+ci1) > on x86_64-pc-linux-gnu, > compiled by gcc (AstraLinuxSE 8.3.0-6) 8.3.0, 64-bit Not seeing how the above is matching up with: https://en.wikipedia.org/wiki/Astra_Linux > > I will test if clearing shared_preload_libraries and > restarting Postgres has any effect on track_counts, just in > case. > -- Adrian Klaver adrian.klaver@aklaver.com