Creating languages with relative path to shared libraries
When I do a
createlang -L $MYDIR plpgsql template1
It appears that MYDIR must be an absolute path to a directory containing
plpgsql.so. I am wondering if there is any way to make it work with a
relative path (like ../lib). I am trying to build a database on a
development machine and then copy it on to a production machine. The paths
where it is built are differenct than where it will reside and I am running
into dynamic linking issues. Any ideas?
Wade Oberpriller http://www.storagetek.com
Software Development Phone: (763) 424-1538
StorageTek: MRDC (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com Fax: (763) 391-1095
"Oberpriller, Wade D." <oberpwd@nsc-msg01.network.com> writes:
When I do a
createlang -L $MYDIR plpgsql template1
It appears that MYDIR must be an absolute path to a directory containing
plpgsql.so. I am wondering if there is any way to make it work with a
relative path (like ../lib). I am trying to build a database on a
development machine and then copy it on to a production machine. The paths
where it is built are differenct than where it will reside and I am running
into dynamic linking issues. Any ideas?
FWIW, this is solved in 7.2 by building a search path into the backend
itself. createlang now enters the shlib path as just
$libdir/plpgsql
so that the function definition isn't dependent on installation path.
May not help you much today though :-(
regards, tom lane