From jhorne at skopos.us Mon Nov 26 09:26:01 2012 Content-Type: multipart/mixed; boundary="===============1435065780696977349==" MIME-Version: 1.0 From: Jonathan Horne To: users at ovirt.org Subject: [Users] engine backup and recovery Date: Mon, 26 Nov 2012 14:25:59 +0000 Message-ID: <9BE6F493F83A594DA60C45E6A09DC5AC016B71CF@AUSP01DAG0201.collaborationhost.net> --===============1435065780696977349== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable --_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_ Content-Type: text/plain; charset=3D"us-ascii" Content-Transfer-Encoding: quoted-printable Is there an accepted method to keep the engine backed up for use in disaste= =3D r recovery scenario? I'm new to postgres, so I'm not sure how to keep it h= =3D appy with dumps and restores. I've not yet seen a disaster check sheet for= =3D 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= =3D gine) system failure? Thanks, jonathan ________________________________ This is a PRIVATE message. If you are not the intended recipient, please de= =3D lete without copying and kindly advise us by e-mail of the mistake in deliv= =3D ery. NOTE: Regardless of content, this e-mail shall not operate to bind SKO= =3D POS to any order or other contract unless pursuant to explicit written agre= =3D ement or government initiative expressly permitting the use of e-mail for s= =3D uch purpose. --_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_ Content-Type: text/html; charset=3D"us-ascii" Content-ID: <57D0475930B3604FB52C05880F4C9689(a)collaborationhost.net> Content-Transfer-Encoding: quoted-printable
Is there an= a=3D ccepted method to keep the engine backed up for use in disaster recovery sc= =3D enario?  I'm new to postgres, so I'm not sure how to keep it happy wit= =3D h dumps and restores.  I've not yet seen a disaster check sheet for recovery, but that doesn't mean I didn't google= =3D good enough.

Is there a = wo=3D rkable process for how this would be recovered after total (engine) system = =3D failure?

Thanks,
jonathan




This is a PRIVATE mess= age. I=3D f you are not the intended recipient, please delete without copying and kin= =3D dly advise us by e-mail of the mistake in delivery. NOTE: Regardless of con= =3D tent, this e-mail shall not operate to bind SKOPOS to any order or other contract unless pursuant to explicit wri= =3D tten agreement or government initiative expressly permitting the use of e-m= =3D ail for such purpose. --_000_9BE6F493F83A594DA60C45E6A09DC5AC016B71CFAUSP01DAG0201co_-- --===============1435065780696977349== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS1fMDAwXzlCRTZGNDkzRjgzQTU5NERBNjBDNDVFNkEwOURDNUFDMDE2QjcxQ0ZBVVNQMDFEQUcw MjAxY29fCkNvbnRlbnQtVHlwZTogdGV4dC9wbGFpbjsgY2hhcnNldD0idXMtYXNjaWkiCkNvbnRl bnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCklzIHRoZXJlIGFuIGFjY2Vw dGVkIG1ldGhvZCB0byBrZWVwIHRoZSBlbmdpbmUgYmFja2VkIHVwIGZvciB1c2UgaW4gZGlzYXN0 ZT0KciByZWNvdmVyeSBzY2VuYXJpbz8gIEknbSBuZXcgdG8gcG9zdGdyZXMsIHNvIEknbSBub3Qg c3VyZSBob3cgdG8ga2VlcCBpdCBoPQphcHB5IHdpdGggZHVtcHMgYW5kIHJlc3RvcmVzLiAgSSd2 ZSBub3QgeWV0IHNlZW4gYSBkaXNhc3RlciBjaGVjayBzaGVldCBmb3I9CiByZWNvdmVyeSwgYnV0 IHRoYXQgZG9lc24ndCBtZWFuIEkgZGlkbid0IGdvb2dsZSBnb29kIGVub3VnaC4KCklzIHRoZXJl IGEgd29ya2FibGUgcHJvY2VzcyBmb3IgaG93IHRoaXMgd291bGQgYmUgcmVjb3ZlcmVkIGFmdGVy IHRvdGFsIChlbj0KZ2luZSkgc3lzdGVtIGZhaWx1cmU/CgpUaGFua3MsCmpvbmF0aGFuCgoKCl9f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fClRoaXMgaXMgYSBQUklWQVRFIG1lc3NhZ2Uu IElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHBsZWFzZSBkZT0KbGV0ZSB3 aXRob3V0IGNvcHlpbmcgYW5kIGtpbmRseSBhZHZpc2UgdXMgYnkgZS1tYWlsIG9mIHRoZSBtaXN0 YWtlIGluIGRlbGl2PQplcnkuIE5PVEU6IFJlZ2FyZGxlc3Mgb2YgY29udGVudCwgdGhpcyBlLW1h aWwgc2hhbGwgbm90IG9wZXJhdGUgdG8gYmluZCBTS089ClBPUyB0byBhbnkgb3JkZXIgb3Igb3Ro ZXIgY29udHJhY3QgdW5sZXNzIHB1cnN1YW50IHRvIGV4cGxpY2l0IHdyaXR0ZW4gYWdyZT0KZW1l bnQgb3IgZ292ZXJubWVudCBpbml0aWF0aXZlIGV4cHJlc3NseSBwZXJtaXR0aW5nIHRoZSB1c2Ug b2YgZS1tYWlsIGZvciBzPQp1Y2ggcHVycG9zZS4KCi0tXzAwMF85QkU2RjQ5M0Y4M0E1OTREQTYw QzQ1RTZBMDlEQzVBQzAxNkI3MUNGQVVTUDAxREFHMDIwMWNvXwpDb250ZW50LVR5cGU6IHRleHQv aHRtbDsgY2hhcnNldD0idXMtYXNjaWkiCkNvbnRlbnQtSUQ6IDw1N0QwNDc1OTMwQjM2MDRGQjUy QzA1ODgwRjRDOTY4OUBjb2xsYWJvcmF0aW9uaG9zdC5uZXQ+CkNvbnRlbnQtVHJhbnNmZXItRW5j b2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCjxodG1sPgo8aGVhZD4KPG1ldGEgaHR0cC1lcXVpdj0z RCJDb250ZW50LVR5cGUiIGNvbnRlbnQ9M0QidGV4dC9odG1sOyBjaGFyc2V0PTNEdXMtYXNjaWki PQo+CjwvaGVhZD4KPGJvZHkgc3R5bGU9M0Qid29yZC13cmFwOmJyZWFrLXdvcmQ7IGNvbG9yOnJn YigwLDAsMCkiPgo8ZGl2Pgo8ZGl2Pgo8ZGl2IHN0eWxlPTNEImZvbnQtZmFtaWx5OkNhbGlicmks c2Fucy1zZXJpZjsgZm9udC1zaXplOjE0cHgiPklzIHRoZXJlIGFuIGE9CmNjZXB0ZWQgbWV0aG9k IHRvIGtlZXAgdGhlIGVuZ2luZSBiYWNrZWQgdXAgZm9yIHVzZSBpbiBkaXNhc3RlciByZWNvdmVy eSBzYz0KZW5hcmlvPyAmbmJzcDtJJ20gbmV3IHRvIHBvc3RncmVzLCBzbyBJJ20gbm90IHN1cmUg aG93IHRvIGtlZXAgaXQgaGFwcHkgd2l0PQpoIGR1bXBzIGFuZCByZXN0b3Jlcy4gJm5ic3A7SSd2 ZSBub3QgeWV0IHNlZW4KIGEgZGlzYXN0ZXIgY2hlY2sgc2hlZXQgZm9yIHJlY292ZXJ5LCBidXQg dGhhdCBkb2Vzbid0IG1lYW4gSSBkaWRuJ3QgZ29vZ2xlPQogZ29vZCBlbm91Z2guPC9kaXY+Cjxk aXYgc3R5bGU9M0QiZm9udC1mYW1pbHk6Q2FsaWJyaSxzYW5zLXNlcmlmOyBmb250LXNpemU6MTRw eCI+PGJyPgo8L2Rpdj4KPGRpdiBzdHlsZT0zRCJmb250LWZhbWlseTpDYWxpYnJpLHNhbnMtc2Vy aWY7IGZvbnQtc2l6ZToxNHB4Ij5JcyB0aGVyZSBhIHdvPQpya2FibGUgcHJvY2VzcyBmb3IgaG93 IHRoaXMgd291bGQgYmUgcmVjb3ZlcmVkIGFmdGVyIHRvdGFsIChlbmdpbmUpIHN5c3RlbSA9CmZh aWx1cmU/PC9kaXY+CjxkaXYgc3R5bGU9M0QiZm9udC1mYW1pbHk6Q2FsaWJyaSxzYW5zLXNlcmlm OyBmb250LXNpemU6MTRweCI+PGJyPgo8L2Rpdj4KPGRpdiBzdHlsZT0zRCJmb250LWZhbWlseTpD YWxpYnJpLHNhbnMtc2VyaWY7IGZvbnQtc2l6ZToxNHB4Ij5UaGFua3MsPC9kaXY+CjxkaXYgc3R5 bGU9M0QiZm9udC1mYW1pbHk6Q2FsaWJyaSxzYW5zLXNlcmlmOyBmb250LXNpemU6MTRweCI+am9u YXRoYW48L2Rpdj0KPgo8ZGl2Pgo8ZGl2Pgo8ZGl2Pjxmb250IGNsYXNzPTNEIkFwcGxlLXN0eWxl LXNwYW4iIGZhY2U9M0QiVGltZXMiPjxzcGFuIGNsYXNzPTNEIkFwcGxlLXM9CnR5bGUtc3BhbiIg c3R5bGU9M0QiIj48YnI+Cjwvc3Bhbj48L2ZvbnQ+PC9kaXY+CjxkaXYgc3R5bGU9M0QiZm9udC1m YW1pbHk6Q2FsaWJyaSxzYW5zLXNlcmlmOyBmb250LXNpemU6MTRweCI+PGJyPgo8L2Rpdj4KPC9k aXY+CjwvZGl2Pgo8L2Rpdj4KPC9kaXY+Cjxicj4KPGhyPgo8Zm9udCBjb2xvcj0zRCJHcmF5IiBm YWNlPTNEIkFyaWFsIiBzaXplPTNEIjEiPlRoaXMgaXMgYSBQUklWQVRFIG1lc3NhZ2UuIEk9CmYg eW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCwgcGxlYXNlIGRlbGV0ZSB3aXRob3V0 IGNvcHlpbmcgYW5kIGtpbj0KZGx5IGFkdmlzZSB1cyBieSBlLW1haWwgb2YgdGhlIG1pc3Rha2Ug aW4gZGVsaXZlcnkuIE5PVEU6IFJlZ2FyZGxlc3Mgb2YgY29uPQp0ZW50LCB0aGlzIGUtbWFpbCBz aGFsbCBub3Qgb3BlcmF0ZSB0bwogYmluZCBTS09QT1MgdG8gYW55IG9yZGVyIG9yIG90aGVyIGNv bnRyYWN0IHVubGVzcyBwdXJzdWFudCB0byBleHBsaWNpdCB3cmk9CnR0ZW4gYWdyZWVtZW50IG9y IGdvdmVybm1lbnQgaW5pdGlhdGl2ZSBleHByZXNzbHkgcGVybWl0dGluZyB0aGUgdXNlIG9mIGUt bT0KYWlsIGZvciBzdWNoIHB1cnBvc2UuPC9mb250Pgo8L2JvZHk+CjwvaHRtbD4KCi0tXzAwMF85 QkU2RjQ5M0Y4M0E1OTREQTYwQzQ1RTZBMDlEQzVBQzAxNkI3MUNGQVVTUDAxREFHMDIwMWNvXy0t Cg== --===============1435065780696977349==--