Hi,

I am preparing to migrate from control-m 6.4 to 7.0. I have the new server configured (Red Hat Linux) and have installed the software. This is the first time I will be using the postgreSQL databases. What is the best practice for backing up these databases? Should I set up scripts and do this outside control-m? Should archive mode also be set outside control-m? Thanks in advance for any advice.

It is best to use the Control-M/Server backup utility ctmdbbck to backup the postgresql databases. There are two modes of backup. A hot backup provides restore to the point of failure (not to the time of backup - basically a restore will restore the point of time of the last hot backup then apply archive logs to get to the point of failure). A cold backup provides restore to a point in time, however you cannot do a cold backup of the PostgreSQL database unless the database is down and you don't want to have to do this on your Production Control-M/Server regularly.
Look up the Utility guide for more information on ctmdbbck.

To run hot backups, you need to set the archive mode. Look up the Control- Administrator guide for more information on archive mode.

I would run a hot backup daily (there is no point in running it any more regularly other than to make restores super-quick) and would also ftp the backup files to a separate location after each backup.

Hi,

i am planning to do a hotbackup for my control-M servre db(PostgreSQL)
But unable to find where to change "Changes the archive mode of the PostgreSQL database server" to ON.

Can you please help me out here.

Thanks .

Hi

Here is an example

DBUArchive -ARCHIVE_MODE ON -ARCHIVE_DIRECTORY ${FILTEMPCTM}/Backups/Archives -SILENT Y

Thanks for your comment.

It worked out and working fine.