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.96) (envelope-from ) id 1vM5lh-000oiH-2Z for pgsql-admin@arkaria.postgresql.org; Thu, 20 Nov 2025 14:36:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vM5lg-002C0q-0g for pgsql-admin@arkaria.postgresql.org; Thu, 20 Nov 2025 14:36:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vM5lf-002C0h-2k for pgsql-admin@lists.postgresql.org; Thu, 20 Nov 2025 14:36:16 +0000 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vM5ld-000Yyd-2m for pgsql-admin@lists.postgresql.org; Thu, 20 Nov 2025 14:36:15 +0000 Received: by mail-oi1-x22b.google.com with SMTP id 5614622812f47-450c6f5ff81so334717b6e.0 for ; Thu, 20 Nov 2025 06:36:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763649371; x=1764254171; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=sY1RLW8WzU/GiMeqKnxfLt5jvhPTyfEW4NT6oTNkxBU=; b=jhOyxyevgf37AxgiBNMjqAy1Vv9hwEaDdvAedyidhkxbWnUMYCLdZS3TasphFi1ynV fAqaVjIUG8l4SIniOQG8vqj8QQXUGpjyx9Ex0N5dE3SAJMzu2M26Sc05XBIvTYRLtCzS rx1xXQluOLg6N2LdE+R+m0cLgiX0rnZr231C4i3KStzjohWlrC5/EDDEWk1/j5XT13yj ktmJ0ANw7Bn7y3rqH9QrXy+e0YWmW2k+Az+lCj58bHPI3Ep3eAOUVhw9IGzZMzAoCBv3 WfZoX1uOyP/DXSweJgomXiVSFFS0Guy8RfGm4WWqjP36rDL3VZ3uXSeJoHNfozPnAvyg ZY2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763649371; x=1764254171; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=sY1RLW8WzU/GiMeqKnxfLt5jvhPTyfEW4NT6oTNkxBU=; b=EiQJE5zuQJ0mMLng/joX6/4nUrDk+yUIhlKjr7QAdhkrkfaDX2f/6guHMkeAkSKfF7 b1IXEyJLDcYYN9RJguUuh7qy5vW5Knpw0x/IFWSl5BjMKf1JTb6jVIJkiSyg4ET1LFr2 uBD2H9SA6BelxI+9ZqMHU447+mtS70iXnnW44Bgbn1oL29Q+uHizfE12hXXIjbcBTXQa iEdPPliBvi3xE0XlWkvWlJDDNJuPaah826Y0kSKn4N46HgUxKdnIDXoiO4YCosoumpVo Qh+MNNWyLQiAZi0ODJVpZHTiXxN17UzvZWfbq2SyN8GyJ8I0o3oRbyYMJrcjiBnlPzst P9JQ== X-Gm-Message-State: AOJu0YwHA8A2PQK0tXKa022B5t+XTHnrxVsEVCqtAlsnb+Y7Pdbd84NT ZtI/PY2mumeE6RXrwC2e48z6zopMR/ZRKElE6P1STif3uCT29qg4ERvo+iGXZfQzTRiIM8vPmeF 6/0R5Hc4jBoqDs4veQVe8EHArM/raqu0= X-Gm-Gg: ASbGncuO2D+MPwQ5PtA/VtBffopNvXkDXLWYmO9QIAkJ5V0pvUQaiBOgRclgkEeFvpN YpLWFV+uANRlZmq6/ei07dZ8kTA3Lz59ghDS/Tdgx3OKsJzxFNhLhQjexNlBQpDX+w9jG29mFUQ omsOgJxFVY930F82knWwkn+7SeMDdei40qh3EHYGppWFsS5CluBOP0F9bK82EuXqVB211KgxpBw vyi6Ir942IBn3JEvfWStPRN2IQFB0GufJTxlR21K+J18enOqy1gKlnrkALBsnZgYNozRg== X-Google-Smtp-Source: AGHT+IHnUwfCwg9bKqOR2KrPiQZagWAt68MAnHeeNdDxMEcTqSf9SVH3XkUdOKbMMkYQvwn5H19jW2q4v0T7VZbeR1w= X-Received: by 2002:a05:6808:18a6:b0:44d:aae8:182 with SMTP id 5614622812f47-45101e30969mr1269072b6e.16.1763649371278; Thu, 20 Nov 2025 06:36:11 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:7452:0:b0:603:1b6:c7ef with HTTP; Thu, 20 Nov 2025 06:36:10 -0800 (PST) In-Reply-To: <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk> References: <5844ca0b-4015-4c56-a43a-f44608185477.ref@yahoo.co.uk> <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk> From: "David G. Johnston" Date: Thu, 20 Nov 2025 08:36:10 -0600 X-Gm-Features: AWmQ_bkB4m1rSP5TN3QaBQQDhuh8eaeiK2NMp0-HoSFDcsmx6ZlYmrM9N1EICVQ Message-ID: Subject: Re: What is paging my psql To: lejeczek Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004890200644079e48" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004890200644079e48 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, November 20, 2025, lejeczek wrote: > > > I have virtually identical 3 servers and one is paging the output. > > -> $ psql --port=3D5437 -c '\pset pager' > Pager usage is off. > You just demonstrated that the psql running on this client uses the pager by default. Since by executing pset pager you turned it off. The server being connected to should not play a role. You=E2=80=99ll need = a better example if you claim otherwise. David J. --0000000000004890200644079e48 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, November 20, 2025, lejeczek <peljasz@yahoo.co.uk> wrote:
<= div>
I have virtually identical 3 servers and one is paging the output.
-> $ psql --port=3D5437 -c '\pset pager'
Pager usage is off.

You just demonstrated that the psql running on this client uses the = pager by default.=C2=A0 Since by executing pset pager you turned it off.

The server being connected to should not play a role= .=C2=A0 You=E2=80=99ll need a better example if you claim otherwise.
<= div>
David J.

--0000000000004890200644079e48--