Creation and initialization of database in PostgreSQL

1. Run postmaster

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

2. Create the database:

> createdb -E UNICODE -U postgres trackstudio

3. Configure the properties of DBMS connection:
   • TrackStudio SA: On the tab Database , select PostgreSQL from DNMS
     list and edit the properties of JDBC connection
   • TrackStudio WAR: Edit the connection properties in the file trackstudio.hibernate.properties:

hibernate.dialect org.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:
     Press the button Create DB on the tab Database
   • TrackStudio WAR: Run the script sql\install\ru\trackstudio-pgsql.sql

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

Note

• For backing up the database:

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

• For restoring the database:

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