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 1u5h54-004ZBx-WE for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 08:28:15 +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 1u5h53-009hJy-2a for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 08:28:13 +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 1u5h52-009hJY-Mx for pgsql-general@lists.postgresql.org; Fri, 18 Apr 2025 08:28:13 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5h51-000g5Y-1P for pgsql-general@postgresql.org; Fri, 18 Apr 2025 08:28:12 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-30d6a3e97deso1006911fa.3 for ; Fri, 18 Apr 2025 01:28:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744964890; x=1745569690; darn=postgresql.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=V4UVwyjI53mdJu56prwaj+QIzRcY+0a3ypZutkH28ZM=; b=OacFaK7DoYq8H+pazBXdfhDcdGlaklTrg9QKBqzDdUjZ6W7NNg9/29Bd8H/px2KzAv rovPlFwHZ5uzxRWocVotR7cVJpsuL7IRE936eiky/q4/bJMT8S5AaYnujS0PNnmtTWEx zuZE0VSyC+rUn3HlN6pVLYASuDwNzrcKKG2ysrRfAOjxXiVsaY+wFWmMLr1qeaecNTX/ dk74yBvewomh+IU1UNvJt6+ojne8FHt2h3evEDTH+w9zsfJeCYcBXhc/oHiI302HuEaE ZZCXgohsCAUg/ArVNBXqyjCt5zb0PhAUZzTp5ml3wgI3lvz6JMN+kprym7gvKCf9TL1T BCMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744964890; x=1745569690; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=V4UVwyjI53mdJu56prwaj+QIzRcY+0a3ypZutkH28ZM=; b=NW4/Zkzr1RbTIbe3kVSh910i7QmDIXBSSaiA9mH3kG/2lwoUOLVBM1HLqrAibIgixv 8f+RwOuO1qX+NZGwRJbLN1MYH7io9OgZTM4WTqXXg0U6BZqlcj/kPf6qlsptGhkVqb6X OSecsXHLhGfAhF8sQsBX4wVrNfFOwgPFicN6cKn/2z++EsOgmhqQUbz/+KZct+o8KMPA J5Y0N8k/MU1CPGHiluGctcETWnYVOJcAvjzxX/UcRRZHJCI/8m4AMfdABn80o+ektht1 rITfNLgVh8cOweXVNlI+meZsrXTnfbN0Irr7FVLhUB4CfYfMigV2c0Ig5OqfVMc3LbC9 jFQQ== X-Gm-Message-State: AOJu0Yx74yxwRWHiEA8eIObHxcidz5A+nw1dageJwC1c7jpRzleJJtSZ vptQg+qH2MXsDkfriN/wa4RFRUjWGDDc1+3SwvEKz7Z9b2t427zXYcLnlw== X-Gm-Gg: ASbGnctvlDLY2T/At26qQBQLWwKFMRJXsPC7M0xnNA5943FTSoVVQWZSSZBFZJzPi1U 8SaeakCoe0Ngt1gktYPmPXxpQN9rhFAhoNOTVr0XngjosL/tO27rThUb9+KSNicgfwnjbRDYrVE Guhp/5aQ2ZQmLyst0Gs1zDMPsUM/GbjLZSu8zpYEqpjcda65Bs0CiHQ0QWy2c2alhbaUKpRB32l g6qgqD3idJC99kyoIiuC2WuSouE6T5Pj2kctL+uRJWqtQu749fLSNze1alxJ8+OkePxA3WfFR6N 7dMqEjyHrmNd1SZexArmpJUVQ2rIVkM41pVYw+O0yzzrCw== X-Google-Smtp-Source: AGHT+IFZzce+0KZI4UqJV7XM3eAqEp2FOWpaE2G7j5HTphTKCjO/uK/NP0um/T478bJIeoAcHxJUuA== X-Received: by 2002:a05:6512:3f24:b0:549:8fd0:ddaa with SMTP id 2adb3069b0e04-54d6e556b4amr32832e87.0.1744924989048; Thu, 17 Apr 2025 14:23:09 -0700 (PDT) Received: from ant-519666801b8 ([81.177.127.161]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-54d6e5cfddasm25628e87.140.2025.04.17.14.23.08 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 17 Apr 2025 14:23:08 -0700 (PDT) Date: Fri, 18 Apr 2025 00:23:07 +0300 From: Anton Shepelev To: Adrian Klaver Cc: pgsql-general@postgresql.org Subject: Re: Cannot turn track_counts on Message-Id: <20250418002307.a029379d2c0f781ca7726f91@gmail.com> In-Reply-To: <1a99f488-9d24-41d1-a1a5-17ea4ce87899@aklaver.com> References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com> <1900177.1744815217@sss.pgh.pa.us> <20250417170534.b2e919e950b77c4d4dbd5483@gmail.com> <1a99f488-9d24-41d1-a1a5-17ea4ce87899@aklaver.com> X-Mailer: Sylpheed 3.7.0 (GTK+ 2.24.30; i686-pc-mingw32) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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: You need to install postgresql-server-dev-NN for building a server-side extension or libpq-dev for building a client-side application. 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 I will test if clearing shared_preload_libraries and restarting Postgres has any effect on track_counts, just in case. -- () ascii ribbon campaign -- against html e-mail /\ www.asciiribbon.org -- against proprietary attachments