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
- Log into cPanel
- Navigate to PostgreSQL Databases, located under the Databases section
- Scroll to the PostgreSQL Users section
- If you've already created a user, skip to step 4
- If you need to create a new user, fill in the Username and Password fields and select Create User
- Scroll to the Add User To Database section
- Select the User and Database from the applicable drop-down menus and click the Submit button
- Select the User and Database from the applicable drop-down menus and click the Submit button
- Click Go Back on the confirmation page
- 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.