[Users] engine backup and recovery
--_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Is there an accepted method to keep the engine backed up for use in disaste= r recovery scenario? I'm new to postgres, so I'm not sure how to keep it h= appy with dumps and restores. I've not yet seen a disaster check sheet for= recovery, but that doesn't mean I didn't google good enough. Is there a workable process for how this would be recovered after total (en= gine) system failure? Thanks, jonathan ________________________________ This is a PRIVATE message. If you are not the intended recipient, please de= lete without copying and kindly advise us by e-mail of the mistake in deliv= ery. NOTE: Regardless of content, this e-mail shall not operate to bind SKO= POS to any order or other contract unless pursuant to explicit written agre= ement or government initiative expressly permitting the use of e-mail for s= uch purpose. --_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_ Content-Type: text/html; charset="us-ascii" Content-ID: <57D0475930B3604FB52C05880F4C9689@collaborationhost.net> Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
</head> <body style=3D"word-wrap:break-word; color:rgb(0,0,0)"> <div> <div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px">Is there an a= ccepted method to keep the engine backed up for use in disaster recovery sc= enario? I'm new to postgres, so I'm not sure how to keep it happy wit= h dumps and restores. I've not yet seen a disaster check sheet for recovery, but that doesn't mean I didn't google= good enough.</div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px"><br> </div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px">Is there a wo= rkable process for how this would be recovered after total (engine) system = failure?</div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px"><br> </div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px">Thanks,</div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px">jonathan</div=
<div> <div> <div><font class=3D"Apple-style-span" face=3D"Times"><span class=3D"Apple-s= tyle-span" style=3D""><br> </span></font></div> <div style=3D"font-family:Calibri,sans-serif; font-size:14px"><br> </div> </div> </div> </div> </div> <br> <hr> <font color=3D"Gray" face=3D"Arial" size=3D"1">This is a PRIVATE message. I= f you are not the intended recipient, please delete without copying and kin= dly advise us by e-mail of the mistake in delivery. NOTE: Regardless of con= tent, this e-mail shall not operate to bind SKOPOS to any order or other contract unless pursuant to explicit wri= tten agreement or government initiative expressly permitting the use of e-m= ail for such purpose.</font> </body> </html> --_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_--
</p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Couri= er New";color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><sp= an style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'># Perf= orm DB-Backup<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font= -size:8.0pt;font-family:"Courier New";color:#1F497D'>pg_dump -C -E UTF8 --c=
</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-= family:"Courier New";color:#1F497D'> &nb= sp; --for= mat=3Dp \<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-siz= e:8.0pt;font-family:"Courier New";color:#1F497D'> &n= bsp; &nbs=
<span style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'>fi= nd $DB_EXPORT_PATH -mtime +5 -exec rm {}\;<o:p></o:p></span></p><p class=3D= MsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";color:#1= F497D'>find /mnt/backup -mtime +5 -exec rm {}\;<o:p></o:p></span></p><p cla= ss=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";col= or:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span style=3D= 'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>We have=
<br><o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11= .0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Please notice this b= ash script is currently working for oVirt engine 3.0, so you will maybe nee= d some customizations for 3.1?<o:p></o:p></span></p><p class=3DMsoNormal><s=
Betreff:</b> [Users] engine backup and recovery<o:p></o:p></span></p></div= </div><p class=3DMsoNormal><o:p> </o:p></p><div><div><div><p class=3D= MsoNormal><span style=3D'font-size:10.5pt;font-family:"Calibri","sans-serif= ";color:black'>Is there an accepted method to keep the engine backed up for= use in disaster recovery scenario? I'm new to postgres, so I'm not s= ure how to keep it happy with dumps and restores. I've not yet seen a= disaster check sheet for recovery, but that doesn't mean I didn't google g= ood enough.<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span styl= e=3D'font-size:10.5pt;font-family:"Calibri","sans-serif";color:black'><o:p>= </o:p></span></p></div><div><p class=3DMsoNormal><span style=3D'font-= size:10.5pt;font-family:"Calibri","sans-serif";color:black'>Is there a work= able process for how this would be recovered after total (engine) system fa= ilure?<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span style=3D'= font-size:10.5pt;font-family:"Calibri","sans-serif";color:black'><o:p> = ;</o:p></span></p></div><div><p class=3DMsoNormal><span style=3D'font-size:= 10.5pt;font-family:"Calibri","sans-serif";color:black'>Thanks,<o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span style=3D'font-size:10.5pt;fo= nt-family:"Calibri","sans-serif";color:black'>jonathan<o:p></o:p></span></p= </div><div><div><div><p class=3DMsoNormal><span style=3D'color:black'><o:p= </o:p></span></p></div><div><p class=3DMsoNormal><span style=3D'font= -size:10.5pt;font-family:"Calibri","sans-serif";color:black'><o:p> </o= :p></span></p></div></div></div></div></div><p class=3DMsoNormal><span styl= e=3D'color:black'><o:p> </o:p></span></p><div class=3DMsoNormal align= =3Dcenter style=3D'text-align:center'><span style=3D'color:black'><hr size= =3D2 width=3D"100%" align=3Dcenter></span></div><p class=3DMsoNormal><span =
--_000_DC9ABD90CB55EC448B1F682D5731AF74077F0E0E1AIAD2MBX17mex0_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Jonathan, This is the script we use in our company for ovirt-engine backups: #!/bin/bash DB_EXPORT_PATH=3D/usr/share/ovirt-engine/db-backups DB_BKUP_FILENAME=3Ddump_engine_`date "+%Y%m%d_%H%M"`.sql DB_NAME=3Dengine ENGINE_BKUP_FILENAME=3Dbkup_engine_conf_`date "+%Y%m%d_%H%M"`.tgz ENGINE_CONF=3D'/etc/jboss-as/jboss-as.conf /etc/ovirt-engine /etc/pki/ovirt-engine /usr/share/ovirt-engine/dbscripts /usr/share/ovirt-engine/conf /usr/share/ovirt-engine/resources/jboss /root/.pgpass /root/.rnd' # Perform DB-Backup pg_dump -C -E UTF8 --column-inserts \ --disable-dollar-quoting \ --disable-triggers \ -U postgres \ --format=3Dp \ -f $DB_EXPORT_PATH/$DB_BKUP_FILENAME \ $DB_NAME # Perform backup of Engine Configuration tar zcf $DB_EXPORT_PATH/$ENGINE_BKUP_FILENAME $ENGINE_CONF # Copy Backups to SMB Backup storage cp $DB_EXPORT_PATH/$DB_BKUP_FILENAME $DB_EXPORT_PATH/$ENGINE_BKUP_FILENAME = /mnt/backup # Remove older backups find $DB_EXPORT_PATH -mtime +5 -exec rm {}\; find /mnt/backup -mtime +5 -exec rm {}\; We have this VM running in a separate KVM Fail-over Cluster, based on LVM. Generate one or more LVM snapshots (can also be done via monthly cronjobfor= example) of your engine + data/db backups of your engine should be enough. Please notice this bash script is currently working for oVirt engine 3.0, s= o you will maybe need some customizations for 3.1? Best, Sven. Von: users-bounces@ovirt.org [mailto:users-bounces@ovirt.org] Im Auftrag vo= n Jonathan Horne Gesendet: Montag, 26. November 2012 15:26 An: users@ovirt.org Betreff: [Users] engine backup and recovery Is there an accepted method to keep the engine backed up for use in disaste= r recovery scenario? I'm new to postgres, so I'm not sure how to keep it h= appy with dumps and restores. I've not yet seen a disaster check sheet for= recovery, but that doesn't mean I didn't google good enough. Is there a workable process for how this would be recovered after total (en= gine) system failure? Thanks, jonathan ________________________________ This is a PRIVATE message. If you are not the intended recipient, please de= lete without copying and kindly advise us by e-mail of the mistake in deliv= ery. NOTE: Regardless of content, this e-mail shall not operate to bind SKO= POS to any order or other contract unless pursuant to explicit written agre= ement or government initiative expressly permitting the use of e-mail for s= uch purpose. --_000_DC9ABD90CB55EC448B1F682D5731AF74077F0E0E1AIAD2MBX17mex0_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40"><head><meta http-equiv=3DContent-Type content= =3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros= oft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#def= ault#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} span.apple-style-span {mso-style-name:apple-style-span;} span.E-MailFormatvorlage18 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 2.0cm 70.85pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli= nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'f= ont-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Jonath= an,<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0= pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></spa= n></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Cal= ibri","sans-serif";color:#1F497D'>This is the script we use in our company = for ovirt-engine backups:<o:p></o:p></span></p><p class=3DMsoNormal><span s= tyle=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>= <o:p> </o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8= .0pt;font-family:"Courier New";color:#1F497D'>#!/bin/bash<o:p></o:p></span>= </p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courie= r New";color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><spa= n style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'>DB_EXPO= RT_PATH=3D/usr/share/ovirt-engine/db-backups<o:p></o:p></span></p><p class= =3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";color= :#1F497D'>DB_BKUP_FILENAME=3Ddump_engine_`date "+%Y%m%d_%H%M"`.sq= l<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;= font-family:"Courier New";color:#1F497D'>DB_NAME=3Dengine<o:p></o:p></span>= </p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courie= r New";color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><spa= n style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'>ENGINE_= BKUP_FILENAME=3Dbkup_engine_conf_`date "+%Y%m%d_%H%M"`.tgz<o:p></= o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-fam= ily:"Courier New";color:#1F497D'><o:p> </o:p></span></p><p class=3DMso= Normal><span style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F49= 7D'>ENGINE_CONF=3D'/etc/jboss-as/jboss-as.conf<o:p></o:p></span></p><p clas= s=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";colo= r:#1F497D'> &nbs= p; /etc/ovirt-engine<o:p></o:p></span></p><p class=3DMsoNormal><span style= =3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'> &n= bsp; /etc/pki/ovirt-engine<= o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;fo= nt-family:"Courier New";color:#1F497D'> = /usr/share/ovirt-engine/dbscripts<o:p></o:p>= </span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:= "Courier New";color:#1F497D'> &nbs= p; /usr/share/ovirt-engine/conf<o:p></o:p></span></p><p c= lass=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";c= olor:#1F497D'> &= nbsp; /usr/share/ovirt-engine/resources/jboss<o:p></o:p></span></p><p class= =3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";color= :#1F497D'> = ; /root/.pgpass<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'fo= nt-size:8.0pt;font-family:"Courier New";color:#1F497D'> &n= bsp; /root/.rnd'<o:p></o:p></span= olumn-inserts \<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'fo= nt-size:8.0pt;font-family:"Courier New";color:#1F497D'> &n= bsp; = ; --disable-dollar-quoting \<o:p></o:p></span></p><p class=3DMs= oNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F4= 97D'> &nbs= p; --disable-triggers \<o:p></o:p></spa= n></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Cour= ier New";color:#1F497D'> &nb= sp; -U postgres \<o:p= p; -f $DB_EXPORT_PATH/$DB_BKUP_FILENAME \<o:p></o:p></span></p><p clas= s=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";colo= r:#1F497D'> &nbs= p; $DB_NAME<o:p></o:p></span></p>= <p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier Ne= w";color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span st= yle=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'># Perform b= ackup of Engine Configuration<o:p></o:p></span></p><p class=3DMsoNormal><sp= an style=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'>tar zc= f $DB_EXPORT_PATH/$ENGINE_BKUP_FILENAME $ENGINE_CONF<o:p></o:p></span></p><= p class=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New= ";color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span sty= le=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'># Copy Backu= ps to SMB Backup storage<o:p></o:p></span></p><p class=3DMsoNormal><span st= yle=3D'font-size:8.0pt;font-family:"Courier New";color:#1F497D'>cp $DB_EXPO= RT_PATH/$DB_BKUP_FILENAME $DB_EXPORT_PATH/$ENGINE_BKUP_FILENAME /mnt/backup= <o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:8.0pt;f= ont-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p><p clas= s=3DMsoNormal><span style=3D'font-size:8.0pt;font-family:"Courier New";colo= r:#1F497D'># Remove older backups<o:p></o:p></span></p><p class=3DMsoNormal= this VM running in a separate KVM Fail-over Cluster, based on LVM. <br>Gen= erate one or more LVM snapshots (can also be done via monthly cronjobfor ex= ample) of your engine + data/db backups of your engine should be enough.<br= pan style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F4= 97D'><o:p> </o:p></span></p><p class=3DMsoNormal><span style=3D'font-s= ize:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o= :p></span></p><p class=3DMsoNormal><span lang=3DDE style=3D'font-size:11.0p= t;font-family:"Calibri","sans-serif";color:#1F497D'>Best,<o:p></o:p></span>= </p><p class=3DMsoNormal><span lang=3DDE style=3D'font-size:11.0pt;font-fam= ily:"Calibri","sans-serif";color:#1F497D'>Sven. <o:p></o:p></span></p><p cl= ass=3DMsoNormal><span lang=3DDE style=3D'font-size:11.0pt;font-family:"Cali= bri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div styl= e=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>= <p class=3DMsoNormal><b><span lang=3DDE style=3D'font-size:10.0pt;font-fami= ly:"Tahoma","sans-serif"'>Von:</span></b><span lang=3DDE style=3D'font-size= :10.0pt;font-family:"Tahoma","sans-serif"'> users-bounces@ovirt.org [mailto= :users-bounces@ovirt.org] <b>Im Auftrag von </b>Jonathan Horne<br><b>Gesend= et:</b> Montag, 26. November 2012 15:26<br><b>An:</b> users@ovirt.org<br><b= style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:gray'>This = is a PRIVATE message. If you are not the intended recipient, please delete = without copying and kindly advise us by e-mail of the mistake in delivery. = NOTE: Regardless of content, this e-mail shall not operate to bind SKOPOS t= o any order or other contract unless pursuant to explicit written agreement= or government initiative expressly permitting the use of e-mail for such p= urpose.</span><span style=3D'color:black'> <o:p></o:p></span></p></div></bo= dy></html>= --_000_DC9ABD90CB55EC448B1F682D5731AF74077F0E0E1AIAD2MBX17mex0_--
participants (2)
-
Jonathan Horne -
Sven Knohsalla