postgresql shipped with gentoo (afaik, all versions) do not support dynamic loading. please see http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00046.php (the most believable explanation of the problem). Because of this, dynamic procedure creation fails, tsearch2 cannot be installed. Could it be that it's a packaging problem? i.e.: Somewhere in 'configure' phase, postgresql could be told to use dynamic linking??
Portage 2.1.5_rc6 (default-linux/x86/2006.1, gcc-4.1.2, glibc-2.7-r2, 2.6.24-gentoo-r5 i686) ================================================================= System uname: 2.6.24-gentoo-r5 i686 Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz Timestamp of tree: Thu, 24 Apr 2008 05:30:09 +0000 app-shells/bash: 3.2_p33 dev-java/java-config: 1.3.7, 2.1.5 dev-lang/python: 2.4.4-r11, 2.5.2-r2 dev-python/pycrypto: 2.0.1-r6 dev-util/confcache: 0.4.2-r1 sys-apps/baselayout: 2.0.0 sys-apps/openrc: 0.2.2 sys-apps/sandbox: 1.2.18.1-r2 sys-devel/autoconf: 2.13, 2.62 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1 sys-devel/binutils: 2.18-r1 sys-devel/gcc-config: 1.4.0-r4 sys-devel/libtool: 1.5.26 virtual/os-headers: 2.6.25-r1 ACCEPT_KEYWORDS="x86 ~x86" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=pentium4 -fomit-frame-pointer -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/terminfo /etc/udev/rules.d" CXXFLAGS="-O2 -march=pentium4 -fomit-frame-pointer -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="confcache distlocks parallel-fetch sandbox sfperms strict unmerge-orphans userfetch" GENTOO_MIRRORS="ftp://mirror.switch.ch/mirror/gentoo/" LC_ALL="cs_CZ" LDFLAGS="" LINGUAS="cs en" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://gentooligan.raleigh.ibm.com/gentoo-portage" USE="X accessibility aio alsa apache2 bash-completion berkdb bitmap-fonts bzip2 cli cracklib crypt cups curl dbus directfb dri extensions fbcon gdbm glibc-omitfp gnutls gpm hal iconv iproute2 isdnlog ithreads jpeg kde kdeenablefinal kdehiddenvisibility midi mmap mmx mozdevelop mozsvg mp3 mudflap ncurses nls nptl nptlonly ogg opengl openmp pam pcre pdf perl perlsuid pic png postgres ppds pppd qt qt4 rar rdesktop readline reflection sametime sendfile session spl sse ssl svg svga tcpd threads truetype truetype-fonts type1-fonts unicode x86 xorg zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse vmmouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="cs en" USERLAND="GNU" VIDEO_CARDS="i810 vmware vesa fbdev" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Can you please specify which ebuilds of postgresql you tried? dev-db/postgresql or dev-db/postgresql-server ? (and you should upgrade your profile, btw)
I am using dev-db/postgresql 8.3.1 (In reply to comment #2) > Can you please specify which ebuilds of postgresql you tried? > dev-db/postgresql or dev-db/postgresql-server ? > > (and you should upgrade your profile, btw) > (In reply to comment #2) > Can you please specify which ebuilds of postgresql you tried? > dev-db/postgresql or dev-db/postgresql-server ? > > (and you should upgrade your profile, btw) > (In reply to comment #2) > Can you please specify which ebuilds of postgresql you tried? > dev-db/postgresql or dev-db/postgresql-server ? > > (and you should upgrade your profile, btw) >
after profile upgrade & recompile -> all OK.
