public inbox for [email protected]
help / color / mirror / Atom feedFrom: lejeczek <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: What is paging my psql
Date: Fri, 21 Nov 2025 10:40:21 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwYBR-VLCs7qxL_oS81Lw_to5Gs0GZ5MsaYk0eaaZtHdJA@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAKFQuwYBR-VLCs7qxL_oS81Lw_to5Gs0GZ5MsaYk0eaaZtHdJA@mail.gmail.com>
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.
view thread (12+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: What is paging my psql
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox