https://help.superhosting.bg/en/creating-a-postgresql-database-in-cpanel.html
  • bg
  • en

Hosting, Domains, Cloud, Virtual Private Servers (VPS), Managed VPS, SSL Certificates

Creating a PostgreSQL Database in cPanel

Control Panel cPanel
postgre, postgres, postgresql, psql, postgre db, postgre data base, postgre database, postgresql db, postgresql data base, postgresql database, pgsql

You can create a PostgreSQL database in cPanel -> PostgreSQL Databases.

info-iconPostgreSQL is supported by SuperHosting.BG. You can set up a PostgreSQL database in cPanel. If you want to use this database, but cannot find the PostgreSQL Databases menu in your cPanel, please contact our technical support team.

Creating New Database

Creating New DatabaseEnter a database name in the New Database text box and then click Create Database.

You can rename or remove a PostgreSQL database from the Current Databases section.

Each new PostgreSQL database contains a schema named "public".

Creating New Users

Creating New Users

In order to be able to manage the PostgreSQL database you first need to create a user.

Enter a username (1). The username should not match any existing database name.

Enter and confirm the password (2).

We recommend that you use the Password Generator (3) to create a strong combination of uppercase and lowercase letters and numbers.

Finish the setup by clicking Create User.

Type in all the letters a username consists of when you enter it, e.g. cpuser_dbuser.

Adding User to the Database

Adding User to the DatabaseTo assign a user with a database, specify a user you would like to give permissions to from the "User" drop-down menu.

Then select a database from the "Database" drop-down menu.

The specified user is given all permissions by default so that he can manage the whole database content.

Finish the setup by clicking on "Submit".

Connecting an Application to the Database

If you want to enable an exchange between an application and the database, you need to enter the following information:

"host=localhost;port=5432;dbname=cpuser_mypgdb;user=cpuser_mypgusr;password=password"

Host: localhost

Port: 5432

Database: the database name with prefix

Database user: the username with prefix

Password: user password

500px270px
SuperHosting.BG
    Control Panel cPanel
  • PHP Manager by SuperHosting
    In cPanel you can change the PHP settings for all hosting plans offered by SuperHosting.BG. You can change the PHP version, enable or disable PHP modules and change PHP directives. This... »
  • How to login to cPanel?
    You could find detailed description on how to login to cPanel in the email which you have received after your hosting account was created. One way is to write your... »
  • SuperTools Available in cPanel
    cPanel offers a few special Super tools developed by SuperHosting.BG that enable you to manage more easily and quickly the content of all websites, hosted on your account. SUPERHOSTING TOOLS In the... »
  • How to Change PHP Version for a Specific Directory?
    Under PHP Manager in cPanel you can change the PHP version for the entire hosting account or for a specific directory. Below you can read how to set a different PHP version for a specific directory... »
  • Redis Manager by SuperHosting
    Redis is supported for the SuperPro and SuperHosting plans. To use Redis, you need to activate it in cPanel. Login to cPanel and select the "Redis Manager by SuperHosting" menu. Choose the amount of... »
All rights reserved © 2005-2017 , www.superhosting.bg