Thread: psql command history
Silly question: When I use psql on redhat, the history works in that I can use the up and down arrows keys to go between past commands just like the bash shell. However, on my suse system, the up and down arrow keys do not do this. Any ideas? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's my....bus?
You need to have the GNU readline library installed. I ran into this with Solaris. Once it's installed the Postgres configure will find and use it. Rob > -----Original Message----- > From: Laurette Cisneros [mailto:laurette@nextbus.com] > Sent: Friday, May 17, 2002 1:11 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] psql command history > > > > Silly question: > > When I use psql on redhat, the history works in that I can > use the up and > down arrows keys to go between past commands just like the > bash shell. > > However, on my suse system, the up and down arrow keys do not do this. > > Any ideas? > > Thanks, > > -- > Laurette Cisneros > The Database Group > (510) 420-3137 > NextBus Information Systems, Inc. > www.nextbus.com > Where's my....bus? > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
I'm not too familiar with Suse, but just had this problem on very customized Mandrake install. I found that installing readline, readline-devel, libtermcap then doing make clean, configure, make, make install again and voila history works. I think it was Alvaro (can't get to the list right now) who give me the hint about libtermcap. Check through your config.log and config.cache and if libtermcap or the readline hints above don't solve the problem, then post them to the list. Keehan --- Laurette Cisneros <laurette@nextbus.com> wrote: > > Silly question: > > When I use psql on redhat, the history works in that I can use the up > and > down arrows keys to go between past commands just like the bash > shell. > > However, on my suse system, the up and down arrow keys do not do > this. > > Any ideas? > > Thanks, > > -- > Laurette Cisneros > The Database Group > (510) 420-3137 > NextBus Information Systems, Inc. > www.nextbus.com > Where's my....bus? > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com
The gnu readline library is installed and the bash history works. So perhaps it is this other readline library that's what I need? Thanks, Laurette On Fri, 17 May 2002 wsheldah@lexmark.com wrote: > > > I thought I remembered reading on the list once upon a time that psql used a > different readline library because the GNU readline's GPL isn't entirely > compatible with PostgreSQL's BSD-type license. Did this change, or am I > remembering wrong? > > Wes > > > > > "Booth, Robert" <Robert_Booth%intuit.com@interlock.lexmark.com> on 05/17/2002 > 04:53:40 PM > > To: "'Laurette Cisneros'" <laurette%nextbus.com@interlock.lexmark.com>, > pgsql-general%postgresql.org@interlock.lexmark.com > cc: (bcc: Wesley Sheldahl/Lex/Lexmark) > Subject: Re: [GENERAL] psql command history > > > You need to have the GNU readline library installed. I ran into this with > Solaris. Once it's installed the Postgres configure will find and use it. > > Rob > > > -----Original Message----- > > From: Laurette Cisneros [mailto:laurette@nextbus.com] > > Sent: Friday, May 17, 2002 1:11 PM > > To: pgsql-general@postgresql.org > > Subject: [GENERAL] psql command history > > > > > > > > Silly question: > > > > When I use psql on redhat, the history works in that I can > > use the up and > > down arrows keys to go between past commands just like the > > bash shell. > > > > However, on my suse system, the up and down arrow keys do not do this. > > > > Any ideas? > > > > Thanks, > > > > -- > > Laurette Cisneros > > The Database Group > > (510) 420-3137 > > NextBus Information Systems, Inc. > > www.nextbus.com > > Where's my....bus? > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's my....bus?
Well, it seems that configure is not finding the readline library: ... checking for readline... (cached) no ... but readline and readline-devel packages are installed (I use yast2 on suse). Why would postgres configure not be finding it? Such an irritating little gnat. L. On Fri, 17 May 2002, Keehan Mallon wrote: > I'm not too familiar with Suse, but just had this problem on very > customized Mandrake install. I found that installing readline, > readline-devel, libtermcap then doing make clean, configure, make, make > install again and voila history works. > > I think it was Alvaro (can't get to the list right now) who give me the > hint about libtermcap. > > Check through your config.log and config.cache and if libtermcap or the > readline hints above don't solve the problem, then post them to the > list. > > Keehan > > --- Laurette Cisneros <laurette@nextbus.com> wrote: > > > > Silly question: > > > > When I use psql on redhat, the history works in that I can use the up > > and > > down arrows keys to go between past commands just like the bash > > shell. > > > > However, on my suse system, the up and down arrow keys do not do > > this. > > > > Any ideas? > > > > Thanks, > > > > -- > > Laurette Cisneros > > The Database Group > > (510) 420-3137 > > NextBus Information Systems, Inc. > > www.nextbus.com > > Where's my....bus? > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's my....bus?
I thought I remembered reading on the list once upon a time that psql used a
different readline library because the GNU readline's GPL isn't entirely
compatible with PostgreSQL's BSD-type license. Did this change, or am I
remembering wrong?
Wes
"Booth, Robert" <Robert_Booth%intuit.com@interlock.lexmark.com> on 05/17/2002
04:53:40 PM
To: "'Laurette Cisneros'" <laurette%nextbus.com@interlock.lexmark.com>,
pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] psql command history
You need to have the GNU readline library installed. I ran into this with
Solaris. Once it's installed the Postgres configure will find and use it.
Rob
> -----Original Message-----
> From: Laurette Cisneros [mailto:laurette@nextbus.com]
> Sent: Friday, May 17, 2002 1:11 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] psql command history
>
>
>
> Silly question:
>
> When I use psql on redhat, the history works in that I can
> use the up and
> down arrows keys to go between past commands just like the
> bash shell.
>
> However, on my suse system, the up and down arrow keys do not do this.
>
> Any ideas?
>
> Thanks,
>
> --
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> Where's my....bus?
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Did you read the previous post that you need libtermcap or its devel? On Fri, May 17, 2002 at 03:30:33PM -0700, Laurette Cisneros wrote: > Well, it seems that configure is not finding the readline library: > > ... > checking for readline... (cached) no > ... > > but readline and readline-devel packages are installed (I use yast2 on > suse). Why would postgres configure not be finding it? > > Such an irritating little gnat. >
Laurette Cisneros <laurette@nextbus.com> writes:
> Well, it seems that configure is not finding the readline library:
> ...
> checking for readline... (cached) no
^^^^^^
Remove configure's cache file and try again.
regards, tom lane
Ah, that's much better! It needed the readline-devel package (installed previously) and then when I cleared the config.cache, did configure, make, make install all is well. Thanks to all for the help! Laurette On Fri, 17 May 2002, Booth, Robert wrote: > The (cached) marker is telling you that configure is using information that > it's already cached. You need to remove the configure cache file. I can't > remember what exactly it's called, but it's an obvious name if you search > the directory. > > Rob > > > -----Original Message----- > > From: Laurette Cisneros [mailto:laurette@nextbus.com] > > Sent: Friday, May 17, 2002 3:31 PM > > To: Keehan Mallon > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] psql command history > > > > > > Well, it seems that configure is not finding the readline library: > > > > ... > > checking for readline... (cached) no > > ... > > > > but readline and readline-devel packages are installed (I use yast2 on > > suse). Why would postgres configure not be finding it? > > > > Such an irritating little gnat. > > > > L. > > On Fri, 17 May 2002, Keehan Mallon wrote: > > > > > I'm not too familiar with Suse, but just had this problem on very > > > customized Mandrake install. I found that installing readline, > > > readline-devel, libtermcap then doing make clean, > > configure, make, make > > > install again and voila history works. > > > > > > I think it was Alvaro (can't get to the list right now) who > > give me the > > > hint about libtermcap. > > > > > > Check through your config.log and config.cache and if > > libtermcap or the > > > readline hints above don't solve the problem, then post them to the > > > list. > > > > > > Keehan > > > > > > --- Laurette Cisneros <laurette@nextbus.com> wrote: > > > > > > > > Silly question: > > > > > > > > When I use psql on redhat, the history works in that I > > can use the up > > > > and > > > > down arrows keys to go between past commands just like the bash > > > > shell. > > > > > > > > However, on my suse system, the up and down arrow keys do not do > > > > this. > > > > > > > > Any ideas? > > > > > > > > Thanks, > > > > > > > > -- > > > > Laurette Cisneros > > > > The Database Group > > > > (510) 420-3137 > > > > NextBus Information Systems, Inc. > > > > www.nextbus.com > > > > Where's my....bus? > > > > > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- > > > > TIP 6: Have you searched our list archives? > > > > > > > > http://archives.postgresql.org > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > LAUNCH - Your Yahoo! Music Experience > > > http://launch.yahoo.com > > > > > > > -- > > Laurette Cisneros > > The Database Group > > (510) 420-3137 > > NextBus Information Systems, Inc. > > www.nextbus.com > > Where's my....bus? > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's my....bus?