HostMonster Web Hosting Help



Managing PostgreSQL Databases

To create a database from the PostgreSQL Databases Icon.
  • Log into the cPanel
  • Click the PostgresSQL Databases icon under the "Databases" category
  • In the New Database field, type a name for the database.
  • Click Create Database.
  • Click Back to Manage Databases.
  • Managing User

    After creating the database, a user will need to be created and their privileges added to the newly created database. Please note that PostgreSQL user accounts must be created separately from mail, MySQL, and web administrator accounts.

    Creating a PostgreSQL User

    • To quickly access the PostgreSQL Users, click Jump to PostgreSQL Users.
    • Under Add New User, enter a username.
    • Note: The username must be 7 letters or shorter.
    • Enter a password in the Password field.
    • Retype the password in the Password (Again) field.
    • Click Create User.

    Add a User to a Database

    Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.

    Managing Privileges

    • Under Add User to Database, select a user from the User drop-down menu.
    • From the Database drop-down menu, select the database to which you wish to allow the user access.
    • Click Add.
    • From the PostgreSQL Account Maintenance screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
    • Click Make Changes.

    Enabling PL/pgSQL

    PL/pgSQL can be enabled on your databases individually by our Level III technicians. Also, if you wish to have the function plpgsql_call_handler() created in your database, please make sure you mention it, since this is no longer done automatically.

    Using SSH

  • Login to your account using ssh.
  • Enter one of the following commands
  • How to import a postgres database via SSH

    pg_restore -d db_name file_name.sql

    How to export a postgres database via SSH

    pg_dump -cif file_name.sql db_name
    Knowledgebase Article 33,839 views bookmark tags: posgresql (updated 1157 days ago)

    Was this resource helpful?

    Did this resolve your issue?

    Please add any other comments or suggestions about this content:

    Recommended Help Content

    What version of PostgreSQL are you running? (updated 2154 days ago)
    Knowledgebase Article 52,569 views tags:

    How to prepare your WordPress site for a surge in traffic (updated 606 days ago)
    Knowledgebase Article 9,462 views tags: tips wordpress

    What is the .htaccess file and where can I find more information? (updated 903 days ago)
    Knowledgebase Article 1,490,560 views tags: htaccess tips tricks

    Related Help Content

    How can I protect the images on my website? (updated 1519 days ago)
    Knowledgebase Article 133,307 views tags: click code image images javascript protect save saving script tips tricks

    Five Top Tips for a Great Mobile Website - Video (updated 983 days ago)
    Knowledgebase Article 7,413 views tags: gomobi

    This article offers suggestions for selecting a domain name that is effective and memorable. (updated 189 days ago)
    Knowledgebase Article 25,022 views tags: domain

    Tips and tricks to make your wordpress blog load faster (updated 525 days ago)
    Knowledgebase Article 44,431 views tags: optimizing wordpress

    Information on why your website may be suspended with helpful tips on how to resolve the issue (updated 320 days ago)
    Knowledgebase Article 85,847 views tags: suspended

    Explanation of how spam works and common prevention tips (updated 73 days ago)
    Knowledgebase Article 95,343 views tags: email spam webmail

    How to prevent your server from freezing up or fix site performance problems on a VPS or Dedicated (updated 299 days ago)
    Knowledgebase Article 5,616 views tags: dedicated optimize vps whm

    What comes first - mobile web or mobile app? (updated 983 days ago)
    Knowledgebase Article 9,334 views tags: gomobi