SQL Scripts for PostgreSQL Databases

StarTeam Server comes with some SQL scripts written specifically for use with your database. These scripts help you maintain and tune StarTeam Server databases. You run some SQL scripts after installation, some on a weekly basis for database performance maintenance, and some scripts are run for you automatically by StarTeam Server.

The SQL scripts for PostgreSQL databases that you may run are located in the Micro Focus\StarTeam Server <version>\DBScripts\postgresql_Scripts folder.

starteam_postgresql_dropall.sql

Run: only if necessary.

CAUTION:
Running this script deletes all StarTeam Server tables and the data they contain from the database. Use this script with extreme caution.

One use case example is if you migrate a StarTeam Server configuration to another database, you might use this script to remove tables from the original database. Another example is if you mistakenly add the StarTeam Server tables to a tablespace other than the StarTeam Server tablespace, use this script to remove them.