Thread: psql command line history not working

psql command line history not working

From
Charlie Toohey
Date:
I am trying to get command line history and editing to work with psql, as
life is a pain without it.

I'm running PostgreSQL 7.1.3 on Linux.

Documenation on this subject is very archaic, but I have done the following
so far:

- installed readline library
- run ./configure with the following command line options
  --with-libs=/usr/local/lib --with-includes=/usr/local/include

I am still getting quite a few errors in the config.log file when I run gmake:

- after "checking for readline" there are a bunch of errors, such as
"undefined reference to tputs", "undefined reference to tgoto", etc.
 followed by "failed program was: #line 3111 "configure" "

- in the block beginning with "int main() { readline() " I get "cannot find
-ledit" --- but I haven't been able to find the edit library anywhere

- the following block gives "undefined reference to setproctitle" when
checking for setproctitle in -lutil

- int main() { setproctitle..   in turn fails because of "cannot find lsocket"
again, I can not find the socket library anywhere

and so on...

Does anyone have a list of what needs to be installed to get psql command
line history to work on Linux ? (and WHERE I can find these libraries, etc..?)

Thanks In Advance,
Charlie






Re: psql command line history not working

From
Peter Eisentraut
Date:
Charlie Toohey writes:

> I am trying to get command line history and editing to work with psql, as
> life is a pain without it.

Check that you have the readline header files installed (and if configure
finds them; readline.h, history.h or similar).  Look for RPMs
readline-devel or some such.

--
Peter Eisentraut   peter_e@gmx.net


Re: psql command line history not working

From
"Dan MacNeil"
Date:
>[getting readline support ]
> - installed readline library

Did you install the header files ?

If you are installing a binary that is compiled to use the library,
the library is enough. If you are compiling from scratch, you need the
.h files as well.

On Debian potato the command is:

        apt-get install libreadline4-dev

Hope this helps
----- Original Message -----
From: "Charlie Toohey" <ctoohey@pacbell.net>
To: <pgsql-admin@postgresql.org>
Sent: Monday, April 15, 2002 1:53 PM
Subject: [ADMIN] psql command line history not working


> I am trying to get command line history and editing to work with
psql, as
> life is a pain without it.
>
> I'm running PostgreSQL 7.1.3 on Linux.
>
> Documenation on this subject is very archaic, but I have done the
following
> so far:
>
> - installed readline library
> - run ./configure with the following command line options
>   --with-libs=/usr/local/lib --with-includes=/usr/local/include
>
> I am still getting quite a few errors in the config.log file when I
run gmake:
>
> - after "checking for readline" there are a bunch of errors, such as
> "undefined reference to tputs", "undefined reference to tgoto", etc.
>  followed by "failed program was: #line 3111 "configure" "
>
> - in the block beginning with "int main() { readline() " I get
"cannot find
> -ledit" --- but I haven't been able to find the edit library
anywhere
>
> - the following block gives "undefined reference to setproctitle"
when
> checking for setproctitle in -lutil
>
> - int main() { setproctitle..   in turn fails because of "cannot
find lsocket"
> again, I can not find the socket library anywhere
>
> and so on...
>
> Does anyone have a list of what needs to be installed to get psql
command
> line history to work on Linux ? (and WHERE I can find these
libraries, etc..?)
>
> Thanks In Advance,
> Charlie
>
>
>
>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>


Re: psql command line history not working

From
Edipo Elder Fernandes de Melo
Date:
Em 15 Apr 2002, Peter Eisentraut escreveu:

>> I am trying to get command line history and editing to work with psql, as
>> life is a pain without it.
>
>Check that you have the readline header files installed (and if configure
>finds them; readline.h, history.h or similar). Look for RPMs
>readline-devel or some such.

    I had same problem. But, in my case, i instaled readline-devel, used
--with-includes and --with-libs, as described in docs, and the configure
script still not find/using them.

    Abracos,

    Edipo Elder
    [edipoelder@ig.com.br]

_________________________________________________________________________
Voc� podia estar baixando sua musica predileta, enquanto lia esse e-mail.
N�o perca tempo, tenha acesso r�pido a internet com o Super iG.
http://registro.ig.com.br/superig