Search Engine: Elastic

Article ID: 3241, created on Nov 30, 2007, last review on May 3, 2014

  • Applies to:
  • H-Sphere


The H-Sphere System Database

The H-Sphere system database is used to store system data. In normal H-Sphere configuration, it runs on PostgreSQL server, but it may be installed on a separate Windows-based MSSQL server. Henceforth we will talk about the system database on PostgreSQL, unless noted otherwise.

Usually, the system database is located on the same server with the Control Panel.

The system database is not used for hosting. PostgreSQL hosting server could not be installed on the same box with the system database.

The H-Sphere database is executed under the pgsql or postgres user.

The System Database Settings

Database settings in (this should be enough to connect to db):

DB_DRIVER = org.postgresql.Driver
DB_URL = jdbc:postgresql:// - the system database name, usually hsphere
DB_USER = wwwuser - the system db user name, usually wwwuser
DB_PASSWORD = your_db_password - the system db user password
DB_NEWID = SELECT nextval(''{0}'')

Logging Into The System Database

To log into the system database:

  1. Login as the cpanel user to the server where the system database is located (usually, CP server).
  2. Enter the hsphere database (usually, under the wwwuser user name):
    # psql hsphere [user_name]

See also the instructions on:

VACUUM Utility

The Postgres VACUUM instruction allows cleaning up the server transactions. Enter the psql server:
# psql hsphere wwwuser and type in the password set in

In the psql command line, type the 'vacuum full' command:
vacuum full;
The command may vary in different versions of Postgres.

Note: vacuum is a time-consuming procedure; it may take up to several hours to complete!

f213b9fa8759d57bee5d547445806fe7 3ef1f5f998c0dc182718a7fe4376f875

Email subscription for changes to this article
Save as PDF