Setup PostgreSQL on Linux

Install PostgreSQL

To install PostgreSQL use your Linux's package system or install it manually by downloading it from http://www.postgresql.org/download/ and following their instructions.

Create database

With PostgreSQL installed and started, create a database named eHour by executing:

createdb ehour

Install eHour database

With the ehour database created, the next step is to create and initialize the datamodel.

In eHour's sql/postgresql/install directory there's a fresh.postgresql.sql script which contains the datamodel and default data.

Execute it by running the following command:

psql -U ehour -h localhost ehour < fresh.postgresql.sql