TrackStudio Enterprise 3.5
Initializing a PostgreSQL Database

The following topic describes how to configure TrackStudio for use with a PostgreSQL database management system.

  1. Start postmaster.
> postmaster -D ../data/ -i -h
  1. Create an empty database:
> createdb -E UNICODE -U postgres trackstudio
  1. Configure the database connection properties:
    • TrackStudio SA: Go to the Database -> Database Connectivity tab, enter the JDBC connection properties.
    • TrackStudio WAR: Edit the
hibernate.dialect org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.url jdbc:postgresql://
hibernate.connection.driver_class org.postgresql.Driver
hibernate.connection.username postgres
hibernate.connection.password postgres
  1. Initialize the database:
    • TrackStudio SA: Go to the Database -> Database Management tab and click the Create Database button.
    • TrackStudio WAR: Execute sql\install\trackstudio-pgsql.sql:
> psql --user=postgres -d trackstudio -f trackstudio-pgsql.sql
  • To backup the database execute:
> pg_dump -U postgres -Fc -Z9 trackstudio > trackstudio.dmp
  • To restore the database execute:
> createdb -E UNICODE -U postgres trackstudio
> pg_restore -U postgres --disable-triggers -S postgres -d trackstudio trackstudio.dmp