Knowledgebase: Linux/Cpanel
How do I create a PostgreSQL database?
Posted by Alpha Daramy on 27 May 2008 05:03 PM

Create A PostgreSQL Database Using The Wizard

Steps
  1. When the page loads, enter the name of your new database in the "New Database" text box.
  2. Next, click on the Create Database button.
  3. You should see the following statement:
    • "Added the database YOUR_DATABASE_NAME."
  4. Enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
  5. Next, click on the Create User button.
  6. You should see the following statement:
    • "Added USERNAME with the password PASSWORD."
  7. Next you will see "Step 3" requesting you to add the user you just created to the database you just created. Click on the Submit button to proceed with adding the user to the database.
  8. You should see the following statement:
    • "User USERNAME was added to the database DATABASE."
  9. When the page loads you will have three available options to choose:
    • Add another database - Click this link if you want to add another PostgreSQL database to your web hosting account.
    • Add another user using the PostgreSQL Database Area - Click this link if you want to add another user to the database you created in the steps above.
    • Return to Home - Click this link if you want to return to the cPanel dashboard.

Create A PostgreSQL Database Manually

Steps
  1. When the page loads, enter the name of your new database in the "New Database" text box.
  2. Next, click on the Create Database button.
  3. You should see the following statement:
    • "Added the database YOUR_DATABASE_NAME."
  4. Click on the Back to Manage Databases link.
  5. When the page loads, you will see a table with your newly created database containing the following information, split into four columns:
    • Database - This entry will be the database name you created in Step 1 above.
    • Size - This entry will be the size of the database you created in Step 1 above.
    • Users - This entry will be the users in the database you created in Step 1 above. When you first create a new database manually, this column entry will be empty. Continue to Step 6 below to learn how to create and add a user to your new database.
    • Actions - You have one choice:
  6. In the "New User" section, enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
  7. Next, click on the Create User button.
  8. You should see the following statement:
    • "Added USERNAME with the password PASSWORD."
  9. Click on the Go Back link.
  10. Find the "Add User To Database" section. Select the user you created in Step 6 above from the "User" drop down menu. Then select the database you created in Step 1 above from the "Database" drop down menu.
  11. Next, click on the Submit button.
  12. You should see the following statement:
    • "User USERNAME was added to the database DATABASE."
  13. Click on the Go Back link.
  14. You should now see the user you created in Step 6 above in the "Users" column.
(139 vote(s))
Helpful
Not helpful

Comments (0)