public inbox for [email protected]  

help / color / mirror / Atom feed

From: lejeczek <[email protected]>
To: [email protected]
Subject: What is paging my psql
Date: Thu, 20 Nov 2025 15:16:35 +0100
Message-ID: <[email protected]> (raw)
References: <[email protected]>

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.

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