Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory

Hi again,

Running ldd as postgres yields the same as root:

[postgres@hubertus postgres]$ ldd /opt/postgres-7.4.1/lib/ascii_and_mic.so
        libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

the problem occurs when initdb tries to run the conversion_create.sql
script:

# Create pg_conversion and support functions

$ECHO_N "creating conversions... "$ECHO_C
grep -v '^DROP CONVERSION' $datadir/conversion_create.sql |
"$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null || exit_nicely
echo "ok"

for some reason - conversion_create.sql the $libdir is not defined. I tried
to print $libdir from bin/initdb, but this variable is empty. $datadir,
however, is correctly set to /opt/postgres-7.4.1//share.

The following envvars are correctly set for user 'postgres':

export PATH=/opt/postgres-7.4.1/bin:${PATH}
export LD_LIBRARY_PATH=/opt/postgres-7.4.1/lib:${LD_LIBRARY_PATH}
export MANPATH=/opt/postgres-7.4.1/man:${MANPATH}
export PGHOST=localhost
export PGPORT=5432

Hmmm.... ?!

Best regards,
Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 6:19 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> ascii_and_mic.so lives i /opt/postgres-7.4.1/lib, and ldd yields:

> [root@hubertus lib]# ldd ascii_and_mic.so=20
>         libc.so.6 =3D> /lib/i686/libc.so.6 (0x42000000)
>         /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x80000000)

Hmm, nothing wrong with the library file itself then.  So why isn't
initdb able to load it?  The only thing I can think of is some
environment difference between your postgres account and your root
account that affects dynamic linking.  Better look at LD_LIBRARY_PATH
discrepancies, for instance.  You might try running ldd as postgres
instead of root to see if it gives a different answer.  Also you might
want to add /opt/postgres-7.4.1/lib/ to your ldconfig search path.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html