From: Brett Parker <iDunno@sommitrealweird.co.uk>
To: pgsql-admin@postgresql.org
Subject: Re: viewing results in terminal on RedHat 6.1
Date: Fri, 3 Jun 2011 14:31:49 +0100
Message-ID: <20110603133149.GE22717@miranda> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D7004730E@CITESMBX2.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D7004730E@CITESMBX2.ad.uillinois.edu>
On 03 Jun 12:49, Campbell, Lance wrote:
> Postgres: 9.x
> On RedHat 4.x when I would access Postgres through a terminal for command line queries if the results of a queries exceeded more than 50+ lines I would still see the results after pressing "quit". On RedHat 6.1 Workstation when I see queries that exceed some threshold 50+ when I press "quit" the screen clears away the results so that I can no longer see them.
>
> I also notice this behavior when I ssh into a server running postgres 8.4.x. So the behavior seems to be isolated to Redhat 6.1 not the version of Postgres.
>
> Does anyone know how to tell RedHat 6.1 Workstation to not do this?
It seems that that's actually a problem with the pager (and it's not
really the pagers fault either)...
I'd guess you're using less as the pager, if so try (before starting
psql) doing:
LESS="-X"
export LESS
If that "fixes" it for you, the issue is that the termcap init/deinit
for your terminal clears the output.
Cheers,
--
Brett Parker
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: pgsql-admin@postgresql.org
Cc: iDunno@sommitrealweird.co.uk
Subject: Re: viewing results in terminal on RedHat 6.1
In-Reply-To: <20110603133149.GE22717@miranda>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox