Steps taken:<br><br>Load up bare metal or a VM with FC16<br>Install 3.0 from <a href="http://www.ovirt.org/releases/stable/fedora/16/">http://www.ovirt.org/releases/stable/fedora/16/</a><br>Setup up something minimal (EG: engine-setup then setup a basic datacenter/cluster/etc)<br>
Add a FC16 or EL based node for fun as well and some VM&#39;s if feeling ambitious. <br><br>Back up database:<br>systemctl stop jboss-as.service<br>pg_dump -C -E UTF8 --column-inserts --disable-dollar-quoting --disable-triggers -U postgres --format=p -f &quot;/temp/engine.sql&quot; engine<br>
<br>Back up the following files within /etc/pki/ovirt-engine from a 3.0 install (preserve owner/group).<br>/etc/pki/ovirt-engine/cacert.conf<br>/etc/pki/ovirt-engine/ca.pem<br>/etc/pki/ovirt-engine/cert.conf<br>/etc/pki/ovirt-engine/certs/01.pem<br>
/etc/pki/ovirt-engine/certs/02.pem<br>/etc/pki/ovirt-engine/certs/ca.der<br>/etc/pki/ovirt-engine/certs/engine.cer<br>/etc/pki/ovirt-engine/certs/engine.der<br>/etc/pki/ovirt-engine/database.txt<br>/etc/pki/ovirt-engine/database.txt.attr<br>
/etc/pki/ovirt-engine/database.txt.attr.old<br>/etc/pki/ovirt-engine/database.txt.old<br>/etc/pki/ovirt-engine/keys/engine_id_rsa<br>/etc/pki/ovirt-engine/keys/engine.ssh.key.txt<br>/etc/pki/ovirt-engine/private/ca.pem<br>
/etc/pki/ovirt-engine/requests/ca.csr<br>/etc/pki/ovirt-engine/requests/engine.req<br><br>Load up bare metal or a VM with FC17 (Upgrade from FC16 --&gt; FC17 is still rather messy)<br>Install 3.1 from <a href="http://www.ovirt.org/releases/beta/fedora/17/">http://www.ovirt.org/releases/beta/fedora/17/</a><br>
<br>Run engine-setup to get an initial setup.<br>stop ovirt-engine (systemctl stop ovirt-engine.service)<br><br>Copy the previously backed up /etc/pki/ovirt-engine files from above over top of the ones just generated (be sure to preserve owner/group EG: cp -a)<br>
<br>Drop the existing engine database: dropdb -U postgres engine<br>Create a new blank database: createdb -U postgres engine<br>Populate with with the backup of the above 3.0 database:<br>psql -U postgres -d engine -w &lt; &quot;/temp/engine.sql&quot;<br>
<br>Attempt to upgrade the DBschema via /usr/share/ovirt-engine/dbscripts/upgrade.sh<br>upgrade.sh -u postgres<br><br>The DB schema upgrade will fail like so:<br><br>Running upgrade script upgrade/03_01_0260_add_job_table.sql <br>
psql:upgrade/03_01_0260_add_job_table.sql:29: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index &quot;pk_jobs&quot; for table &quot;job&quot;<br>CONTEXT:  SQL statement &quot;CREATE TABLE job<br>       (<br>          job_id UUID NOT NULL,<br>
          action_type VARCHAR(50) NOT NULL,<br>          description TEXT NOT NULL,<br>          status VARCHAR(32) NOT NULL,<br>          owner_id UUID,<br>          visible BOOLEAN NOT NULL DEFAULT true,<br>          start_time TIMESTAMP WITH TIME ZONE NOT NULL,<br>
          end_time TIMESTAMP WITH TIME ZONE default NULL,<br>          last_update_time TIMESTAMP WITH TIME ZONE default NULL,<br>          correlation_id VARCHAR(50) NOT NULL,<br>          CONSTRAINT pk_jobs PRIMARY KEY(job_id)<br>
       )<br>       WITH OIDS&quot;<br>PL/pgSQL function &quot;__temp_upgrade_add_job_table&quot; line 6 at SQL statement<br>psql:/tmp/tmp.mXz8U4xpWr:3: ERROR:  column &quot;comment&quot; of relation &quot;schema_version&quot; does not exist<br>
LINE 1: ...ksum,installed_by,started_at,ended_at,state,current,comment)<br><br>My assumption here is that if the DB schema upgrade would work, that this should be the cleanest way to upgrade from 3.0 to 3.1.<br><br>- DHC<br>