Bluehost Web Hosting Help
This article will explain how to manage the PostgreSQL Databases on your account.
Managing PostgreSQL Databases
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./li>
Add a User to a DatabasePrivileges 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.
- 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.
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.
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
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.
Office 365: Tips and Tricks
How can I learn about the productivity tools included with my Office 365 plan?
What version of PostgreSQL are you running?
Related Help Content
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.
What is the .htaccess file and where can I find more information?
Right-Click Image Protection
How can I protect the images on my website?
Advanced Tips for Choosing a Domain Name
This article offers suggestions for selecting a domain name that is effective and memorable.
Tips and tricks to make your WordPress blog load faster
Why is my web site Suspended?
Information on why your website may be suspended with helpful tips on how to resolve the issue
Explanation of how spam works and common prevention tips
VPS or Dedicated - Site Performance Essentials + Tips
How to prevent your server from freezing up or fix site performance problems on a VPS or Dedicated