Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 82F719FB1E5 for ; Fri, 12 Jan 2007 03:47:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 57112-09 for ; Fri, 12 Jan 2007 03:46:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 533B69FA59C for ; Fri, 12 Jan 2007 03:46:56 -0400 (AST) Received: (qmail 2362 invoked by uid 540); 12 Jan 2007 07:39:17 -0000 Received: from 217.149.240.98 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(217.149.240.98):. Processed in 0.097917 secs); 12 Jan 2007 07:39:17 -0000 Received: from rzgw1.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@217.149.240.98) by ns1.peker.com.pl with SMTP; 12 Jan 2007 07:39:17 -0000 Message-ID: <45A73CAC.9010404@informatyka.gdansk.pl> Date: Fri, 12 Jan 2007 08:45:48 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: jorge.servan@f1-connecting.com CC: pgsql-admin@postgresql.org Subject: Re: What library uses postmaster when lib postgres files References: <45A42A77.5000701@informatyka.gdansk.pl> <45A4B46A.10106@f1-connecting.com> In-Reply-To: <45A4B46A.10106@f1-connecting.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200701/107 X-Sequence-Number: 24263 I checked the libraries used by pg_ctl and postmaster. They use proper libs without use LD_LIBRARY_PATH, but I used it "for safety" in the postmaster starting script. One more big thanks. Adam Jorge Serván wrote: > The Libraries used are solved by the liker. Try ldd to > show the paths of the library that needs. You can say to > the linker where it can find your libraries (man ld). > > Example 1: default paths from a default paths PostgreSQL installation. > $ ldd /usr/bin/psql > libpq.so.3 => /usr/lib/libpq.so.3 (0x40029000) > libpam.so.0 => /lib/libpam.so.0 (0x40044000) > libssl.so.2 => /lib/libssl.so.2 (0x4004c000) > libcrypto.so.2 => /lib/libcrypto.so.2 (0x40079000) > libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x4013c000) > libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40194000) > libz.so.1 => /usr/lib/libz.so.1 (0x40198000) > libreadline.so.4 => /usr/lib/libreadline.so.4 (0x401a6000) > libtermcap.so.2 => /lib/libtermcap.so.2 (0x401cc000) > libcrypt.so.1 => /lib/libcrypt.so.1 (0x401d0000) > libresolv.so.2 => /lib/libresolv.so.2 (0x401fd000) > libnsl.so.1 => /lib/libnsl.so.1 (0x4020f000) > libdl.so.2 => /lib/libdl.so.2 (0x40225000) > libm.so.6 => /lib/i686/libm.so.6 (0x4022a000) > libc.so.6 => /lib/i686/libc.so.6 (0x4024d000) > libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40388000) > libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 > (0x4039d000) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000) > > Example 2: modified paths from a not default paths PostgreSQL > installation. > Sitefdevel:~$ ldd $HOME/opt/postgres-8.1.5/bin/psql > $ echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH" > LD_LIBRARY_PATH=/home/cvsitef/opt/postgres-8.1.5/lib > libpq.so.4 => /home/cvsitef/opt/postgres-8.1.5/lib/libpq.so.4 > (0x40018000) > libz.so.1 => /usr/lib/libz.so.1 (0x40042000) > libreadline.so.4 => /usr/lib/libreadline.so.4 (0x40050000) > libtermcap.so.2 => /lib/libtermcap.so.2 (0x40076000) > libcrypt.so.1 => /lib/libcrypt.so.1 (0x4007a000) > libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000) > libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000) > libdl.so.2 => /lib/libdl.so.2 (0x400d0000) > libm.so.6 => /lib/i686/libm.so.6 (0x400d4000) > libc.so.6 => /lib/i686/libc.so.6 (0x400f7000) > libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40232000) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000) > > Best regards > Jorge Serván. > > Adam Rad³owski wrote: > >> I'm testing 8.1.3 and 8.1.6 of FC3 2.6.12 . >> I have installed (compiled from source) two copies of PostgreSQL: >> 8.1.3 - typically in /usr/local/pgsql and I have configured path to >> these libs (in ld.so.conf): /usr/local/pgsql/lib >> 8.1.6 - not typically in /usr/local/pgsql816 (I edited before >> installing with "make install" src/Makefile.global and I changed >> "prefix" for install after "configure" and "make") >> I never use this two versions of postmaster parallel, so I use for >> them this same database cluster. >> >> What libraries uses postmaster 8.1.6 in this situation ? Their own >> libs or taken from 8.1.3 ? >> >> Best regards >> Adam >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 7: You can help support the PostgreSQL project by donating at >> >> http://www.postgresql.org/about/donate >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >