Menu
▾
▴
Re: [SL] Upgrade problem - 2nd problem with creatlang =?iso-8859-1?q?under=09Mandrake?=
|
From: Gerardo R. <gre...@te...> - 2004-08-13 18:23:26
|
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 > >> > >>!DSPAM:411cf5dc134739290718234! > > ------------------------------------------------------- > 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 |
