🍁 Autumn Sale — Up to 70% discount for hosting and domains
activate now
Tutorials • Dev

Creating and adding a user to a PostgreSQL database.

In this article, you will learn how to create a PostgreSQL database and how to add a user to that database.

Views 1289Updated 2 aniPublished on 16/07/2021by Cătălin A.

Introduction

  • This article will show you how to create a database PostgreSQL and a user defined for the database respectively.

Requirements

  • An active hosting account with cPanel panel, along with login details (username and password).

Steps to follow

  • After logging into the cPanel control panel, in the DATABASES section, we will access the PostgreSQL Databases plugin

cpanel postgreSQL hostico

  • We complete the name that we want for the database.

 

cpanel postql database

  • You need to create a user that we to assign to the respective database

hostico database user

  • After which to allocate the user to the database we created. 

hostico user database

Similar Articles

Views 1,289
Updated 2 years ago

In this article, you will learn how to create a PostgreSQL database and how to add a user to that database.

Views 1,188
Updated 2 years ago

In this tutorial, we will show you how to create a new database with an allocated user using the PostgreSQL Database Wizard.

Views 1,102
Updated 2 years ago

Learn how to export a PostgreSQL database in cPanel, step by step, using phpPgAdmin for an easy download.