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 1u50d9-00AlPt-4q for pgsql-general@arkaria.postgresql.org; Wed, 16 Apr 2025 11:08:35 +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 1u50d7-00CQZD-1B for pgsql-general@arkaria.postgresql.org; Wed, 16 Apr 2025 11:08:33 +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 1u4z3h-00AbSm-Oz for pgsql-general@lists.postgresql.org; Wed, 16 Apr 2025 09:27:54 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4z3g-000LbK-1U for pgsql-general@postgresql.org; Wed, 16 Apr 2025 09:27:53 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-549903f3db9so681194e87.1 for ; Wed, 16 Apr 2025 02:27:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744795671; x=1745400471; darn=postgresql.org; h=content-transfer-encoding:mime-version:message-id:subject:to:from :date:from:to:cc:subject:date:message-id:reply-to; bh=pjqCFZa8Kd6BFvu68/3ED0VAkeCiMnm++50+t1f5Zzk=; b=KfNAtz8YAEGDL/R2k73kZJahsxozHnA6/bND6HcWkHy2cgG0fSd4uZKpc+xz7XqfP0 5jUyrW5Tvx9Xz7MB7nRwGcq3AbHGQYxRBCeUFvSs/Hev5ITXbkaOvZPCKyX7OEutQXSM k4Xm0cRGtYEcCo7cyikTGLwsCOI2KViInvoI7VCAqy1j57Vzr/8DeAtpH+/HOtRxNvdC HDaJVSkbVAygEXlXMgXoHXfEXekmuMJwk6PjlfXo982x70W2qHV6/XkFM3tm6YXE5IG/ Ocu7mYbOZqQj6iImHqpeVkw7RPCA+vvQMa5m9m1rq4r2dqNk2s1+I7exn+ra6PC1bZjq aBWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744795671; x=1745400471; h=content-transfer-encoding:mime-version:message-id:subject:to:from :date:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=pjqCFZa8Kd6BFvu68/3ED0VAkeCiMnm++50+t1f5Zzk=; b=H+SBUfyH9fGekA2lpG1UHvBRUCSIaWyy3/ljLa8LnG8xUtDntqjUSi+uTUjy2s3KQL sdFzOD/EQJ2NCVbppFXKFPps+fi0v94PCTYGDQAZzpteVuXecOWSty2Yu02IitFa+QN3 J2p7OWWenzS557SrHL1bAFtzuE5aqs8C/bvt6NeZ/dk3lP6/+pCJ/f5lyU4HEePP6y8w XZvPhNfaJzAgcEO7TD8tRGuwIHEOR8PBJkOiogk4jrQPzLPE5jSKLWWRFq0Jilkio3w1 ymZ32Ou5+RC73DH4UoDvuMmfi0Wpt75RqMoc6QDNRKm9PnddM2dfkDiQOMX9/cb5EeiM jfgg== X-Gm-Message-State: AOJu0YzNuDK2JCUY4yXF/M8QnsEDM7seDtKFrh1jcQezhfXakdVCE2CU Y/DPq20eivBSHQupnysO2EEvJWM0N2A759Z2obJaCWX58VdY9zhwMyYKzA== X-Gm-Gg: ASbGnctS5zw/VHaiW4s4oymPkrOuXwN1vaqCPTyj5ctV3HaKbFDI+adbkRbw52jtP6w aHarOFkpEZ2WErzdEvK9WAtFOCg5gTie+gwuLFCfwzSwef80piBIWZBJ8G5/vj/faDBO8g4we1b ZHOhlutJSTtejHQvQF8G+OCDsndtTrXGejuKVQ7In56y5obaCiGdqpX44Z+9DZ2xf3MtUTt27oX T6gioOPwdYMtDeYvsXQQT0B3gwtcdHpqyrv37/2RsYdKFjDad1fYge1jCW3EZsm0Uyl9Oj01mZo QCJza+AjAWWp+c9WfEQRj9AmLdDcV4HvIWYCGmVtT2OsdH4= X-Google-Smtp-Source: AGHT+IE674HdxVufCeyF3GaeWZoSeNq5plOAyq0KLiiTQ7yFfBzRSl46LPqx3d/Bi5A6BG8zSvi2CA== X-Received: by 2002:a05:6512:15aa:b0:549:7622:2ea2 with SMTP id 2adb3069b0e04-54d64a8e0admr121837e87.1.1744795670612; Wed, 16 Apr 2025 02:27:50 -0700 (PDT) Received: from erp07.git.ru ([94.79.3.94]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-54d3d123151sm1615441e87.9.2025.04.16.02.27.49 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 16 Apr 2025 02:27:49 -0700 (PDT) Date: Wed, 16 Apr 2025 12:27:49 +0300 From: Anton Shepelev To: pgsql-general@postgresql.org Subject: Cannot turn track_counts on Message-Id: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.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 Hello, all. I have a Postgres sever with the 'track_counts' setting stuck in 'off'. I cannot seem to enable it with either of a. ALTER SYSTEM, b. ALTER DATABASE, c. ALTER USER, d. or plain SET. pg_settings shows: name | track_counts setting | on source | override What does 'override' mean in the 'source' column? How can I find where in the system this setting is overridden? -- () ascii ribbon campaign -- against html e-mail /\ www.asciiribbon.org -- against proprietary attachments