Move datamart to a separate instance

Datamart can be run in same instance or in a separate instance.

1. Do a dump of the PostgreSQL datamart.
   • su - postgres -c 'pg_dumpall -p <datamart-port> <dump-location>/<datamart-name>.sql
2. Stop the services.
   • /etc/init.d/collabnet stop all
3. Configure datamart.
   Note: Configuration differs based on the mode of installation. Boostrapping is not required.
4. Restore the reporting database.
   • su - postgres -c dropdb <datamart-name> -p <datamart-port>
   • su - postgres -c 'createdb -E UTF8 -O <datamart-user> <datamart-name> -p <datamart-port>
   • su - postgres -c psql -p <datamart-port> <dump-location>/<datamart-name>.sql'
5. Start the services.
6. Check if the existing data is appearing in charts.