Delete Existing Database

If the existing databases do not need to be retained for the upgraded installation, then they can be deleted. Prior to deleting the databases, shutdown the Tomcat server. The following is a set of instructions for deleting the databases that are dependent on the database server used in the current environment. Once the databases have been deleted, see the Deploying the Databases section for instructions on how to create the new databases.

Derby

For a Derby database instance, execute the following to delete the database (the path was specified in the Configuration section): 

% cd /path/to/registrydb/home
% rm -rf registrypds3 registrypds4 derby.log

MySQL

For a MySQL database instance, execute the following to delete the database from the database server: 

% mysqladmin -u root -p drop registrypds3
% mysqladmin -u root -p drop registrypds4

PostgreSQL

For a PostgreSQL database instance, execute the following to delete the database from the database server: 

% psql -U postgres
postgres=# drop database registrypds3
postgres=# drop database registrypds4
postgres=# \q