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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PostgreSQL TEMPLATE db Skeletons

Discussion in 'Database Discussions' 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