Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[ms m. l. <ms-...@sk...>]

I have the same problem,  but get an additional error:

su postgres
createlang -L/usr/lib/pgsql  plpgsql  template1
ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or 
directory
createlang: language installation failed

In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking 
in that directory I see a bunch of "*.so" files, but "plpgsql.so" file 
is missing - I  believe this is the file that createlang is looking 
for.  Where can I get this file or am I on the wrong track.  Using  
postgresql 7.3.4,  that came with mandrake.

Michael S.

Roy W Pennington wrote:

>Unfortunately Createlang does not allow you to specify the postgresql username 
>so it uses the username you are logged in as. In your case.... root.
>Since root is not a postgresql user in your configuration, you get the error.
>
>
>You have 2 choices.
>
>Either install the plpgsql language handler  manually as explained in the 
>postgresql docs.
>
>or
>
>when logged in as root...
>
>"su  postgres" 
>
>
>and then use the 
>"createlang plpgsql template1"
>"createlang plpgsql Standard"
>"createlang plpgsql test"
>
>An import note that some people don't realize is that the template1 database 
>is exactly that..... a template.
>Anytime you create a new database, postgresql makes a copy of the  template1 
>database.
>
>
>Cheers,
>Roy 
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>_______________________________________________
>sql-ledger-users mailing list
>sql...@sq...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>