| 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.
| 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 |