Menu
▾
▴
Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake
|
From: ms m. l. <ms-...@sk...> - 2004-08-13 20:09:32
|
No, it is in the Mandrake binaries after all. With a bit more digging in rpmdrake, found binary in postgresql-pl-7-3-42-mdk. Fedora will have to wait for another day. SQL-Ledger now running (after fixing read permissions problems on /css directory - don't know why that broke on 2.4 upgrade!) Michael S. James P. Kinney III wrote: >So it looks like you will need to get the src.rpm and compile your own >version since it is not included in the binaries. > >Maybe I shouldn't say it, but Fedora has a great working Postgresql :) > > > >On Fri, 2004-08-13 at 14:40, ms mailing list wrote: > > >>Thanks for the tip Gerado. plpgsql.so buried in >>postgresql-7.3.4-2mdk.src.rpm. It looks like the Mandrake rpm install >>doesn't list this module, but does list some other modules in this >>rpm. Hence my problem finding it. :) >> >>Michael S. >> >>Gerardo Reynoso wrote: >> >> >>>On Friday 13 August 2004 13:12, ms mailing list wrote: >>> >>> >>> >>>>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. >>>> >>>> >>>> >>>> >>>Maybe in another package, er rpm like postgres-lib lib-postgres or postgres- >>>devel? >>> >>> >>> >>> >>>>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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>------------------------------------------------------- >>>>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:411d0d7b139352465114775! >>------------------------------------------------------- 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 >> >> |
