5.4. Setup your database

BELTS Version 1.2.0 supports PostgreSQL only. Please refer to the following instructions to prepare your system to run BELTS.

5.4.1. Postgres Installation

[Note]Note

BELTS is currently setup to work with PostgreSQL Version 7.4 since that is the most common version out there at the moment. If you are running a different version, you will need to download a JDBC2 jar file for your version from http://jdbc.postgresql.org/download.html and use it to replace BELTS_HOME/server/default/lib/postgresql.jar.

5.4.1.1. Linux Installation

Ensure postgres is installed in your Linux environment by using the appropriate tool for your distribution to install it. Once installed, there is often no need to change anything to get BELTS to work successfully.

Once postgres is installed, BELTS can be installed by extracting the downloaded file and performing the steps outlined in the Section 5.4.1.3, “BELTS Database Creation”.

5.4.1.2. Windows Installation

A Windows executable for postgres may be downloaded from http://www.postgresql.org/download/. Once downloaded, install the package as per the documentation.

Once postgres is installed, BELTS can be installed by extracting the downloaded file and performing the steps outlined in the Section 5.4.1.3, “BELTS Database Creation”.

5.4.1.3. BELTS Database Creation

Once postgres is installed, create the BELTS user, database and tables by performing the following steps:

  1. Use createuser to create a postgres user called “belts”. This user does not need to be able to create databases or users. The password for the belts user is currently set to “verysecret”. If desired, this can be changed by updating BELTS_HOME/server/default/deploy/belts-ds.xml.

    createuser --username=postgres --password

  2. Create the belts database

    createdb --username=belts --encoding=latin1 belts

    [Note]Note

    The latin1 encoding is not always supported by the postgres servers for Windows. This doesn't seem to be an issue in our testing.

  3. Create the belts database tables

    Linux:

    $ cd $BELTS_HOME/server/default/setup
    $ psql belts belts < tables.sql

    Windows:

    C:\> cd %BELTS_HOME%\server\default\setup
    C:\belts-1.2.0\server\default\setup> psql belts belts < tables.sql