PostgreSQL is another Relational Database Management System (RDBMS) that is supported on our servers. The database stores information and the data is structured in tables – rows and columns. A great deal of web applications that you can use on your website, such as shopping carts, forums, blogs or content management systems (CMS), require the use of a database. Most open source applications use MySQL databases since they are easier to use and generally work faster. PostgreSQL, on the other hand, is more complex, which allows the developer more flexibility and provides more features. For more information on comparing MySQL and PostgreSQL databases, please refer to this article: What is the difference between MySQL and PosgreSQL?
Important notice: Not all hosting plans include support for PostgreSQL databases. If you can’t see the PostgreSQL Databases section under the Site Management menu on your hosting control panel, your plan does not support PostgreSQL.
You can create a PostgreSQL database using the My Databases -> PgSQL Databases menu of the Web Hosting Control Panel. Once you open that menu you’ll see the form for creating new PostgreSQL databases. You have to specify the name of the database. It always starts with the username of your hosting account (username_) and then you can choose the unique part that will distinguish the particular database. Then you have to specify and confirm the password for that database and click on the button below to create the database.
Below the form for creating new databases there is a table with all the existing PostgreSQL databases in your account. For each database you have the option to change the password, delete the database or log in via the phpPgAdmin tool. For more information on how to log in, please refer to the respective article in this knowledge base.
- A database created on our servers will have only one user that is created by default (new users cannot be created) and the default user of the database has all the privileges.
- The database name and the database username in our system coincide.
- It is advisable to create separate databases for every application that you use for easier management.