Re: What is paging my psql

From: lejeczek <peljasz(at)yahoo(dot)co(dot)uk>
To:
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: What is paging my psql
Date: 2025-11-21 09:40:21
Message-ID: 0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lejeczek 2025-11-21 09:43:36 Re: What is paging my psql
Previous Message Laurenz Albe 2025-11-20 19:02:12 Re: What is paging my psql