SQL Scripts for PostgreSQL Databases

Atlas Hub comes with some SQL scripts written specifically for use with your database. These scripts help you maintain and tune Atlas Hub 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 Atlas Hub.

The SQL scripts for PostgreSQL databases that you may run are located in the Micro Focus\Hub\DBScripts\postgresql_Scripts folder.


Run: only if necessary.

Running this script deletes all Atlas Hub tables and the data they contain from the database. Use this script with extreme caution.

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