Re: [ovirt-users] How to manually restore ovirt-engine from sql dump file?

On Wed, Dec 30, 2015 at 9:23 PM, Arman Khalatyan <arm2arm(a)gmail.com&gt; wrote: Only db? Rest of machine is ok? You also want stuff in /etc (and /var, somewhat less important). These are saved during engine-setup, and are backups made with the version you had _before_ starting the upgrade. They are meant only for restoration during rollback, by engine-setup itself, in case it has a problem and tries to rollback. In principle yes, but unless you have a backup of /etc taken _before_ the last upgrade, you'll have an older dump with a newer /etc, which might lead to conflicts. You can try something like that. First on a test system of course: 1. yum remove ovirt-engine\* 2. yum install ovirt-engine with the exact version you had before last upgrade. You can check logs in /var/log/ovirt-engine/setup and/or /var/log/yum.log. 3. Keep (or copy/restore) /etc/ovirt-engine and /etc/pki/ovirt-engine. If you had dwh/reports you'll need more files. Also better check the list of backed up files in the start of the engine-backup script to see what else it backs up. 4. Restore the db using psql (if <= 3.5) or pg_restore (if >=3.6). If needed first create one. 5. run engine-setup --offline and see that all seems ok. 6. Then upgrade to latest by running engine-setup without --offline. Indeed, but are not managed. Meaning, no ha/scheduling/etc. Note that if you do try that on a test system, it will immediately try to manage your hosts. Better prevent that (firewall or whatever) before you are ready to do that on your live system. Good luck, -- Didi