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

Comments

Be the First to Comment!

Notify of
avatar
wpDiscuz
All rights reserved © 2005-2017 , www.superhosting.bg