Initialization & Startup

Initialize the Database

The initialization process creates the database cluster, including the data directory and its subdirectories and files, generates system catalogs, and creates the template1 and halo0root databases. When a new database is created, all contents from the template1 database will be copied. The halo0root database is the default database for users, instance programs, and third-party applications.

Initialization must be run as the halo user. Do not perform the initialization as the root user.

Execute the following as the halo user:

pg_ctl init -D /data/halo

Or:

initdb -D /data/halo

Start the Database

Execute the following as the halo user:

pg_ctl start

Verify Installation

pg_ctl -V

Or

psql -c "select version()"

If the version number is output correctly, the installation is successful.