Menu
▾
▴
Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake
|
From: James P. K. I. <jk...@lo...> - 2004-08-13 19:45:51
|
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. :) >=20 > Michael S. >=20 > Gerardo Reynoso wrote: > > On Friday 13 August 2004 13:12, ms mailing list wrote: > > =20 > > > I've just checked the rpms for postgresql for all linuxs. Some conta= in > > > 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. > > >=20 > > > =20 > >=20 > > Maybe in another package, er rpm like postgres-lib lib-postgres or post= gres-=20 > > devel? > >=20 > > =20 > > > Michael S. > > >=20 > > > James P. Kinney III wrote: > > > =20 > > > > 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. > > > >=20 > > > > 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. > > > >=20 > > > > There's always the source install... > > > >=20 > > > > On Fri, 2004-08-13 at 12:46, ms mailing list wrote: > > > > =20 > > > > > I have the same problem, but get an additional error: > > > > >=20 > > > > > su postgres > > > > > createlang -L/usr/lib/pgsql plpgsql template1 > > > > > ERROR: stat failed on file '/usr/lib/pgsql/plpgsql': No such fil= e or > > > > > directory > > > > > createlang: language installation failed > > > > >=20 > > > > > 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 looki= ng > > > > > for. Where can I get this file or am I on the wrong track. Usin= g > > > > > postgresql 7.3.4, that came with mandrake. > > > > >=20 > > > > > Michael S. > > > > >=20 > > > > > Roy W Pennington wrote: > > > > > =20 > > > > > > Unfortunately Createlang does not allow you to specify the post= gresql > > > > > > 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. > > > > > >=20 > > > > > >=20 > > > > > > You have 2 choices. > > > > > >=20 > > > > > > Either install the plpgsql language handler manually as explai= ned in > > > > > > the postgresql docs. > > > > > >=20 > > > > > > or > > > > > >=20 > > > > > > when logged in as root... > > > > > >=20 > > > > > > "su postgres" > > > > > >=20 > > > > > >=20 > > > > > > and then use the > > > > > > "createlang plpgsql template1" > > > > > > "createlang plpgsql Standard" > > > > > > "createlang plpgsql test" > > > > > >=20 > > > > > > An import note that some people don't realize is that the templ= ate1 > > > > > > database is exactly that..... a template. > > > > > > Anytime you create a new database, postgresql makes a copy of t= he=20 > > > > > > template1 database. > > > > > >=20 > > > > > >=20 > > > > > > Cheers, > > > > > > Roy > > > > > >=20 > > > > > >=20 > > > > > > ------------------------------------------------------- > > > > > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blan= k 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 Gif= t. > > > > > > 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 > > > > > > =20 > > > > >=20 > > > > > ------------------------------------------------------- > > > > > 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 > > > > >=20 > > > > >=20 > > > > > =20 > > >=20 > > > ------------------------------------------------------- > > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Medi= a > > > 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 > > > =20 > >=20 > >=20 > > ------------------------------------------------------- > > 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 > >=20 > > =20 > !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 --=20 James P. Kinney III \Changing the mobile computing world/ CEO & Director of Engineering \ one Linux user / Local Net Solutions,LLC \ at a time. / 770-493-8244 \.___________________________./ http://www.localnetsolutions.com GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics) <jk...@lo...> Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7 |
