command-line history (readline) fails
Hello... I'm a newbie to postgresql. I've tried a few times to install readline 4.3, followed by postgresql 7.23, and still the commmand line history in pgsql doesn't function. I've used the --with-includes and --with-libraries configure options to point to where the readline header and shared object files are but with similar disappointing results. The readline .so files are in /usr/local/lib - how can I get postgresql to recognize readline is installed? Redhat 7.3 is the os.
The output of ldd -v /usr/local/pgsql/bin/postgres does not find any readline files.
Any help would be appreciated.
Thanks
/j-p.
JUSTATEST Art Online
http://www.justatest.com
On Mon, 2002-10-28 at 14:27, john-paul delaney wrote:
Hello... I'm a newbie to postgresql. I've tried a few times to install readline 4.3, followed by postgresql 7.23, and still the commmand line history in pgsql doesn't function. I've used the --with-includes and --with-libraries configure options to point to where the readline header and shared object files are but with similar disappointing results. The readline .so files are in /usr/local/lib - how can I get postgresql to recognize readline is installed? Redhat 7.3 is the os.
The output of ldd -v /usr/local/pgsql/bin/postgres does not find any readline files.
Any help would be appreciated.
Did you install the readline-devel stuff?
It needs to see the headers.
also, it would be psql that would see them.
FYI:
$ uname -a
FreeBSD lerlaptop.iadfw.net 4.7-STABLE FreeBSD 4.7-STABLE #13: Fri Oct
25 01:32:16 CDT 2002
ler@lerlaptop.lerctr.org:/usr/obj/usr/src/sys/LERLAPTOP i386
$
$ ldd `whence psql`
/usr/local/bin/psql:
libpq.so.2 => /usr/local/lib/libpq.so.2 (0x48084000)
libintl.so.4 => /usr/local/lib/libintl.so.4 (0x48099000)
libssl.so.3 => /usr/local/lib/libssl.so.3 (0x480a1000)
libcrypto.so.3 => /usr/local/lib/libcrypto.so.3 (0x480ce000)
libz.so.2 => /usr/lib/libz.so.2 (0x48183000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x48190000)
libcrypt.so.2 => /usr/lib/libcrypt.so.2 (0x481b5000)
libgnugetopt.so.1 => /usr/local/lib/libgnugetopt.so.1 (0x481ce000)
libm.so.2 => /usr/lib/libm.so.2 (0x481d1000)
libutil.so.3 => /usr/lib/libutil.so.3 (0x481ec000)
libc.so.4 => /usr/lib/libc.so.4 (0x481f5000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x4828e000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x48366000)
$
Thanks
/j-p.JUSTATEST Art Online
http://www.justatest.com---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Thanks Larry... fwiw this is my output.
$ ldd psql
libpq.so.2 => /usr/local/pgsql/lib/libpq.so.2 (0x40013000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x400f2000)
libresolv.so.2 => /lib/libresolv.so.2 (0x4011f000)
libnsl.so.1 => /lib/libnsl.so.1 (0x4012f000)
libdl.so.2 => /lib/libdl.so.2 (0x40143000)
libm.so.6 => /lib/libm.so.6 (0x40146000)
libhistory.so.4 => /lib/libhistory.so.4 (0x40167000)
libc.so.6 => /lib/libc.so.6 (0x4016f000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
I didn't install any readline-devel - just the readline4.3 tarball from gnu.org
I just ran configure, make, make install from default. It doesn't look like postgresql picked up that it had been installed.
Am I doing something completely wrong? (the instructions were just to install readline before compiling postgresql). Are there any step-by-step instructions for this, or should it work out of the box?
regards,
/j-p.
On 28 Oct 2002, Larry Rosenman wrote:
Did you install the readline-devel stuff?
It needs to see the headers.
also, it would be psql that would see them.
FYI:
$ uname -a
FreeBSD lerlaptop.iadfw.net 4.7-STABLE FreeBSD 4.7-STABLE #13: Fri Oct
25 01:32:16 CDT 2002
ler@lerlaptop.lerctr.org:/usr/obj/usr/src/sys/LERLAPTOP i386
$
$ ldd `whence psql`
/usr/local/bin/psql:
libpq.so.2 => /usr/local/lib/libpq.so.2 (0x48084000)
libintl.so.4 => /usr/local/lib/libintl.so.4 (0x48099000)
libssl.so.3 => /usr/local/lib/libssl.so.3 (0x480a1000)
libcrypto.so.3 => /usr/local/lib/libcrypto.so.3 (0x480ce000)
libz.so.2 => /usr/lib/libz.so.2 (0x48183000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x48190000)
libcrypt.so.2 => /usr/lib/libcrypt.so.2 (0x481b5000)
libgnugetopt.so.1 => /usr/local/lib/libgnugetopt.so.1 (0x481ce000)
libm.so.2 => /usr/lib/libm.so.2 (0x481d1000)
libutil.so.3 => /usr/lib/libutil.so.3 (0x481ec000)
libc.so.4 => /usr/lib/libc.so.4 (0x481f5000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x4828e000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x48366000)
JUSTATEST Art Online
http://www.justatest.com
On Mon, 2002-10-28 at 14:54, john-paul delaney wrote:
Thanks Larry... fwiw this is my output.
$ ldd psql
libpq.so.2 => /usr/local/pgsql/lib/libpq.so.2 (0x40013000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x400f2000)
libresolv.so.2 => /lib/libresolv.so.2 (0x4011f000)
libnsl.so.1 => /lib/libnsl.so.1 (0x4012f000)
libdl.so.2 => /lib/libdl.so.2 (0x40143000)
libm.so.6 => /lib/libm.so.6 (0x40146000)
libhistory.so.4 => /lib/libhistory.so.4 (0x40167000)
libc.so.6 => /lib/libc.so.6 (0x4016f000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)I didn't install any readline-devel - just the readline4.3 tarball from gnu.org
I just ran configure, make, make install from default. It doesn't look like postgresql picked up that it had been installed.Am I doing something completely wrong? (the instructions were just to install readline before compiling postgresql). Are there any step-by-step instructions for this, or should it work out of the box?
It needs to find the headers. I suspect configure needs to be told to
look in /usr/local, but I don't remember how to do that.
regards,
/j-p.On 28 Oct 2002, Larry Rosenman wrote:
Did you install the readline-devel stuff?
It needs to see the headers.
also, it would be psql that would see them.
FYI:
$ uname -a
FreeBSD lerlaptop.iadfw.net 4.7-STABLE FreeBSD 4.7-STABLE #13: Fri Oct
25 01:32:16 CDT 2002
ler@lerlaptop.lerctr.org:/usr/obj/usr/src/sys/LERLAPTOP i386
$
$ ldd `whence psql`
/usr/local/bin/psql:
libpq.so.2 => /usr/local/lib/libpq.so.2 (0x48084000)
libintl.so.4 => /usr/local/lib/libintl.so.4 (0x48099000)
libssl.so.3 => /usr/local/lib/libssl.so.3 (0x480a1000)
libcrypto.so.3 => /usr/local/lib/libcrypto.so.3 (0x480ce000)
libz.so.2 => /usr/lib/libz.so.2 (0x48183000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x48190000)
libcrypt.so.2 => /usr/lib/libcrypt.so.2 (0x481b5000)
libgnugetopt.so.1 => /usr/local/lib/libgnugetopt.so.1 (0x481ce000)
libm.so.2 => /usr/lib/libm.so.2 (0x481d1000)
libutil.so.3 => /usr/lib/libutil.so.3 (0x481ec000)
libc.so.4 => /usr/lib/libc.so.4 (0x481f5000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x4828e000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x48366000)JUSTATEST Art Online
http://www.justatest.com---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
On Mon, Oct 28, 2002 at 09:54:32PM +0100, john-paul delaney wrote:
Thanks Larry... fwiw this is my output.
I didn't install any readline-devel - just the readline4.3 tarball from gnu.org
I just ran configure, make, make install from default. It doesn't
look like postgresql picked up that it had been installed.
Well, you'd better install the RPM for readline (which you probably
already have), the readline-devel package and probably (at least on
Mandrake it is needed) the termcap-devel package.
This frees you from some administrative tasks. If you can, avoid
installing packages from non-RPM sources when appropiate RPMs exist.
Your distribution already does the work for you (and this is the whole
point in using a distribution IMHO).
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Al principio era UNIX, y UNIX habl� y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni "Hello USA\n".
john-paul delaney <jp@justatest.com> writes:
I didn't install any readline-devel - just the readline4.3 tarball from gnu.org
I just ran configure, make, make install from default.
That should work.
It doesn't look like postgresql picked up that it had been installed.
Did you re-run PG's configure script after installing readline?
If so, look more closely at the parts of config.log that are checking
for the presence of the readline library and readline headers to try
to see if you can spot why configure is not finding it.
regards, tom lane
Thanks Tom... When I run Postgres' configure, I see the following line during the output:
checking for readline... no
The log doesn't give me any extra information on where it is looking for the readline libraries.
Any more ideas on how I get postgres to recognize the readline files (in /usr/lib)?
regards
/j-p.
On Tue, 29 Oct 2002, Tom Lane wrote:
Did you re-run PG's configure script after installing readline?
If so, look more closely at the parts of config.log that are checking
for the presence of the readline library and readline headers to try
to see if you can spot why configure is not finding it.
JUSTATEST Art Online
http://www.justatest.com
john-paul delaney <jp@justatest.com> writes:
Thanks Tom... When I run Postgres' configure, I see the following line during the output:
checking for readline... no
The log doesn't give me any extra information on where it is looking for the readline libraries.
Look in the corresponding section of config.log ... but basically it's
going to look where your standard linker looks. Maybe you forgot to
mess around with ldconfig after installing libreadline.so?
regards, tom lane