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
