Backing up the Control-M/Server database (PostgreSQL)

This procedure describes how to back up the Control-M/Server database when using PostgreSQL.

To back up the Control-M/Server database (PostgreSQL):

1. Shut-down Control-M/Server and Control-M/Server Configuration Agent before running this utility.
2. Do one of the following:
   1. Log on to a Control-M for Databases account (UNIX)
   2. Open a command prompt window (Windows) where Control-M/EM is installed.
   3. For Windows client installations, open a command prompt window and navigate to the <EM Home>\Default\bin directory.
3. Enter the following command:

   ctmdbbck

   For Sybase or MSSQL – You are prompted for the backup device (<backupDevice>).

4. Continue the backup by following the prompts.

   Prompts and messages similar to the following are displayed:

   Please Enter Postgres Administrator Password:*******

   Detecting current archive mode ...

   Archive Mode=off

   Done.

   Enter full path destination file name:c:\bckup

   Performing Cold backup into c:\bckup ...

   backup succeeded. It is recommended to check backup file by restoring it to test

   environment.

   You can start Control-M/Server.

   The back up is complete.