What is paging my psql

From: lejeczek <peljasz(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: What is paging my psql
Date: 2025-11-20 14:16:35
Message-ID: 5844ca0b-4015-4c56-a43a-f44608185477@yahoo.co.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sri Mrudula Attili 2025-11-20 14:29:34 Barman was hung after a Transport endpoint error
Previous Message kamal deen 2025-11-20 10:10:57 Postgres Exporter 0.17.0 heavy default statement