Re: What is paging my psql - Mailing list pgsql-admin

From lejeczek
Subject Re: What is paging my psql
Date
Msg-id 0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk
Whole thread Raw
In response to Re: What is paging my psql  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: What is paging my psql
List 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.

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: What is paging my psql
Next
From: lejeczek
Date:
Subject: Re: What is paging my psql