PostgreSQL

Manage PostgreSQL database and users

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.

Now click the button Create PostgreSQL User to start adding the 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.

Now click the button  Assign User to add the user to the selected database.

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,

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.