To access PostgreSQL databases, you must first create at least one user. The following procedures describe how to manage PostgreSQL database users using cPanel.
To create a PostgreSQL user, follow these steps:
You can change a database user’s password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.
To change a PostgreSQL user’s password, follow these steps:
To rename a PostgreSQL user, follow these steps:
To delete a PostgreSQL user account, follow these steps:
After you create a database user, you are ready to create a database and associate the user with the new database.
To create a PostgreSQL database, follow these steps:
To add a PostgreSQL user to a database, follow these steps:
When you remove a user from a database, the user is no longer able to access the database.
To remove a PostgreSQL user from a database, follow these steps:
Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.
To delete a PostgreSQL database, follow these steps:
For more information about PostgreSQL, please visit http://www.postgresql.org.
Office 154 182-184 High Street North, East Ham
+44 7537 107 846
Switch The Language