You need to create a PostgreSQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the specific database first. Refer to Grant a user's permissions to a PostgreSQL database for more information.
1 To access
the Postgres Account Maintenance Menu, click
on the
icon
above the words PostgreSQL Databases
on the main screen of your cPanel interface.
2 Enter the name of the new user in the blank field next to UserName:
3 Enter the password for the new user in the blank field next to Password:
4 Click on Add User to create the new user.
Creating a user does not automatically allow the user to use a database - you need to grant that user permission to the specific database first. Refer to Grant a user's permissions to a PostgreSQL database for more information.