Content-Type: multipart/alternative;
 boundary="------------L868vOxXyfeuZ8VlP5ElGi62"
Message-ID: <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk>
Date: Thu, 20 Nov 2025 15:16:35 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-admin@lists.postgresql.org
Content-Language: en-MW
From: lejeczek <peljasz@yahoo.co.uk>
Subject: What is paging my psql
References: <5844ca0b-4015-4c56-a43a-f44608185477.ref@yahoo.co.uk>
Content-Length: 2220
Archived-At: 
 <https://www.postgresql.org/message-id/5844ca0b-4015-4c56-a43a-f44608185477%40yahoo.co.uk>
Precedence: bulk

This is a multi-part message in MIME format.
--------------L868vOxXyfeuZ8VlP5ElGi62
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi guys.

I have virtually identical 3 servers and one is paging the 
output.

-> $ psql --port=5437 -c '\pset pager'
Pager usage is off.

there is no PAGER nor any other, obvious OS evn var set, yet 
I do simple query which shows a few lines, eg.
-> $ psql --port=5437 --dbname=upa_discourse -c 'select * 
from pg_extension;'

and the output is paged, waiting for 'q' from user to go 
back to shell.
I could not find any psqlrc neither - and the other two 
servers do not that, to make more bizarre.
Would you know where is it coming from and how to fix it 
permanently - ideally not by adding stuff but by figuring 
out why it is the two servers do page and then fixing the 
odd one same way.
I'm on Ubuntu 22.04 with ver 16 of PG.

thanks, L.

--------------L868vOxXyfeuZ8VlP5ElGi62
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font size="2" face="Courier 10 Pitch">Hi guys.<br>
      <br>
      I have virtually identical 3 servers and one is paging the output.<br>
      <br>
      -&gt; $ psql --port=5437 -c '\pset pager'<br>
      Pager usage is off.<br>
      <br>
      there is no PAGER nor any other, obvious OS evn var set, yet I do
      simple query which shows a few lines, eg.<br>
      -&gt; $ psql --port=5437 --dbname=upa_discourse -c 'select * from
      pg_extension;'<br>
      <br>
      and the output is paged, waiting for 'q' from user to go back to
      shell.<br>
      I could not find any psqlrc neither - and the other two servers do
      not that, to make more bizarre.<br>
      Would you know where is it coming from and how to fix it
      permanently - ideally not by adding stuff but by figuring out why
      it is the two servers do page and then fixing the odd one same
      way.<br>
      I'm on Ubuntu 22.04 with ver 16 of PG.<br>
      <br>
      thanks, L.<br>
      <br>
    </font>
  </body>
</html>

--------------L868vOxXyfeuZ8VlP5ElGi62--