Static build of psql with readline support

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

I've been trying to build the cvs checkout of 8.1.3 on my freebsd 4.9
box with a STATIC psql utility. I keep getting failures trying to hook
in libreadline I think:

lreadline -lcrypt -lcompat -lm -lutil -o psql
/usr/lib/libreadline.a(terminal.o): In function `_rl_get_screen_size':
terminal.o(.text+0x84): undefined reference to `tgetnum'
terminal.o(.text+0xdd): undefined reference to `tgetnum'

You seem to be missing the termcap or curses library in your link.
readline requires whichever of those your platform has.

regards, tom lane

Christopher Kings-Lynne wrote:

Hi guys,

I've been trying to build the cvs checkout of 8.1.3 on my freebsd 4.9
box with a STATIC psql utility. I keep getting failures trying to hook
in libreadline I think:

lreadline -lcrypt -lcompat -lm -lutil -o psql
/usr/lib/libreadline.a(terminal.o): In function `_rl_get_screen_size':
terminal.o(.text+0x84): undefined reference to `tgetnum'
terminal.o(.text+0xdd): undefined reference to `tgetnum'
/usr/lib/libreadline.a(terminal.o): In function `rl_resize_terminal':
terminal.o(.text+0x1ce): undefined reference to `tgetstr'
/usr/lib/libreadline.a(terminal.o): In function `_rl_init_terminal_io':
terminal.o(.text+0x2c6): undefined reference to `tgetent'
terminal.o(.text+0x4a9): undefined reference to `tgetflag'
...more...

It builds fine if I use --disable-readline, but other than that I simply
can't get it to build. I've done gmake distclean, reconfigured, etc.

How do I get this to work? I've basically just added '-static' to the
psql Makefile, eg: 'psql: ${CC} -static ...'

I can build static pg_dump and pg_dumpall just fine (they don't use
readline though of course.)

Add a -lcurses as well, as it seems that as soon as you force static,
libreadline needs to be told explicitly about libcurses. I'm on FreeBSD
6.0, but hopefully this is what is going on on 4.9 too.

Cheers

Mark

On Thu, Mar 16, 2006 at 04:09:53PM +1300, Mark Kirkwood wrote:

Christopher Kings-Lynne wrote:

Hi guys,

I've been trying to build the cvs checkout of 8.1.3 on my freebsd 4.9
box with a STATIC psql utility. I keep getting failures trying to hook
in libreadline I think:

<snip>

Add a -lcurses as well, as it seems that as soon as you force static,
libreadline needs to be told explicitly about libcurses. I'm on FreeBSD
6.0, but hopefully this is what is going on on 4.9 too.

Shared libraries can declare their own dependancies, static libs
cannot. So when doing shared linking you only need to specify the libs
you directly use. For static linking you need to list every library
used by you and the libraries used by those libs etc, etc... The link
lines for static linking are quite different from those for dynamic
linking.

This is incidently one of the reasons why people use libtool. If you
specify static linking, libtool pulls up the .la files scattered across
your disk to determine which libs are dependant on other libs. For
dynamic linking the linker figures it out. For static it takes more
legwork.

Given the amount of legwork needed to make static linking work, is it
worth supporting. readline is an easy case, it only depends on one
other lib. libssl depends on 3 and libkrb5 on 5 other libs. For static
linking we need to specify them all...

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries like
ssl or kerberos be prepared to add a lot more.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries like
ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it to
the ${CC} line, right?

Chris

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries like
ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it to
the ${CC} line, right?

This is what I used (current 8.2 sources FreeBSD 6.0):

*** Makefile.orig       Thu Mar 23 14:37:37 2006
--- Makefile    Thu Mar 23 14:40:46 2006
***************
*** 27,32 ****
--- 27,34 ----

FLEXFLAGS = -Cfe

+ CFLAGS += -static
+ LIBS += -lcurses

all: submake-libpq submake-libpgport submake-backend psql

Andrew Dunstan wrote:

Mark Kirkwood said:

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries
like ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it
to the ${CC} line, right?

This is what I used (current 8.2 sources FreeBSD 6.0):

*** Makefile.orig       Thu Mar 23 14:37:37 2006
--- Makefile    Thu Mar 23 14:40:46 2006
***************
*** 27,32 ****
--- 27,34 ----

FLEXFLAGS = -Cfe

+ CFLAGS += -static
+ LIBS += -lcurses

all: submake-libpq submake-libpgport submake-backend psql

That might work on FBSD but it doesn't work everywhere - when I tried it on
Linux I got nasty link errors.

It does for me (2.6.15-gentoo-r5) - note that my previous mail is way
too vague about which Makefile to patch (sorry): src/bin/psql/Makefile.

Cheers

Mark

Mark Kirkwood said:

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries
like ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it
to the ${CC} line, right?

This is what I used (current 8.2 sources FreeBSD 6.0):

*** Makefile.orig       Thu Mar 23 14:37:37 2006
--- Makefile    Thu Mar 23 14:40:46 2006
***************
*** 27,32 ****
--- 27,34 ----

FLEXFLAGS = -Cfe

+ CFLAGS += -static
+ LIBS += -lcurses

all: submake-libpq submake-libpgport submake-backend psql

That might work on FBSD but it doesn't work everywhere - when I tried it on
Linux I got nasty link errors.

cheers

andrew

Andrew Dunstan wrote:

Mark Kirkwood said:

Andrew Dunstan wrote:

Mark Kirkwood said:

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to
your link line should solve it. But if you include any other
libraries like ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it
to the ${CC} line, right?

This is what I used (current 8.2 sources FreeBSD 6.0):

*** Makefile.orig       Thu Mar 23 14:37:37 2006
--- Makefile    Thu Mar 23 14:40:46 2006
***************
*** 27,32 ****
--- 27,34 ----

FLEXFLAGS = -Cfe

+ CFLAGS += -static
+ LIBS += -lcurses

all: submake-libpq submake-libpgport submake-backend psql

That might work on FBSD but it doesn't work everywhere - when I tried
it on Linux I got nasty link errors.

It does for me (2.6.15-gentoo-r5) - note that my previous mail is way
too vague about which Makefile to patch (sorry): src/bin/psql/Makefile.

FC3:

/home/andrew/pglive/pgsql.plperl-pq/src/interfaces/libpq/ip.c:79: warning:
Using 'getaddrinfo' in statically linked applications requires at runtime the
shared libraries from the glibc version used for linking
collect2: ld returned 1 exit status
make: *** [psql] Error 1

Is that after patching only the psql Makefile? Interesting - you
wouldn't think FC3 would be *that* different ....

Cheers

Mark

Mark Kirkwood said:

Andrew Dunstan wrote:

Mark Kirkwood said:

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to
your link line should solve it. But if you include any other
libraries like ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it
to the ${CC} line, right?

This is what I used (current 8.2 sources FreeBSD 6.0):

*** Makefile.orig       Thu Mar 23 14:37:37 2006
--- Makefile    Thu Mar 23 14:40:46 2006
***************
*** 27,32 ****
--- 27,34 ----

FLEXFLAGS = -Cfe

+ CFLAGS += -static
+ LIBS += -lcurses

all: submake-libpq submake-libpgport submake-backend psql

That might work on FBSD but it doesn't work everywhere - when I tried
it on Linux I got nasty link errors.

It does for me (2.6.15-gentoo-r5) - note that my previous mail is way
too vague about which Makefile to patch (sorry): src/bin/psql/Makefile.

FC3:

/home/andrew/pglive/pgsql.plperl-pq/src/interfaces/libpq/ip.c:79: warning:
Using 'getaddrinfo' in statically linked applications requires at runtime the
shared libraries from the glibc version used for linking
collect2: ld returned 1 exit status
make: *** [psql] Error 1

cheers

andrew

Mark Kirkwood said:

FC3:

/home/andrew/pglive/pgsql.plperl-pq/src/interfaces/libpq/ip.c:79:
warning: Using 'getaddrinfo' in statically linked applications
requires at runtime the shared libraries from the glibc version used
for linking
collect2: ld returned 1 exit status
make: *** [psql] Error 1

Is that after patching only the psql Makefile? Interesting - you
wouldn't think FC3 would be *that* different ....

Yes. I just patched that Makefile, and then in the psql directory did "make
clean; make".

cheers

andrew

On Thu, Mar 23, 2006 at 10:31:24AM +0800, Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries like
ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it to
the ${CC} line, right?

I'm not sure what controls it, but it's quite possible -lcurses tries
to do a dynamic link again, you may need to specify the path to the .a
file.

Note, make sure you actually have the static version installed, not all
distributions come with static versions these days...

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Christopher Kings-Lynne wrote:

To the GP, adding -lncurses (or rather the static equivalent) to your
link line should solve it. But if you include any other libraries like
ssl or kerberos be prepared to add a lot more.

With -lncurses or -lcurses I still can't get this to work. I add it
to the ${CC} line, right?

What is the virtue of this in any case? I can see considerable use for a
statically linked pg_dump, to help with upgrading, but not too much for
statically linked anything else, especially since we are now pretty
relocatable on most platforms at least.

cheers

andrew

What is the virtue of this in any case? I can see considerable use for a
statically linked pg_dump, to help with upgrading, but not too much for
statically linked anything else, especially since we are now pretty
relocatable on most platforms at least.

Upgraded db server to 8.1, but don't want to upgrade client library on 3
webservers to 8.1. Reason being I'll have to end up rebuilding PHP and
more downtime and then new version of libtool, autoconf, etc. and
anything else FreeBSD ports decides it needs. So, I just put static
versions of pg_dump, pg_dumpall and psql on the webservers in
/usr/local/bin so that those machines can still usefully talk to the db
server from the CLI. In particular, I can restore dumps containing
dollar quotes, plus get new psql features and 8.1 dumps.

Chris