Forum OpenACS Q&A: Newbie with createlang plpgsql mydb problem

1: Newbie with createlang plpgsql mydb problem

Posted by Raul Rodriguez on 12/14/01 12:34 AM

Hello,
I have been trying to install OpenACS 4. I am running RedHat 6.2 and
downloaded PG 7.1.3 (I did not previously have PG on my system). I
followed the "Brief OpenACS 4 installation" Guide. I am currently
getting the following error:

$ createlang plpgsql mydb
Cannot determine PostgreSQL lib directory (PGLIB).
You must identify the PGLIB either with a --pglib option
or by setting the PGLIB environment variable.

I added the following to my /etc/profile as was indicated in the
"Simple PostgreSQL Installation Guide":

LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
export MANPATH

I have done searches throughout the forums, however, I was unable to
find a solution to my problem. Any help is appreciated.

Thank you

2: Response to Newbie with createlang plpgsql mydb problem (response to 1)

Posted by Patrick Giagnocavo on 12/14/01 01:03 AM

try this:

PGLIB=/usr/local/pgsql/lib

export PGLIB

what happens then?

3: Response to Newbie with createlang plpgsql mydb problem (response to 1)

Posted by Raul Rodriguez on 12/14/01 01:13 AM

Thanks you very much. That worked.