It is currently 20 Aug 2017 7:43


Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 13 Jul 2012 4:22 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 12:00
Posts: 58
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.


Top
   
 Post subject: BACKUPS FOR POSTGRESQL
PostPosted: 23 Jul 2012 7:02 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Oct 2007 12:00
Posts: 161
Location: Melbourne
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.


Top
   
PostPosted: 28 Jan 2015 6:43 
Offline
Nouveau
Nouveau
User avatar

Joined: 12 Nov 2013 12:00
Posts: 14
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 .


Top
   
PostPosted: 30 Jan 2015 10:19 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 695
Location: PARIS
Hi

Here is an example

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


Top
   
PostPosted: 03 Jul 2015 5:21 
Offline
Nouveau
Nouveau
User avatar

Joined: 12 Nov 2013 12:00
Posts: 14
Thanks for your comment.

It worked out and working fine.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved