Database Setup

Login to an existing database as a database superuser or a user who has CREATEROLE and CREATEDB privileges, then execute the following command:
‎psql.exe -h <HOST-NAME> -W -U <USER_NAME> -p <PORT> -d <DATABASE_NAME>
‎ 
‎   -- Delete previous user if needed
‎   -- DROP USER "MM";
‎ 
‎   -- If the user cannot be dropped due to any ownership issues, you'll need to reassign those objects to another user
‎   -- REASSIGN OWNED BY "MM" TO <OTHER-USER-NAME>;
‎   -- Or drop those objects
‎   -- DROP OWNED BY "MM"
‎ 
‎   -- Create a user MM with LOGIN privilege
‎   CREATE USER "MM" LOGIN PASSWORD 'MM123!';
‎ 
‎   -- Create a database MM with UTF8 encoding.
‎   CREATE DATABASE "MM" WITH OWNER "MM" ENCODING 'UTF8';

Note: For maintenance reasons, PostgreSQL database indexes can be rebuilt as follows:

• Stop the MM Tomcat server
• run the following command under the MS-DOS command prompt assuming postgresql/bin is in the system path. This may take some time if your database is large.
  ‎reindexdb --username=MM --dbname=MM -v
• Restart the MM Tomcat server

For more information on reindexdb, refer to the PostgreSQL documentation.