Thread: [NOVICE] readline and psql
-----Original Message----- From: Morrison, Trevor (Trevor) Sent: Wednesday, April 03, 2002 3:28 PM To: pgsql-novice@postgresql.org Subject: FW: [NOVICE] readline and psql HI, I am sending this notice again because I didn't get a response the first time. Thank you to any one who can help. HI, I have successfully compiled and installed 7.2 on my RH 7.1 Box with a 2.4.10 kernel. I have used the following configureation paramerter: #!/bin/sh CFLAGS="-O9" ./configure --enable-syslog --with-tcl --enable-odbc --with-openssl--with-includes=/usr/local/include/readline -with-libs=/usr/lib/libreadline The build went as follows: creating cache ./config.cache checking host system type... i686-pc-linux-gnu checking which template to use... linux checking whether to build with locale support... no checking whether to build with recode support... no checking whether to build with multibyte character support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for default soft limit on number of connections... 32 checking for gcc... gcc checking whether the C compiler (gcc -O9 ) works... yes checking whether the C compiler (gcc -O9 ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes using CFLAGS=-O9 checking whether the C compiler (gcc -O9 ) works... yes checking whether the C compiler (gcc -O9 ) is a cross-compiler... no checking for Cygwin environment... no checking for mingw32 environment... no checking for executable suffix... no checking how to run the C preprocessor... gcc -E checking whether gcc needs -traditional... no checking whether to build with Tcl... yes checking whether to build with Tk... yes checking whether to build Perl modules... no checking whether to build Python modules... no checking whether to build Java/JDBC tools... no checking whether to build with PAM support... no building with OpenSSL support checking whether to build the ODBC driver... yes (stand-alone) checking whether to build C++ modules... no using CPPFLAGS= -I/usr/local/include/readline using LDFLAGS= -L/usr/lib/ checking for mawk... no checking for gawk... gawk checking for flex... /usr/bin/flex checking whether ln -s works... yes checking for ld used by GCC... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for ranlib... ranlib checking for lorder... no checking for tar... /bin/tar checking for bison... bison -y checking for wish... /usr/bin/wish checking for perl... /usr/bin/perl checking for readline... no checking for library containing using_history... -lhistory checking for main in -lbsd... yes checking for setproctitle in -lutil... no checking for main in -lm... yes checking for main in -ldl... yes checking for main in -lsocket... no checking for main in -lnsl... yes checking for main in -lipc... no checking for main in -lIPC... no checking for main in -llc... no checking for main in -ldld... no checking for main in -lld... no checking for main in -lcompat... no checking for main in -lBSD... no checking for main in -lgen... no checking for main in -lPW... no checking for main in -lresolv... yes checking for main in -lunix... no checking for library containing crypt... -lcrypt checking for __inet_ntoa in -lbind... no checking for library containing fdatasync... none required checking for CRYPTO_new_ex_data in -lcrypto... yes checking for SSL_library_init in -lssl... yes checking for crypt.h... yes checking for dld.h... no checking for endian.h... yes checking for fp_class.h... no checking for getopt.h... yes checking for ieeefp.h... no checking for pwd.h... yes checking for sys/ipc.h... yes checking for sys/pstat.h... no checking for sys/select.h... yes checking for sys/sem.h... yes checking for sys/socket.h... yes checking for sys/shm.h... yes checking for sys/types.h... yes checking for sys/un.h... yes checking for termios.h... yes checking for kernel/OS.h... no checking for kernel/image.h... no checking for SupportDefs.h... no checking for netinet/in.h... yes checking for netinet/tcp.h... yes checking whether string.h and strings.h may both be included... yes checking for readline/readline.h... yes checking for readline/history.h... yes checking for openssl/ssl.h... yes checking for openssl/err.h... yes checking for working const... yes checking for inline... inline checking for preprocessor stringizing operator... yes checking for signed types... yes checking for volatile... yes checking whether struct tm is in sys/time.h or time.h... time.h checking for tm_zone in struct tm... yes checking for union semun... no checking for struct cmsgcred... no checking for struct fcred... no checking for struct sockcred... no checking for struct sockaddr_un... yes checking for int timezone... yes checking types of arguments for accept()... int, struct sockaddr *, size_t * checking whether gettimeofday takes only one argument... no checking for 8-bit clean memcmp... yes checking for fcvt... yes checking for getopt_long... yes checking for memmove... yes checking for pstat... no checking for setproctitle... no checking for setsid... yes checking for sigprocmask... yes checking for sysconf... yes checking for waitpid... yes checking for dlopen... yes checking for fdatasync... yes checking for PS_STRINGS... no checking for snprintf... yes checking for vsnprintf... yes checking for isinf... yes checking for getrusage... yes checking for srandom... yes checking for gethostname... yes checking for random... yes checking for inet_aton... yes checking for strerror... yes checking for strdup... yes checking for strtol... yes checking for strtoul... yes checking for strcasecmp... yes checking for cbrt... yes checking for rint... yes checking for rl_completion_append_character... no checking for rl_completion_matches... no checking for rl_filename_completion_function... no checking for finite... yes checking for sigsetjmp... yes checking for syslog... yes checking for optreset... no checking test program... ok checking whether long int is 64 bits... no checking whether long long int is 64 bits... yes checking whether snprintf handles 'long long int' as %lld... yes checking for strtoll... yes checking for strtoull... yes checking for atexit... yes checking size of unsigned long... 4 checking alignment of short... 2 checking alignment of int... 4 checking alignment of long... 4 checking alignment of long long int... 4 checking alignment of double... 4 checking for int8... no checking for uint8... no checking for int64... no checking for uint64... no checking for sig_atomic_t... yes checking for POSIX signal interface... yes checking for tclsh... /usr/bin/tclsh checking for tclConfig.sh... /usr/lib/tclConfig.sh checking for tkConfig.sh... /usr/lib/tkConfig.sh checking for onsgmls... no checking for nsgmls... no updating cache ./config.cache creating ./config.status creating GNUmakefile creating src/GNUmakefile creating src/Makefile.global creating src/backend/port/Makefile creating src/include/pg_config.h linking ./src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c linking ./src/backend/port/dynloader/linux.h to src/include/dynloader.h linking ./src/include/port/linux.h to src/include/pg_config_os.h linking ./src/makefiles/Makefile.linux to src/Makefile.port linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s I see where it says no to readline, but yet it still finds thea header files. My question is that when I change to the postgres user and start psql like so: psql testdb I do not get to use any of the command history. Now I have installed 7.2 on another machine and the command history works fine. Any help would be appreaciated. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Hi,
here are some guesses:
1) your #/bin/sh is split into several lines (mail???)
2) no whitespace behind openssl
3) only one - before -with-libs
4) you use --with-includes=/usr/local/include/readline, AFAIK readlines
includes are in the readline subdirectory, so this would mean, it is
looking for
/usr/local/include/readline/readline/readline.h
are you sure you didn't meant --with-includes=/usr/local/include and
let readline look for its own libraries (readline/readline.h and
readline/history.h) ?
5) you use -with-libs=/usr/lib/libreadline
is libreadline.so.4 really in /usr/lib/libreadline/libreadline.so.4?
If it's in /usr/lib/libreadline.so.4, you should use
--with-libs=/usr/lib (or omit it completely, since this is the
default AFAIK)
6) When you do it again, think about using the updated Pg7.2.1
Heiko
Morrison, Trevor (Trevor) writes:
>
>
> -----Original Message-----
> From: Morrison, Trevor (Trevor)
> Sent: Wednesday, April 03, 2002 3:28 PM
> To: pgsql-novice@postgresql.org
> Subject: FW: [NOVICE] readline and psql
>
>
> HI,
>
> I am sending this notice again because I didn't get a response the first time. Thank you to any one who can help.
>
> HI,
>
> I have successfully compiled and installed 7.2 on my RH 7.1 Box with a 2.4.10
> kernel.
>
> I have used the following configureation paramerter:
>
> #!/bin/sh
> CFLAGS="-O9" ./configure --enable-syslog --with-tcl --enable-odbc
> --with-openssl--with-includes=/usr/local/include/readline
> -with-libs=/usr/lib/libreadline
>
> The build went as follows:
> creating cache ./config.cache
> checking host system type... i686-pc-linux-gnu
> checking which template to use... linux
> checking whether to build with locale support... no
> checking whether to build with recode support... no
> checking whether to build with multibyte character support... no
> checking whether NLS is wanted... no
> checking for default port number... 5432
> checking for default soft limit on number of connections... 32
> checking for gcc... gcc
> checking whether the C compiler (gcc -O9 ) works... yes
> checking whether the C compiler (gcc -O9 ) is a cross-compiler... no
> checking whether we are using GNU C... yes
> checking whether gcc accepts -g... yes
> using CFLAGS=-O9
> checking whether the C compiler (gcc -O9 ) works... yes
> checking whether the C compiler (gcc -O9 ) is a cross-compiler... no
> checking for Cygwin environment... no
> checking for mingw32 environment... no
> checking for executable suffix... no
> checking how to run the C preprocessor... gcc -E
> checking whether gcc needs -traditional... no
> checking whether to build with Tcl... yes
> checking whether to build with Tk... yes
> checking whether to build Perl modules... no
> checking whether to build Python modules... no
> checking whether to build Java/JDBC tools... no
> checking whether to build with PAM support... no
> building with OpenSSL support
> checking whether to build the ODBC driver... yes (stand-alone)
> checking whether to build C++ modules... no
> using CPPFLAGS= -I/usr/local/include/readline
> using LDFLAGS= -L/usr/lib/
> checking for mawk... no
> checking for gawk... gawk
> checking for flex... /usr/bin/flex
> checking whether ln -s works... yes
> checking for ld used by GCC... /usr/bin/ld
> checking if the linker (/usr/bin/ld) is GNU ld... yes
> checking for ranlib... ranlib
> checking for lorder... no
> checking for tar... /bin/tar
> checking for bison... bison -y
> checking for wish... /usr/bin/wish
> checking for perl... /usr/bin/perl
> checking for readline... no
> checking for library containing using_history... -lhistory
> checking for main in -lbsd... yes
> checking for setproctitle in -lutil... no
> checking for main in -lm... yes
> checking for main in -ldl... yes
> checking for main in -lsocket... no
> checking for main in -lnsl... yes
> checking for main in -lipc... no
> checking for main in -lIPC... no
> checking for main in -llc... no
> checking for main in -ldld... no
> checking for main in -lld... no
> checking for main in -lcompat... no
> checking for main in -lBSD... no
> checking for main in -lgen... no
> checking for main in -lPW... no
> checking for main in -lresolv... yes
> checking for main in -lunix... no
> checking for library containing crypt... -lcrypt
> checking for __inet_ntoa in -lbind... no
> checking for library containing fdatasync... none required
> checking for CRYPTO_new_ex_data in -lcrypto... yes
> checking for SSL_library_init in -lssl... yes
> checking for crypt.h... yes
> checking for dld.h... no
> checking for endian.h... yes
> checking for fp_class.h... no
> checking for getopt.h... yes
> checking for ieeefp.h... no
> checking for pwd.h... yes
> checking for sys/ipc.h... yes
> checking for sys/pstat.h... no
> checking for sys/select.h... yes
> checking for sys/sem.h... yes
> checking for sys/socket.h... yes
> checking for sys/shm.h... yes
> checking for sys/types.h... yes
> checking for sys/un.h... yes
> checking for termios.h... yes
> checking for kernel/OS.h... no
> checking for kernel/image.h... no
> checking for SupportDefs.h... no
> checking for netinet/in.h... yes
> checking for netinet/tcp.h... yes
> checking whether string.h and strings.h may both be included... yes
> checking for readline/readline.h... yes
> checking for readline/history.h... yes
> checking for openssl/ssl.h... yes
> checking for openssl/err.h... yes
> checking for working const... yes
> checking for inline... inline
> checking for preprocessor stringizing operator... yes
> checking for signed types... yes
> checking for volatile... yes
> checking whether struct tm is in sys/time.h or time.h... time.h
> checking for tm_zone in struct tm... yes
> checking for union semun... no
> checking for struct cmsgcred... no
> checking for struct fcred... no
> checking for struct sockcred... no
> checking for struct sockaddr_un... yes
> checking for int timezone... yes
> checking types of arguments for accept()... int, struct sockaddr *, size_t *
> checking whether gettimeofday takes only one argument... no
> checking for 8-bit clean memcmp... yes
> checking for fcvt... yes
> checking for getopt_long... yes
> checking for memmove... yes
> checking for pstat... no
> checking for setproctitle... no
> checking for setsid... yes
> checking for sigprocmask... yes
> checking for sysconf... yes
> checking for waitpid... yes
> checking for dlopen... yes
> checking for fdatasync... yes
> checking for PS_STRINGS... no
> checking for snprintf... yes
> checking for vsnprintf... yes
> checking for isinf... yes
> checking for getrusage... yes
> checking for srandom... yes
> checking for gethostname... yes
> checking for random... yes
> checking for inet_aton... yes
> checking for strerror... yes
> checking for strdup... yes
> checking for strtol... yes
> checking for strtoul... yes
> checking for strcasecmp... yes
> checking for cbrt... yes
> checking for rint... yes
> checking for rl_completion_append_character... no
> checking for rl_completion_matches... no
> checking for rl_filename_completion_function... no
> checking for finite... yes
> checking for sigsetjmp... yes
> checking for syslog... yes
> checking for optreset... no
> checking test program... ok
> checking whether long int is 64 bits... no
> checking whether long long int is 64 bits... yes
> checking whether snprintf handles 'long long int' as %lld... yes
> checking for strtoll... yes
> checking for strtoull... yes
> checking for atexit... yes
> checking size of unsigned long... 4
> checking alignment of short... 2
> checking alignment of int... 4
> checking alignment of long... 4
> checking alignment of long long int... 4
> checking alignment of double... 4
> checking for int8... no
> checking for uint8... no
> checking for int64... no
> checking for uint64... no
> checking for sig_atomic_t... yes
> checking for POSIX signal interface... yes
> checking for tclsh... /usr/bin/tclsh
> checking for tclConfig.sh... /usr/lib/tclConfig.sh
> checking for tkConfig.sh... /usr/lib/tkConfig.sh
> checking for onsgmls... no
> checking for nsgmls... no
> updating cache ./config.cache
> creating ./config.status
> creating GNUmakefile
> creating src/GNUmakefile
> creating src/Makefile.global
> creating src/backend/port/Makefile
> creating src/include/pg_config.h
> linking ./src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c
> linking ./src/backend/port/dynloader/linux.h to src/include/dynloader.h
> linking ./src/include/port/linux.h to src/include/pg_config_os.h
> linking ./src/makefiles/Makefile.linux to src/Makefile.port
> linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s
>
> I see where it says no to readline, but yet it still finds thea header files.
>
> My question is that when I change to the postgres user and start psql like so:
>
> psql testdb
>
> I do not get to use any of the command history. Now I have installed 7.2 on
> another machine and the command history works fine. Any help would be
> appreaciated.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
On Wed, 3 Apr 2002, Morrison, Trevor (Trevor) wrote: > > > -----Original Message----- > From: Morrison, Trevor (Trevor) > Sent: Wednesday, April 03, 2002 3:28 PM > To: pgsql-novice@postgresql.org > Subject: FW: [NOVICE] readline and psql > > > HI, > > I am sending this notice again because I didn't get a response the first time. Thank you to any one who can help. > > HI, > > I have successfully compiled and installed 7.2 on my RH 7.1 Box with a 2.4.10 > kernel. > > I have used the following configureation paramerter: > > #!/bin/sh > CFLAGS="-O9" ./configure --enable-syslog --with-tcl --enable-odbc > --with-openssl--with-includes=/usr/local/include/readline > -with-libs=/usr/lib/libreadline What happens if you leave out "-with-libs=/usr/lib/libreadline" or use "--with-libs=/usr/lib/libreadline" (2 dashes)?
Did you upgrade your glibc to 2.2.4 on 7.1 box?
Also is 7.2 box a fresh install or upgrade from 7.1?
I have the same problem. I find that
readline works on
-- fresh install of 7.2 box (which might be "updated")
-- fresh install of 7.1
It breaks on
-- 7.2 box which was upgraded from 7.1
-- 7.1 box updated with new glibc.
tmorrison@avaya.com ("Morrison, Trevor (Trevor)") wrote in message
news:<2C8B3976EDADFD41950F8C628F3E255A042FC300@co9510avexu2.global.avaya.com>...
> -----Original Message-----
> From: Morrison, Trevor (Trevor)
> Sent: Wednesday, April 03, 2002 3:28 PM
> To: pgsql-novice@postgresql.org
> Subject: FW: [NOVICE] readline and psql
>
>
> HI,
>
> I am sending this notice again because I didn't get a response the first time. Thank you to any one who can help.
>
> HI,
>
> I have successfully compiled and installed 7.2 on my RH 7.1 Box with a 2.4.10
> kernel.
>
> I have used the following configureation paramerter:
>
Try installing libtermcap-devel
tmorrison@avaya.com ("Morrison, Trevor (Trevor)") wrote in message
news:<2C8B3976EDADFD41950F8C628F3E255A042FC300@co9510avexu2.global.avaya.com>...
> -----Original Message-----
> From: Morrison, Trevor (Trevor)
> Sent: Wednesday, April 03, 2002 3:28 PM
> To: pgsql-novice@postgresql.org
> Subject: FW: [NOVICE] readline and psql
>
>
> HI,
>
> I am sending this notice again because I didn't get a response the first time. Thank you to any one who can help.