Creating a PostgreSQL User & Adding them to a database

In this tutorial we will show you how to create a PostgreSQL User, and then add them to a database. After getting PostgreSQL on your VPS or Dedicated server, you can create PostgreSQL users, and databases in cPanel.

You must create a PostgreSQL database before attempting this guide.

How to Create A PostgreSQL User

  1. Login to cPanel.
  2. Click the phpPgAdmin button in the Databases section.
    postgresql create db postgresql databases

    Note: The phpPgAdmin button, is only available after installing PostgreSQL on your VPS, or Dedicated server.
  3. In the Add New User section, enter a username, then your password in the available fields. Be sure to use a strong password.
  4. Click the Create User button.
    postgresql db user create user

    You are finished when you see a message similar to this, but your actual PostgreSQL username and password will be listed: “Added user “exampl8_username” with password “E1+q0I;1r7XT”.

How to Add a User to a Database

  1. Login to cPanel.
  2. Click the phpPgAdmin button in the Databases section.
    postgresql create db postgresql databases

  3. In the Add User To Database section, select the User you want to add from the drop-down menu.
    postgresql db user postgres config install

  4. Choose the database you want to add the user to, from the Database section.
    postgresql db user choose database

  5. Click the Submit button. You are finished when you see a message similar to this, with your own username and password: “User exampl8_user was added to the database exampl8_test.

Congratulations, now you know how to create a PostgreSQL user, and add them to a PostgreSQL database. Learn more about PostgreSQL Hosting options.

JB
John-Paul Briones Content Writer II

John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

More Articles by John-Paul

Was this article helpful? Let us know!