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 1vMRHD-009nFi-2r for pgsql-admin@arkaria.postgresql.org; Fri, 21 Nov 2025 13:34:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vMRHC-007V7G-0q for pgsql-admin@arkaria.postgresql.org; Fri, 21 Nov 2025 13:34:14 +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 1vMRHB-007V77-2u for pgsql-admin@lists.postgresql.org; Fri, 21 Nov 2025 13:34:14 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vMRHA-000jG5-0X for pgsql-admin@lists.postgresql.org; Fri, 21 Nov 2025 13:34:13 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-3ec6c10a295so573071fac.0 for ; Fri, 21 Nov 2025 05:34:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763732050; x=1764336850; 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=MQcvGnPD9yhWF2H+9SxY+FOnbws3cjtMEQuKs8ybG3I=; b=gXWS/pltP3GTnsyGhDEWgPafOZbOHCRaFw6WlbWjV6w6FnPGMRq7/Gr3ZOim/d1JVP ria4wyjTxMX3GaW6W3Hcpb6DXAMiLblFipl/Bin4SojzySFEl2nWZ1EL6+db0BmknPdL Htd61OSV5IDhTXfWR8P+wwidtuJ0apwy+1a6dtBesvBnlSqJVMXau1sKfZFDgNoddj4P j52sATZZGkkyh5rKjvcuL1QSHT69QQzVDCDRyBhedfdf2nsTFt/HZXF+mwZW3che8fjM gRrCqdrhz8WWY4LIaTcPTR6tUB5a22m4OeQXluCszzc8yruwIs7FBGIcsTKU0Uh7JO7b 3TAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763732050; x=1764336850; 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=MQcvGnPD9yhWF2H+9SxY+FOnbws3cjtMEQuKs8ybG3I=; b=cNKQ+WK542TNfeEEa3NxrFbX5fDZ16PqWxy+XnTes4O5wl+IRJAgNclVfKr+Ne8mPo xnjEqRGqgvqpHeUESZGs0cv4xJkrIbzrdEuPonJPuSYH1kebCk/WXmMedPJfAN1CgEmT at2qwQavHvrUUwGnTG7Edm4bsszaDA8dvcXf7tKFLBwBQQzTV7KvOl02nHK8pD2URVzY G+74PFJlqSIgSL7uLIYd5Gd1tVj5kl3Dh9c20naradMF3FfqlvxQTMMYwEyzdA+TOkUx PNJfzFkUa0GMo8E4BLmL8OzPNM18KY7+guYz6ZRhlKINvMTbht94LRRqrkEBdu5sdxuR xpDw== X-Gm-Message-State: AOJu0YzpGn2HsPIyKGjGJpcYwd8sXz51GyeE/mUPUVn+4JrDt5WwxIUp hHDd9Fjmhg1EjZEvv5x4mD9MzYsnbANZjeNACAYoOB75s5CXmPL3faLzBoystMKsvxWJkEf8C41 FSWNLqtBPKU0xuAFALF5Ar93I/S4k5Ic= X-Gm-Gg: ASbGncsuKM7F2grNE+x4dhFahll2/PAMaDEQ4qc7Y6WwvxEZYjFlgIn1wcWieixe0nQ zy9QyPZbdQjObGLBAUv8Zw7/4eOf8rgnc5RAC9u8SLGbJWzwGZDD3sgx/2kFk//jFXU25P/p9kr +0L4ex3EpCf/TdJg7r5T6ROWPgUDTDmJsa0ndShxRKW1Cxz8ciD9DjkMhUYk7oELgqrmGwYbYzd 5j0n9z3zJux8rMcWWa7RgaVlR3HovKv+JtLdIEsgk3VAGYbo+iT3MQbz8yvNmg3JlW2DPI= X-Google-Smtp-Source: AGHT+IH75OfJyopgj9v95Y+NmSaAJTdVkIfn2gW4seEgtMoX1/W9cTNh0Tms9gUwcve9M6A7vQmBnTZ0+Dzky9Y2Ylw= X-Received: by 2002:a05:6808:18a5:b0:450:db96:148 with SMTP id 5614622812f47-45112d168d4mr842127b6e.47.1763732049743; Fri, 21 Nov 2025 05:34:09 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:5ad5:0:b0:605:6b17:9ff8 with HTTP; Fri, 21 Nov 2025 05:34:07 -0800 (PST) In-Reply-To: <0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk> References: <5844ca0b-4015-4c56-a43a-f44608185477.ref@yahoo.co.uk> <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk> <0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk> From: "David G. Johnston" Date: Fri, 21 Nov 2025 07:34:07 -0600 X-Gm-Features: AWmQ_blDbycKAGEjdj-ccTLZ-81LiVKcaicDw65Ek4NtQHC9U4F_pUpXUsfBP14 Message-ID: Subject: Re: What is paging my psql To: lejeczek Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004dd61206441ade06" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004dd61206441ade06 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, November 21, 2025, lejeczek wrote: > > All three servers show the same: > -> $ psql --port=3D5437 -c '\pset' | egrep -i pager > pager 1 > pager_min_lines 0 > Everything seems to be working as intended. You just seem to have incorrect expectations. Whether the pager is used is conditioned on actual output data. pset controls client settings and those are never =E2=80=9Csaved=E2=80=9D. = They have their default values and a psqlrc file if you wish to change them during program startup. David J. --0000000000004dd61206441ade06 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, November 21, 2025, lejeczek <peljasz@yahoo.co.uk> wrote:
=20 =20 =20

All three servers show the same:
-> $ psql --port=3D5437 -c '\pset' | egrep -i pager
pager=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 1
pager_min_lines=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0

Everything seems to be = working as intended.=C2=A0 You just seem to have incorrect expectations.

Whether the pager is used is conditioned on actual o= utput data.

pset controls client settings and thos= e are never =E2=80=9Csaved=E2=80=9D.=C2=A0 They have their default values a= nd a psqlrc file if you wish to change them during program startup.

David J.

--0000000000004dd61206441ade06--