I see the problem now. On a shared host the createuser and createdb are handled by cPanel scripts but not (as yet on my host) createlang.
The createlang utility only installs procedural languages included in the default PostgreSQL distribution, which fortunately includes plpgsql language I need.
If the language is added to template1 then all future databases—including those of other shared users—would have the language installed by default and this—probably for reasons that all the languages are not installed by default—might not be desirable.
So what I need to solve the problem is a cPanel script to install the required procedural languages or alternately—I have to ask the support people to add any required languages when I create a new database.
Unless I have not fully understood the problem then clearly this issue will have to be solved in order to use all of the advanced features of PostgreSQL to be available on shared servers.
Can the createlang utility be made available to an ordinary user just to apply the lang to his database ?
On Nov 19, 2005, at 3:18 AM, Tino Wildenhain wrote:
Am Freitag, den 18.11.2005, 15:29 -0800 schrieb Jeremy Sellors:
Hi,
How can I 'createlang plpgsql database' on a shared server? on my own
machine I just used 'su postgres' and 'createlang plpgsql template1'
but I need to have plpgsql available on a shared server.
Shared or not, the dba has to create it. If you are dba (crateuser,
createdb) you can create the language. If not, ask your dba to do
it for you. (Maybe not in template1 but in your actual database).
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?