Webuzo offers a user-friendly interface for managing PostgreSQL databases, allowing you to perform tasks such as creating databases, adding users, and assigning privileges. Here's how you can manage PostgreSQL databases through the Webuzo Enduser Panel:
1. Enabling PostgreSQL Service:
- Log in to your Webuzo Enduser Panel.
- Navigate to the Services section.
- Locate PostgreSQL and ensure it is enabled. If it's not, enable it and confirm that the service is running.
2. Accessing PostgreSQL Management:
- In the Webuzo Enduser Panel, go to the Database section.
- Click on Manage PostgreSQL.
3. Creating a New Database:
- Click on Add Database.
- Enter the desired name for your database.
- Click Create to establish the new database.
4. Creating a Database User:
- Within the Manage PostgreSQL section, select Add Database User.
- Provide a username and password for the new user.
- Click Create to add the user
5. Assigning a User to a Database:
- In the Manage PostgreSQL section, choose Add User to Database.
- Select the user and the database to which you want to assign the user.
- Specify the privileges (e.g., SELECT, INSERT, UPDATE) you wish to grant.
- Click Add to apply the changes.
6. Updating a Database User Password:
- In the Manage PostgreSQL section, select Update Database User Password.
- Choose the user whose password you want to update.
- Enter the new password and click Update.
7. Managing Existing Databases and Users:
- To view current databases and users, go to Current Databases and Current Database Users.
- Here, you can edit or delete databases and users as needed.
By following these steps, you can effectively manage your PostgreSQL databases within the Webuzo environment.