Hello
I need to do online backup of the Postgre DB where is the Controlm.
How can I do?
thank you very much
How to make backup of PostgreSQL DB?
BACKUP POSTGRESQL DATABASE
Do you want to back up Control-M/Server database or Control-M/EM database? With Control-M/EM you don't do a backup but an export, using a Control-M/EM utility. With Control-M/Server you do backups.
If you want to do a full backup so that you have the option of restoring Control-M/Server to a point in time, you must do a cold backup and for this you must bring down Control-M/Server.
If you only want to produce a backup to enable you to recover from a database failure, you can run a hot backup without bringing down Control-M/Server. However to do this you must first turn on Archive Mode (via ctm_menu). There you specify your archive directory. By doing this you enable Control-M database to produce regular archive logs so that when a restore is performed it can restores the last backup taken and then apply all the archive logs to return you to the point in time before the failure occurred.
The more often you do a backup, the less archive logs you need to keep and the quicker a restore is. But really, you don't have to run the backups very often.
If you want to do a full backup so that you have the option of restoring Control-M/Server to a point in time, you must do a cold backup and for this you must bring down Control-M/Server.
If you only want to produce a backup to enable you to recover from a database failure, you can run a hot backup without bringing down Control-M/Server. However to do this you must first turn on Archive Mode (via ctm_menu). There you specify your archive directory. By doing this you enable Control-M database to produce regular archive logs so that when a restore is performed it can restores the last backup taken and then apply all the archive logs to return you to the point in time before the failure occurred.
The more often you do a backup, the less archive logs you need to keep and the quicker a restore is. But really, you don't have to run the backups very often.