PostgreSQL
Manage PostgreSQL database and users
- Add PostgreSQL Database
- Add PostgreSQL User
- Add User to Database
- PostgreSQL Databases
- PostgreSQL Users
- phpPgAdmin
Add PostgreSQL Database
Create PostgreSQL Database
This page will help you to create a PostgreSQL database under your eenos account.
Go to: PostgreSQL -> Add PostgreSQL Database
To create a PgSQL database you need to fill out the following,
Database Name, a name for the database.
The database name starts with the prefix eenosuser_. You only need to enter the remaining name.
Select Database Server, select a PgSQL host server to create the database.
Now click the Create Database button to start creating the database
Add PostgreSQL User
Create PostgreSQL Database User
This page is for creating a PgSQL database user to connect to your Postgresql server.
Location:
PostgreSQL -> Add PostgreSQL User
Both the database and the user need to be on the same server to make the connection.
You may need to enter all the details to create the user as follows.
Enter Database User Name, a user name to connect.
Select Database Server, select the PgSQL server to create a user.
User Password, enter a strong password for the PgSQL user.
Add User to Database
Assign a PostgreSQL database user to a database
From this page, you can assign privileges for a PgSQL database user to a particular database.
Location :
PostgreSQL -> Add User to Database
You can select the following to assign the user,
Select Database, a database to add
Select Database User, a PgsQL user to assign to the database
Both Database and User need to be in the same PgSQL server to assign.
PostgreSQL Databases
Manage Your PostgreSQL Databases
This page will help you manage your PgSQL databases from the eenos control panel.
Location :
PostgreSQL -> PostgreSQL Databases
From this page, you can delete a database or assign a user to a database.
Revoke PgSQL User
To remove a user from a database, select the pgsql user and click the user remove icon from this page.
Delete PgSQL Database
To delete your database, click the Delete Database button.
PostgreSQL Users
PostgreSQL User Management
You can manage your Pgsql users from this page. These operations include changing the access host, changing the password, and deleting the user.
Location:
PostgreSQL -> PostgreSQL Users
Change PgSQL User Password
To change the PgSQL user password, click the button Change Password for the respective PgSQL user.
Delete PgSQL User
You can delete a PgSQL user, by clicking the button Delete User.
You can remove a user, only if it is revoked from all databases.
phpPgAdmin
Accessing phpPgAdmin from the eenos control panel.
You can access the PHPMyAdmin interface on your eenos server from the following links,
- Click the phpPgAdmin link on your eenos control panel from PostgreSQL -> phpPgAdmin, or
- Go to https://your-website-name/eenos-phppgadmin/
Eenos provides phppgadmin interface with a basic set of configurations so that you can manage your database from your browser.
You may now need to log in with the database user name and password.