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

>[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(at)pacbell(dot)net>
To: <pgsql-admin(at)postgresql(dot)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
>
>
>

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(at)gmx(dot)net