Create PostgreSQL Database

Overview

PostgreSQL databases allow you to store lots of information in an easy to access manner. The databases themselves are not easily read by humans. PostgreSQL databases are required by many web applications including some bulletin boards, content management systems, and others. To use a database, you'll need to create it. Only PostgreSQL Users (different than mail or other users) that have privileges to access a database can read from or write to that database.

There are two ways to create a PostgreSQL database The easiest way to create a PostgreSQL database is to use the PostgreSQL Database Wizard built directly into the cPanel interface. The second way involves a few more steps, but does not require you to go through the wizard.

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.
  • 74 Benutzer fanden dies hilfreich
War diese Antwort hilfreich?

Verwandte Artikel

Repair DB (MySQL)

Overview You can repair your MySQL database by using the "Repair DB" feature in cPanel....

Remote (MySQL)

Overview Remote MySQL allows external web servers to access your MySQL databases by adding their...

phpPgAdmin

Overview phpPgAdmin is a web based database administration tool specifically for managing MySQL...

phpMyAdmin

Overview phpMyAdmin is a web based database administration tool specifically for managing MySQL...

Delete PostgreSQL USER

Overview There are two types of deleting users. One way is to delete a user from a database. The...

Powered by WHMCompleteSolution