Initializing PostgreSQL Database

This section describes how to configure PostgreSQL database.

1. Start postmaster.

> postmaster -D ../data/ -i -h host.mycompany.com

2. Create an empty database:

> createdb -E UNICODE -U postgres trackstudio

3. Configure the database connection properties:

TrackStudio SA: Go to the Database Connectivity tab, enter the JDBC connection properties.
TrackStudio WAR: Edit the trackstudio.hibernate.properties:

hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect
hibernate.connection.url jdbc:postgresql://127.0.0.1:5432/trackstudio
hibernate.connection.driver_class org.postgresql.Driver
hibernate.connection.username postgres
hibernate.connection.password postgres

4. Initialize the database:

TrackStudio SA: Go to the Database Management tab and click the Create Database button.
TrackStudio WAR: Execute sql\en\trackstudio-pgsql.sql:

> psql --user=postgres -d trackstudio -f trackstudio-pgsql.sql

Notes

To backup database execute:

> pg_dump -U postgres -Fc -Z9 trackstudio > trackstudio.dmp

To restore database execute:

> createdb -E UNICODE -U postgres trackstudio
> pg_restore -U postgres --disable-triggers -S postgres -d trackstudio trackstudio.dmp

Topic path: Installation Guide > Creating and Configuring Database > Initializing PostgreSQL Database

Contents | Index