Обсуждение: postgre-7.4 and readline-4.3 /solaris 8

Hello All,

I have a problem when starting postgre under solaris 8 :

bash-2.03# su - postgres -c "/usr/local/pgsql/bin/pg_ctl -D /dat/pgsql/data -l pgsql.log start &"
bash-2.03# 5068 Killed
postmaster successfully started


generate a  /dat/pgsql/pgsql.log  file :
ld.so.1: /usr/local/pgsql/bin/postmaster: fatal: libreadline.so.4: open failed: No such file or directory

bash-2.03# locate libreadline.so.4
/opt/sfw/lib/libreadline.so.4
/usr/local/lib/libreadline.so.4

Postmaster did'nt start

postgre's user PATHs are correct
LD_LIBRARY_PATH=:/usr/lib:/usr/local/lib:/opt/sfw/lib:/usr/local/netpbm/lib:/usr/local/pgsql/lib:/usr/local/pbm/lib

PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/local/pgsql/bin:/opt/sfw/bin:/usr/dt/bin:/usr/ucb:/usr/local/netpb


Postmaster invocation don't do better.
# su - postgres -c "/usr/local/pgsql/bin/postmaster -D /dat/pgsql/data"
ld.so.1: /usr/local/pgsql/bin/postmaster: fatal: libreadline.so.4: open failed: No such file or directory
Killed


I reinstalled both  readline & postgresql without more success.
It seem to be there :

bash-2.03# ldd /usr/local/pgsql/bin/postgres
        libz.so =>       /usr/lib/libz.so
        libreadline.so.4 =>      /usr/local/lib/libreadline.so.4
        libcurses.so.1 =>        /usr/lib/libcurses.so.1
        librt.so.1 =>    /usr/lib/librt.so.1
        libresolv.so.2 =>        /usr/lib/libresolv.so.2
        libgen.so.1 =>   /usr/lib/libgen.so.1
        libsocket.so.1 =>        /usr/lib/libsocket.so.1
        libnsl.so.1 =>   /usr/lib/libnsl.so.1
        libdl.so.1 =>    /usr/lib/libdl.so.1
        libm.so.1 =>     /usr/lib/libm.so.1
        libc.so.1 =>     /usr/lib/libc.so.1
        libgcc_s.so.1 =>         /usr/local/lib/libgcc_s.so.1
        libaio.so.1 =>   /usr/lib/libaio.so.1
        libmp.so.2 =>    /usr/lib/libmp.so.2
        /usr/platform/SUNW,Sun-Fire-480R/lib/libc_psr.so.1


Can anybody help me to start it ?

Patrice Durosay

Patrice Durosay <patrice.durosay@cgm.cnrs-gif.fr> writes:
> I reinstalled both  readline & postgresql without more success.
> It seem to be there :

> bash-2.03# ldd /usr/local/pgsql/bin/postgres
>         libz.so =>       /usr/lib/libz.so
>         libreadline.so.4 =>      /usr/local/lib/libreadline.so.4

That's a good start, but now look to see what libreadline.so depends on.

Also, if you are depending on LD_LIBRARY_PATH to make the linker find
these libraries, then make sure that the postgres account's .profile
sets up LD_LIBRARY_PATH the same way.  Remember that "su -" throws away
your environment and adopts the login environment of the target account.

            regards, tom lane

Hi Tom,

Thank you for your remarks, They helped me to solve my problem under Solaris 8.

When I login as postgres, the paths are known  as defined in /etc/profile.
root & postgres are bash users.
no .profile nor .bashrc are defined in the postgres's home dir /dat/pgsql.
I created a .bashrc in the postgres's homedir that was not read by su.
su postgres -c "env" looses LD_LIBRARY_PATH
su - postgres -c "env" looses also PATH (replaced by one directory)

The only way I found to allow postgre launching via /etc/init.d/postgresql
is to add  a
RESTORE_LLP="source $PGDATA/.pathrc;"
in the command lines of the postgresql script :
 su - $PGUSER -c "$RESTORE_LLP $DAEMON start -D '$PGDATA' -s -l $PGLOG"

with the postgres .pathrc file :

# restore minimal LD_LIBRARY_PATH for postgres running
LD_LIBRARY_PATH=/usr/lib:/usr/local/lib:/usr/local/pgsql/lib
export LD_LIBRARY_PATH


Glad to be able to launch postgresql now. Many thanks.

Best regards

Patrice


Tom Lane a écrit :

> Patrice Durosay <patrice.durosay@cgm.cnrs-gif.fr> writes:
> > I reinstalled both  readline & postgresql without more success.
> > It seem to be there :
>
> > bash-2.03# ldd /usr/local/pgsql/bin/postgres
> >         libz.so =>       /usr/lib/libz.so
> >         libreadline.so.4 =>      /usr/local/lib/libreadline.so.4
>
> That's a good start, but now look to see what libreadline.so depends on.
>
> Also, if you are depending on LD_LIBRARY_PATH to make the linker find
> these libraries, then make sure that the postgres account's .profile
> sets up LD_LIBRARY_PATH the same way.  Remember that "su -" throws away
> your environment and adopts the login environment of the target account.