USER GUIDE
PostgreSQL Support
PostgreSQL is a database management system which can be run only on Unix platform boxes.
A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as PostgreSQL. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.
PostgreSQL is a relational database management system.
A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of PostgreSQL stands for "Structured Query Language" - the most common standardized language used to access databases.
PostgreSQL is Open Source Software.
Open source means that it is possible for anyone to use and modify it. Anybody can download PostgreSQL from the Internet and use it without paying anything. All who are so inclined can study the source code and change it to fit their needs. PostgreSQL uses the GPL (GNU General Public License). You may address http://www.gnu.org to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to insert PostgreSQL into a commercial application, you can buy a commercially licensed version from us.
Managing PostgreSQL Database and Its Users
To use PostgreSQL databases within Control Panel, you must be subscribed to a plan supporting PostgreSQL. Please consult our IT consultants in selecting the plan that will best correspond your needs.
As opposed to other 'SQL' databases supported by Control Panel, PostgreSQL users are 'principal' relatively to PostgreSQL databases, which means a database cannot be created without a user. In other words, each database should be bound to a previously created owner. This means that you must first create a user and then create a database. There is only one owner for each database, however the database can be used by others who obtain permissions from the owner.
Click the PosgreSQL database menu:
If you do not have any PostgreSQL users, you will be taken to the PostgreSQL Users page by default. Otherwise, the first page to appear is PostgreSQL Database listing your Control Panel system PostgreSQL databases.
Creating PostrgeSQL User(s)
Go to the PostgreSQL Users page and fill in the Add PostgreSQL user form:
As you enter the user name and the access password which he will use in future to get at database(s) , you will be taken to the form similar to the one below:
where:
Host Name: the name of the server hosting your Control Panel system PostgreSQL database(s).
Port Number: the number of the port users get to their database(s).
Here you can:
Creating PostgreSQL Database
Now that you have at least one user, you can turn to PostgreSQL database creation.
Remember:
Click the Add icon to enter the parameters of the database:
When you've created a database and assigned its owner you can change the database settings. Click the database link in the Database name field or the Edit icon in the Controls field. You will be taken to the form similar to the one below:
where:
- General Issues : explains what is PostgreSQL and what it is used for.
-
Working with PostgreSQL in Control Panel :
explains the basic approaches of managing PostgreSQL data bases
PostgreSQL is a database management system which can be run only on Unix platform boxes.
A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as PostgreSQL. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.
PostgreSQL is a relational database management system.
A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of PostgreSQL stands for "Structured Query Language" - the most common standardized language used to access databases.
PostgreSQL is Open Source Software.
Open source means that it is possible for anyone to use and modify it. Anybody can download PostgreSQL from the Internet and use it without paying anything. All who are so inclined can study the source code and change it to fit their needs. PostgreSQL uses the GPL (GNU General Public License). You may address http://www.gnu.org to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to insert PostgreSQL into a commercial application, you can buy a commercially licensed version from us.
Managing PostgreSQL Database and Its Users
To use PostgreSQL databases within Control Panel, you must be subscribed to a plan supporting PostgreSQL. Please consult our IT consultants in selecting the plan that will best correspond your needs.
As opposed to other 'SQL' databases supported by Control Panel, PostgreSQL users are 'principal' relatively to PostgreSQL databases, which means a database cannot be created without a user. In other words, each database should be bound to a previously created owner. This means that you must first create a user and then create a database. There is only one owner for each database, however the database can be used by others who obtain permissions from the owner.
Click the PosgreSQL database menu:
If you do not have any PostgreSQL users, you will be taken to the PostgreSQL Users page by default. Otherwise, the first page to appear is PostgreSQL Database listing your Control Panel system PostgreSQL databases.
Creating PostrgeSQL User(s)
Go to the PostgreSQL Users page and fill in the Add PostgreSQL user form:
As you enter the user name and the access password which he will use in future to get at database(s) , you will be taken to the form similar to the one below:
where:
Host Name: the name of the server hosting your Control Panel system PostgreSQL database(s).
Port Number: the number of the port users get to their database(s).
Here you can:
- add other users (click the Add icon);
-
delete the existent user (click the
Trash Can
icon).
N.B. : the Trash Can icon appears only next to 'non-owner' users, i.e. if the user is an owner of a PostgreSQL database, you won't be able to remove him. In this case you'll have to remove the PostgreSQL database he is an owner of first.
E.g. In the above shown example pg_user1 is an owner of the PostgreSQL database, thereby no Trash icon is displayed and you can't remove him on the contrary to pg_user2.
- change users password - click the Change icon.
Creating PostgreSQL Database
Now that you have at least one user, you can turn to PostgreSQL database creation.
Remember:
- you can create no PostgreSQL database without 'pre-created' users;
- each database must have an owner.
Click the Add icon to enter the parameters of the database:
When you've created a database and assigned its owner you can change the database settings. Click the database link in the Database name field or the Edit icon in the Controls field. You will be taken to the form similar to the one below:
where:
- Host Name: the name of the server hosting your Control Panel system PostgreSQL database(s).
- Port Number: the number of the port through which users get to their database(s).
- Database Name: click the Trash Can icon to delete the database.
- phpPgAdmin: an http client that enables users to configure and operate PostgreSQL database(s).
-
Database Description:
a comment that will help you identify the this database among others.
- Quota: shows how much of disk space is being used of a database disc quota which you can change by clicking the Change icon.
