Menu
▾
▴
Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake
|
From: ms m. l. <ms-...@sk...> - 2004-08-13 18:42:31
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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. :)<br>
<br>
Michael S.<br>
<br>
Gerardo Reynoso wrote:<br>
<blockquote cite="mid...@te..."
type="cite">
<pre wrap="">On Friday 13 August 2004 13:12, ms mailing list wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->
Maybe in another package, er rpm like postgres-lib lib-postgres or postgres-
devel?
</pre>
<blockquote type="cite">
<pre wrap="">Michael S.
James P. Kinney III wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
</pre>
</blockquote>
<pre wrap="">-------------------------------------------------------
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.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
!DSPAM:411cf5dc134739290718234!
</pre>
</blockquote>
</blockquote>
<pre wrap="">-------------------------------------------------------
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.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
-------------------------------------------------------
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.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
</pre>
</blockquote>
</body>
</html>
|
