Content-Type: multipart/alternative;
 boundary="------------pe5oApXCS6Zben7J0uXdXlQY"
Message-ID: <0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk>
Date: Fri, 21 Nov 2025 10:40:21 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: What is paging my psql
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
References: <5844ca0b-4015-4c56-a43a-f44608185477.ref@yahoo.co.uk>
 <5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk>
 <CAKFQuwYBR-VLCs7qxL_oS81Lw_to5Gs0GZ5MsaYk0eaaZtHdJA@mail.gmail.com>
Content-Language: en-MW
From: lejeczek <peljasz@yahoo.co.uk>
In-Reply-To: 
 <CAKFQuwYBR-VLCs7qxL_oS81Lw_to5Gs0GZ5MsaYk0eaaZtHdJA@mail.gmail.com>
Content-Length: 4990
Archived-At: 
 <https://www.postgresql.org/message-id/0dcb33c5-ca74-4003-9808-adfb4a2d3655%40yahoo.co.uk>
Precedence: bulk

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


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

Two of them do not page the query I showed

-> $ psql --port=5438 --dbname=yja_discourse -c 'select * 
from pg_extension;'
   oid  | extname  | extowner | extnamespace | 
extrelocatable | extversion | extconfig | extcondition
-------+----------+----------+--------------+----------------+------------+-----------+--------------
  13545 | plpgsql  |       10 |           11 | f            
   | 1.0        |           |
  16393 | hstore   |       10 |         2200 | t            
   | 1.8        |           |
  16521 | pg_trgm  |       10 |         2200 | t            
   | 1.6        |           |
  16602 | unaccent |       10 |         2200 | t            
   | 1.1        |           |
  61507 | vector   |       10 |         2200 | t            
   | 0.8.1      |           |
(5 rows)

third server pages - waits for user 'q' to switch back to 
shell prompt.
None of the servers - no that I could find - has $PAGER nor 
$PSQL_PAGER nor $SYSTEMD_PAGER set.
In fact:

-> $ set | egrep -i page
-> $ env | egrep -i page

shows nothing.
None of the servers - I failed to find - has psqlrc, not for 
the user nor system-wide.
On the two non-paging servers with this:
-> $ psql --port=5437 -c '\pset pager on'
Pager is used for long output.

done, the above query does not page - for the output is not 
long enough I believe.
On the third paging server - that does not change behaviour 
neither.
But I also noticed that after 'on/off' - this does not 
change and remains:
-> $ psql --port=5437 -c '\pset' | egrep -i pager
pager                    1
pager_min_lines          0

Should that change/setting not be permanent, at least for 
the session-time being?

thanks, L.

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

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font size="2" face="Courier 10 Pitch"><br>
      All three servers show the same:<br>
      -&gt; $ psql --port=5437 -c '\pset' | egrep -i pager<br>
      pager                    1<br>
      pager_min_lines          0<br>
      <br>
      Two of them do not page the query I showed<br>
      <br>
      -&gt; $ psql --port=5438 --dbname=yja_discourse -c 'select * from
      pg_extension;'<br>
        oid  | extname  | extowner | extnamespace | extrelocatable |
      extversion | extconfig | extcondition <br>
-------+----------+----------+--------------+----------------+------------+-----------+--------------<br>
       13545 | plpgsql  |       10 |           11 | f              |
      1.0        |           | <br>
       16393 | hstore   |       10 |         2200 | t              |
      1.8        |           | <br>
       16521 | pg_trgm  |       10 |         2200 | t              |
      1.6        |           | <br>
       16602 | unaccent |       10 |         2200 | t              |
      1.1        |           | <br>
       61507 | vector   |       10 |         2200 | t              |
      0.8.1      |           | <br>
      (5 rows)<br>
      <br>
      third server pages - waits for user 'q' to switch back to shell
      prompt.<br>
      None of the servers - no that I could find - has $PAGER nor
      $PSQL_PAGER nor $SYSTEMD_PAGER set.<br>
      In fact:<br>
      <br>
      -&gt; $ set | egrep -i page<br>
      -&gt; $ env | egrep -i page<br>
      <br>
      shows nothing.<br>
      None of the servers - I failed to find - has psqlrc, not for the
      user nor system-wide.<br>
      On the two non-paging servers with this:<br>
      -&gt; $ psql --port=5437 -c '\pset pager on'<br>
      Pager is used for long output.<br>
      <br>
      done, the above query does not page - for the output is not long
      enough I believe.<br>
      On the third paging server - that does not change behaviour
      neither.<br>
      But I also noticed that after 'on/off' - this does not change and
      remains:<br>
      -&gt; $ psql --port=5437 -c '\pset' | egrep -i pager<br>
      pager                    1<br>
      pager_min_lines          0<br>
      <br>
      Should that change/setting not be permanent, at least for the
      session-time being?<br>
      <br>
      thanks, L.<br>
      <br>
    </font>
  </body>
</html>

--------------pe5oApXCS6Zben7J0uXdXlQY--