Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PostgreSQL TEMPLATE db Skeletons

Discussion in 'Database Discussion' started by 850mph, Dec 5, 2008.

  1. 850mph

    850mph Registered

    Dec 5, 2008
    Likes Received:
    Trophy Points:
    Is there any way to use cPanel's postgreSQL database creation tools to specify a skeleton other than database 'template1' upon database creation--??

    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?


Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice