Re: "ld.so.l: /usr/local/pgsql/bin/initdb: fatal:

>  What is the exact command you are running (copy/paste)? As simply issuing "su
> postgres" should not run initdb on login.
>
>
>  I typed
>
>  # su postgres
>  $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

Well, that's quite different than what you mentioned before.  You should do it
like this:

su postgres
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sfw/lib
export LD_LIBRARY_PATH
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

But really you should probably use crle to update your ld search lib.