Menu
▾
▴
Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake
|
From: ms m. l. <ms-...@sk...> - 2004-08-13 18:13:50
|
I've just checked the rpms for postgresql for all linuxs. Some contain the missing file (plpgsql.so) and some don't. Unfortunately both mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate to have to switch Linux OS just to get SQL-ledger back up and running. Michael S. James P. Kinney III wrote: >Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl ><filename>.rpm |grep plpgsql to find which one has the lang. > >My latest Fedora setup has the .so files in the same place as yours but >the plpgsql.so file is there. It really sounds like an installation >issue. > >There's always the source install... > >On Fri, 2004-08-13 at 12:46, ms mailing list wrote: > > >>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 >>> >>> >>> >>> >>> >>------------------------------------------------------- >>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 >> >>!DSPAM:411cf5dc134739290718234! >> >> |
