Thread: 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 stillthe commmand line history in pgsql doesn't function. I've used the --with-includes and --with-libraries configure optionsto 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 theos. 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,
andstill the commmand line history in pgsql doesn't function. I've used the --with-includes and --with-libraries
configureoptions 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?
Redhat7.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?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
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). Arethere 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). Arethere 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