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.
PostgreSQL database backups.
BACKUPS FOR POSTGRESQL
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.
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.
Re: PostgreSQL database backups.
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 .
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 .
Re: PostgreSQL database backups.
Hi
Here is an example
DBUArchive -ARCHIVE_MODE ON -ARCHIVE_DIRECTORY ${FILTEMPCTM}/Backups/Archives -SILENT Y
Here is an example
DBUArchive -ARCHIVE_MODE ON -ARCHIVE_DIRECTORY ${FILTEMPCTM}/Backups/Archives -SILENT Y
Re: PostgreSQL database backups.
Thanks for your comment.
It worked out and working fine.
It worked out and working fine.