|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|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Thanks! That did it.
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
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
If that "fixes" it for you, the issue is that the termcap init/deinit for your terminal clears the output.
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
|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|