Hello-
Is there any way to use cPanel's postgreSQL database creation tools to specify a skeleton other than database 'template1' upon database creation--??
sorta-like:
CREATE DATABASE mydatabase TEMPLATE templatePostGIS
In the case above, TEMPLATE database 'templatePostGIS' would have been previously set up by a superuser to contain all the postGIS (spatial) functions.
Currently, without the ability to specify a TEMPLATE database upon creation, a cPanel regular-user (not an admin) MUST necessarily contact a super-admin to ALTER newly created databases to include functions/extensions NOT present in the skeleton database 'template1' or 'template0'
This adds a step to certain database creation processes-- unnecessarily involving a super-user.
Any ideas?
Thanks



LinkBack URL
About LinkBacks
Reply With Quote




