Add User to PostgreSQL Database

PostgreSQL is a commonly used open source SQL database management system. While less popular than MySQL, PostreSQL is known for its more advanced features.

In order to connect a database to your website or application, a user will need to be created and added to the database. Here we cover the steps to add a user to an existing PostgreSQL database in cPanel.

Related Articles

Create PostgreSQL User in cPanel
Add User to MySQL Database
Getting Started with cPanel

Add User

1. Log into cPanel
2. Navigate to PostgreSQL Databases, located under the Databases section
   
3. Scroll to the PostgreSQL Users section
   1. If you've already created a user, skip to step 4
   2. If you need to create a new user, fill in the Username and Password fields and select Create User
4. Scroll to the Add User To Database section
   1. Select the User and Database from the applicable drop-down menus and click the Submit button
      
5. Click Go Back on the confirmation page
   
6. Scroll down to the Current Users section and click the Synchronize Grants button
   
   IMPORTANT: This step is necessary to ensure tables are properly assigned to the user.