What is paging my psql - Mailing list pgsql-admin

From lejeczek
Subject What is paging my psql
Date
Msg-id 5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk
Whole thread Raw
Responses Re: What is paging my psql
Re: What is paging my psql
List pgsql-admin
Hi guys.

I have virtually identical 3 servers and one is paging the output.

-> $ psql --port=5437 -c '\pset pager'
Pager usage is off.

there is no PAGER nor any other, obvious OS evn var set, yet I do simple query which shows a few lines, eg.
-> $ psql --port=5437 --dbname=upa_discourse -c 'select * from pg_extension;'

and the output is paged, waiting for 'q' from user to go back to shell.
I could not find any psqlrc neither - and the other two servers do not that, to make more bizarre.
Would you know where is it coming from and how to fix it permanently - ideally not by adding stuff but by figuring out why it is the two servers do page and then fixing the odd one same way.
I'm on Ubuntu 22.04 with ver 16 of PG.

thanks, L.

pgsql-admin by date:

Previous
From: kamal deen
Date:
Subject: Postgres Exporter 0.17.0 heavy default statement
Next
From: Sri Mrudula Attili
Date:
Subject: Barman was hung after a Transport endpoint error