• Introduction
• News
• Project Status
• Roadmap
• Sourceforge Project Home
• History

  ---

• Features
• Screenshots
• Download
• Server Installation
• Ultra Quick Server Installation
• Client Installation
• FAQ

  ---

• Architecture
• Development
• Integration Tests Results
• GUI Tests Results
• Tests Coverage
• Coding Style Checks

  ---

• HiveBoard Team
• Acknowledgements
• License

2. Setup the HiveBoard database on PostgreSQL

At this step, we suppose that the PostgreSQL server is up and running, and that your path includes the PostgreSQL tools directory.

You will first create the new HiveBoard database on your PostgreSQL server:

cd hb-server-bin/initdb/postgresql
psql -U postgres -W -d template1 <createdb-prod.sql
psql -U postgres -W -d hiveboard <schema.sql
psql -U postgres -W -d hiveboard <initdata-prod.sql

psql will ask you the password of "postgres" before executing the command.

The file schema.sql creates the structure of the hiveboard database (tables, indexes). The file initdata-prod.sql creates one specific account (login='admin', empty password) who has HiveBoard administrator rights and can thus create other accounts (through the HiveBoard client application).

The second command will emit some error messages which are normal (they are due to DROP statements that find no existing tables).

Before proceeding with the next step, let's check that the HiveBoard database has been correctly initialized:

psql -U postgres -W -d hiveboard
hiveboard=# select * from ACCOUNT;
hiveboard=# \q

psql should display 'admin' in the list of accounts.