• bg
  • en

Hosting, Domains, Cloud, Virtual Private Servers (VPS), Managed VPS, SSL Certificates

PostgreSQL - Features and Support

postgre, postgres, postgresql, psql, postgre db, postgre data base, postgre database, postgresql db, postgresql data base, postgresql database, pgsql

PostgreSQL is an open-source object-relational database (ORDBMS). It is supported by all major operating systems such as Linux, Unix and Windows.

info-iconPostgreSQL is also supported by SuperHosting.BG. You can create a PostgreSQL database in your cPanel. If you want to use the database, but cannot find the PostgreSQL menu in cPanel, please contact our technical support team.

PostgreSQL is one of the most sophisticated database management systems along with MySQL and SQLite.

It is often preferred by developers because it offers reliability when handling data especially for projects where scalability and using additional capabilities are main priorities.

It also has a more complex, but sophisticated database processing method as it is competitive with the other database systems in terms of easy management and administration.

Compared to other database systems, PostgreSQL offers a fuller implementation of SQL specification (SQL:2011). It also supports the following features:

  • Transaction model that has full ACID compliance as well as MVCC (multiversion concurrency control) in simultaneous data reading and writing;
  • PostgreSQL can be extended by the user (by adding new data types, functions, operators, index methods, procedural languages, and more);
  • It offers different index methods (not all of that are available in many other databases);
  • It uses only one storage engine (PostgreSQL);
  • It also offers complex queries
  • and much more ...

Managing PostgreSQL Databases

You can create a PostgreSQL database and add users in cPanel -> PostgreSQL databases.


In cPanel you can also find the phpPgAdmin web tool for database administration. However, it won't be possible to perform all kinds of actions through it because this system tool uses the cPanel user.

info-iconFor administering PostgreSQL database on your hosting account we recommend using an additionally installed phpPgAdmin.

pgAdmin III

For remote access to the PostgreSQL database you may run the pgAdmin III application.

This tool can be downloaded and installed locally on your PC. For connecting to the PostgreSQL server you will first need to enable the option for remote access to databases and then install OpenVPN.

  • Redis Features and Support
    Redis (REmote DIctionary Server) is an open-code project similar to Memcached that enables you to store data. The tool is used to speed up website loading by caching data and... »
  • I/O (Input/Output Operations)
    In computing, communication between two processing systems is based on Input-Output operations. For example, input operations are the signals/data sent from a CPU or another type of controller towards a... »
  • What is XML-RPC?
    XML-RPC is a remote procedure call protocol. It allows software running on disparate operating systems from different environments to make procedure calls over the Internet (by using HTTP). Information on data... »
  • PEAR Packages
    PEAR (PHP Extension and Application Repository) is a framework and distribution system for reusable PHP components. PEAR packages are bundles of files written in PHP that can be embedded into PHP applications. PEAR packages... »
  • HTTP status codes - 301 (Moved Permanently) & 302 (Found)
    301 Moved Permanently and 302 Found are HTTP status codes sent in response to web clients and search engine bots when trying to access a redirected URL. The HTTP status code... »
All rights reserved © 2005-2017 ,