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

[James P. K. I. <jk...@lo...>]

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:
>=20
> su postgres
> createlang -L/usr/lib/pgsql  plpgsql  template1
> ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or=20
> directory
> createlang: language installation failed
>=20
> In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking=20
> in that directory I see a bunch of "*.so" files, but "plpgsql.so" file=20
> is missing - I  believe this is the file that createlang is looking=20
> for.  Where can I get this file or am I on the wrong track.  Using =20
> 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 postgresql us=
ername=20
> >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 e=
rror.
> >
> >
> >You have 2 choices.
> >
> >Either install the plpgsql language handler  manually as explained in th=
e=20
> >postgresql docs.
> >
> >or
> >
> >when logged in as root...
> >
> >"su  postgres"=20
> >
> >
> >and then use the=20
> >"createlang plpgsql template1"
> >"createlang plpgsql Standard"
> >"createlang plpgsql test"
> >
> >An import note that some people don't realize is that the template1 data=
base=20
> >is exactly that..... a template.
> >Anytime you create a new database, postgresql makes a copy of the  templ=
ate1=20
> >database.
> >
> >
> >Cheers,
> >Roy=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
> -------------------------------------------------------
> 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
> !DSPAM:411cf5dc134739290718234!
--=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