pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedviewing results in terminal on RedHat 6.1
3+ messages / 2 participants
[nested] [flat]
* viewing results in terminal on RedHat 6.1
@ 2011-06-03 12:49 Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Campbell, Lance @ 2011-06-03 12:49 UTC (permalink / raw)
To: pgsql-admin
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?
Thanks,
Lance Campbell
Software Architect/Project Manager/DBA
Web Services at Public Affairs
217.333.0382
http://illinois.edu/toolbox
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: viewing results in terminal on RedHat 6.1
@ 2011-06-03 13:31 Brett Parker <iDunno@sommitrealweird.co.uk>
parent: Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Brett Parker @ 2011-06-03 13:31 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: viewing results in terminal on RedHat 6.1
@ 2011-06-03 16:15 Campbell, Lance <lance@illinois.edu>
parent: Brett Parker <iDunno@sommitrealweird.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Campbell, Lance @ 2011-06-03 16:15 UTC (permalink / raw)
To: Brett Parker <iDunno@sommitrealweird.co.uk>; pgsql-admin
Brett,
Thanks! That did it.
Lance
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Brett Parker
Sent: Friday, June 03, 2011 8:32 AM
To: pgsql-admin@postgresql.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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-06-03 16:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-03 12:49 viewing results in terminal on RedHat 6.1 Campbell, Lance <lance@illinois.edu>
2011-06-03 13:31 ` Brett Parker <iDunno@sommitrealweird.co.uk>
2011-06-03 16:15 ` Campbell, Lance <lance@illinois.edu>
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