This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here

Skip to main content
Search

Just Host Web Hosting Help

PostgreSQL

Summary

This article will explain how to manage the PostgreSQL Databases on your account.

Managing PostgreSQL Databases

To create a database from the PostgreSQL Databases Icon.
  • Log in to your Just Host cPanel account.
  • Under theDatabase Tools section, click the PostgresSQL Databases icon.
  • In the New Database field, type a name for the database.
  • Click Create Database.
  • Click Go 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 122,266 views bookmark
    share
    Share or save this via:
    tags: posgresql


    Was this resource helpful?
    Helpful Unhelpful


    Did this resolve your issue?
    Solved Unsolved


    Please add any other comments or suggestions about this content:





    Recommended Help Content

    9 Tips for Working in WordPress
    Versatile and robust, WordPress is a favorite among applications and content management systems. This article provides nine tips for working in WordPress.
    Knowledgebase Article 82,510 views tags: guide tips tricks wordpress wp

    Pushing Website from old host to Justhost.com
    How to Transfer hosted files from old host to Justhost.com via ssh. Your old host must have SSH access to perform this move. Using SSH to transfer files to Just Host
    Knowledgebase Article 242,690 views tags: file host site transfer transferring

    Local MySQL Connection Blocked To Server
    I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.Justhost.com' is blocked because of many connection errors; unblock with 'mysqlad
    Knowledgebase Article 265,133 views tags: blocked connection host localhost mysql

    Related Help Content

    PostgreSQL Version
    What version of PostgreSQL are you running?
    Knowledgebase Article 131,465 views tags:

    Hosting Subdomains
    How can I host only a subdomain on my hosting service provided by Just Host?
    Knowledgebase Article 425,832 views tags: domain host subdomain

    What Is an A Record? How To Edit an A Record
    Definition of an A Record
    Knowledgebase Article 851,117 views tags: a dns file host ip record zone

    Importing AWStats from a Previous Host
    How can I import awstats from my previous host?
    Knowledgebase Article 227,891 views tags: awstats import importing

    9 Things to Keep in Mind When Choosing a WordPress Theme
    Whether you’re starting from scratch or updating an existing website, choosing the right theme will make it easier to create a professional-looking site and achieve your online goals.
    Knowledgebase Article 124,731 views tags: Marketplace certified premium themes tips wordpress

    htaccess Tutorial
    What is the .htaccess file and where can I find more information?
    Knowledgebase Article 2,082,205 views tags: htaccess tips tricks

    Right-Click Image Protection
    How can I protect the images on my website?
    Knowledgebase Article 291,225 views tags: click code image images javascript protect save saving script tips tricks

    Advanced Tips for Choosing a Domain Name
    This article offers suggestions for selecting a domain name that is effective and memorable.
    Knowledgebase Article 205,510 views tags: domain

    *Promotional pricing is for the first term only and regular rates apply upon renewal. 30-Day Money-Back Guarantee does not extend to domain names.

    ** Google ad credits are only available to customers in the United States, Canada, and the United Kingdom at this time.

    ¹ VAT (Value Added Tax) is not included in our advertised price and will be charged separately and itemized on invoices and billing information. Standard VAT rates based on EU Member State regulations may apply. Learn more.