Article ID: 3133, created on Nov 30, 2007, last review on Apr 18, 2012
If you are using Windows, you can use corresponding ODBC drivers. The password and other required parameters can be found in the file ~cpanel/shiva/psoft_config/hsphere.properties. To query the database from Unix, login as root, and run the following command from the command line:
psql -U wwwuser hsphere.
If you get an error, add psql path to this command:
/usr/local/pgsql/bin/psql -U wwwuser hsphere.
Then run your query. Note that all queries must end in semicolons.