Обсуждение: createlang fails
> createlang plpgsql template1 ERROR: stat failed on file '$libdir/plpgsql': No such file or directory ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed I compiled from source using prefix=/usr. plpgsql.so is in /usr/lib/postgresql/. I did psql -c 'select version()' and verified 7.3 is being used. Also tried setting 'dynamic_library_path' to '/usr/lib/postgresql' path in postgres.conf. Any help? Thanks. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
I was able to get it to work by editing the createlang script and adding the library path to the PGLIB var. I'd tried setting PGLIB as an environment variable, but that didn't work either. --- CSN <cool_screen_name90001@yahoo.com> wrote: > > > createlang plpgsql template1 > > ERROR: stat failed on file '$libdir/plpgsql': No > such > file or directory > ERROR: stat failed on file '$libdir/plpgsql': No > such > file or directory > createlang: language installation failed > > I compiled from source using prefix=/usr. plpgsql.so > is in /usr/lib/postgresql/. I did psql -c 'select > version()' and verified 7.3 is being used. Also > tried > setting 'dynamic_library_path' to > '/usr/lib/postgresql' path in postgres.conf. Any > help? Thanks. > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
CSN wrote: > I was able to get it to work by editing the createlang > script and adding the library path to the PGLIB var. > I'd tried setting PGLIB as an environment variable, > but that didn't work either. >>>createlang plpgsql template1 >> >>ERROR: stat failed on file '$libdir/plpgsql': No >>such >>file or directory >>ERROR: stat failed on file '$libdir/plpgsql': No >>such >>file or directory >>createlang: language installation failed >> >>I compiled from source using prefix=/usr. plpgsql.so >>is in /usr/lib/postgresql/. I did psql -c 'select >>version()' and verified 7.3 is being used. Also >>tried >>setting 'dynamic_library_path' to >>'/usr/lib/postgresql' path in postgres.conf. Any >>help? Thanks. I don't think that you'll change the libraries location so you can type the full path: /usr/lib/postgresql/... instead of $libdir/...