Re: [ADMIN] Installing plpgsql fails
Tom, I tried what Andreas Schmitz suggested (setting PGLIB=/opt/postgres/product/7.3.3/lib in the createlang script), it didn't return an error but there again it didn't return the CREATELANG message either. Though if I then run the createland lang db again it says that the language is installed. Selecting from pg_language does not show the plpgsql language. Running pg_config --pkglibdir returns - /opt/postgres/product/7.3.3/lib When postgres was installed on this machine back in July the configure script was ran with: ./configure --prefix=/opt/postgres/product/7.3.3 Could this make a difference I was trying to run the dbsize.sql script which fails (ERROR: stat failed on file '$libdir/plpgsql': No such file or directory) because the language isn't installed hence why I'm trying to install the lanaguage. Regards Nigel Bishop -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 23:14 To: Nigel Bishop Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Installing plpgsql fails Nigel Bishop [EMAIL PROTECTED] writes: ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed pg_config --libdir - returns: I think the pg_config setting you need to look at is --pkglibdir. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Installing plpgsql fails
Hi, edit the script called createlang and adjust PGLIB='$libdir'. regards -Andreas On Wednesday 08 October 2003 13:19, Nigel Bishop wrote: Hi Solaris 8 PG V7.3.3 I'm trying to install the procedural language plpgsql using: createlang plpgsql securnet But this fails with: ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed pg_config --libdir - returns: /opt/postgres/product/7.3.3/lib - and in this directory resides a file called plpgsql.so The LD_LIBRARY_PATH variable also contains /opt/postgres/product/7.3.3/lib I've installed this successfully on another Solaris box without a problem. Has anyone got any thoughts? Thanks Regards Nigel Bishop ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Installing plpgsql fails
Nigel Bishop [EMAIL PROTECTED] writes: ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed pg_config --libdir - returns: I think the pg_config setting you need to look at is --pkglibdir. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster