From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
---|---|
To: | Brett Parker <iDunno(at)sommitrealweird(dot)co(dot)uk>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: viewing results in terminal on RedHat 6.1 |
Date: | 2011-06-03 16:15:04 |
Message-ID: | B75CD08C73BD3543B97E4EF3964B7D70049A9C@CITESMBX2.ad.uillinois.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Brett,
Thanks! That did it.
Lance
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Brett Parker
Sent: Friday, June 03, 2011 8:32 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] viewing results in terminal on RedHat 6.1
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
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Stosberg | 2011-06-03 17:03:31 | Re: surprised to find bloat in insert-only table |
Previous Message | Tom Lane | 2011-06-03 16:02:02 | Re: surprised to find bloat in insert-only table |