{"id":7333,"date":"2016-11-16T11:04:14","date_gmt":"2016-11-16T09:04:14","guid":{"rendered":"https:\/\/help.superhosting.bg\/en\/?p=7333"},"modified":"2022-03-18T13:44:44","modified_gmt":"2022-03-18T10:44:44","slug":"creating-a-postgresql-database-in-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/help.superhosting.bg\/en\/creating-a-postgresql-database-in-cpanel.html","title":{"rendered":"Creating a PostgreSQL Database in cPanel"},"content":{"rendered":"

You can create a PostgreSQL database in cPanel<\/strong> ->\u00a0PostgreSQL Databases<\/strong>.<\/p>\n

PostgreSQL is supported by\u00a0SuperHosting.BG<\/a>. You can set up a PostgreSQL database in cPanel. If you want to use this database, but cannot find the PostgreSQL Databases<\/strong> menu in your cPanel<\/strong>, please contact our technical support team.<\/div>\n

<\/span>Creating New Database<\/strong><\/span><\/h3>\n

\"CreatingEnter a database name in the New Database text box and then click Create Database<\/strong>.<\/p>\n

You can rename or remove a PostgreSQL database from the Current Databases<\/strong> section.<\/p>\n

Each new PostgreSQL database contains a schema named “public<\/strong>“.<\/p>\n

<\/span>Creating New Users<\/strong><\/span><\/h3>\n
\n

\"Creating<\/p>\n

In order to be able to manage the PostgreSQL database you first need to create a user.<\/p>\n

Enter a username<\/strong> (1<\/strong>). The username should not match any existing database name.<\/p>\n

Enter and confirm the password<\/strong> (2<\/strong>).<\/p>\n

We recommend that you use\u00a0the Password Generator<\/strong> (3<\/strong>)\u00a0to create a strong combination of uppercase and lowercase letters and numbers.<\/p>\n

Finish the setup by clicking Create User<\/strong>.<\/p>\n

Type in all the letters a username consists of when you enter it, e.g. cpuser_dbuser<\/strong>.<\/p>\n<\/div>\n

<\/span>Adding User to the Database<\/strong><\/span><\/h3>\n
\n

\"AddingTo assign a user with a database, specify a user you would like to give permissions to from the “User<\/strong>” drop-down menu.<\/p>\n

Then select a database<\/strong> from the “Database<\/strong>” drop-down menu.<\/p>\n

The specified user is given all permissions by default so that he can manage the whole database content.<\/p>\n

Finish the setup by clicking on “Submit<\/strong>“.<\/p>\n<\/div>\n

<\/span>Connecting an Application to the Database<\/strong><\/span><\/h3>\n

If you want to enable an exchange between an application and the database, you need to enter the following information:<\/p>\n

“host=localhost;port=5432;dbname=cpuser_mypgdb;user=cpuser_mypgusr;password=password”<\/p>\n

Host<\/strong>: localhost<\/p>\n

Port<\/strong>: 5432<\/p>\n

Database<\/strong>: the database name with prefix<\/p>\n

Database user<\/strong>: the username with prefix<\/p>\n

Password<\/strong>: user password<\/p>\n","protected":false},"excerpt":{"rendered":"

You can set up a PostgreSQL database in cPanel – Create Database. Enter a database name in the New Database text box and then click Create Database.<\/p>\n","protected":false},"author":11,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"inline_featured_image":false,"_lmt_disableupdate":"","_lmt_disable":"no","footnotes":""},"ht-kb-category":[207],"ht-kb-tag":[],"class_list":["post-7333","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-postgresql-db"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t