PostgreSQL Server

This chapter describes some task you may need to perform on your Parallels H-Sphere PostgreSQL server.

PostgreSQL log file is /var/log/pgsql.

PostgreSQL server comes with PhpPgAdmin (http://phppgadmin.sourceforge.net/) which is a PostgreSQL administration Web interface written in PHP. It is installed with PostgreSQL server as a hsphere-phppgadmin-<version>-<build> package, where <version> is PhpPgAdmin version, and <build> is this package's build number.

IPhpPgAdmin installation directory is /hsphere/shared/apache/htdocs/phpPgAdmin.

In this chapter:

Installing PostgreSQL Server

Backing Up PostgreSQL Database

Using VACUUM Utility

Running PostgreSQL Scripts

Changing Postgres User Password

Localizing PostgreSQL

Configuring Parallels H-Sphere to Use Non-Default MySQL/PostgreSQL Versions

Choosing Remote Web Logical Servers for phpMyAdmin/phpPgAdmin Frontends

Downgrading Postgres