It is currently 27 Jul 2017 10:38


Post new topic  Reply to topic  [ 3 posts ] 
Author Message
PostPosted: 11 Jul 2011 2:21 
Offline
Nouveau
Nouveau
User avatar

Joined: 20 Nov 2010 12:00
Posts: 12
I am looking to develop a DR procedure for the EM and the Server. I am using CONTROL-M v7 w/ PostgreSQL database. The recovery has to happen within 30 minutes. I am told mirroring is only for high availability and will not work well for disaster recovery. (The DR site is on a different LAN).

Are there replication services provided by BMC for PostgreSQL DB?


Top
   
 Post subject:
PostPosted: 15 Jul 2011 5:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 05 Mar 2009 12:00
Posts: 2
PostgreSQL comes with hot back and auto archiving. You can enable archiving and then ship the log files over to the DR site.
In archiving mode all the database transactions are written out to a file and a new file is created every period. If you configure that this period to be 30 minutes then a new archived log file will be created every 30 minutes and then setup a job to move the log file from the production site to the DR site.
On the DR site you can restore the log file as it arrives and system is ready to run. At worst you will have a 30 minute loss of activity.


Top
   
 Post subject: 30 minute lag time?
PostPosted: 31 Jul 2011 6:06 
Offline
Nouveau
Nouveau
User avatar

Joined: 20 Nov 2010 12:00
Posts: 12
We are running 40,000 jobs daily, many that load databases and do real time data processing. A 30 minute lag is an unacceptable solution. We need realtime replication at the DR site. If PostgreSQL does not offer this, how can BMC expect users to use this database?


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 3 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