Re: postgre-7.4 and readline-4.3 /solaris 8

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(dot)durosay(at)cgm(dot)cnrs-gif(dot)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.