Re: [Users] update from 3.3 beta to RC failed during db upgrade

From: "Alex Lourie" <alourie(a)redhat.com&gt; To: "Jakub Bittner" <j.bittner(a)nbu.cz&gt; Cc: "Alon Bar-Lev" <alonbl(a)redhat.com&gt;, "Eli Mesika" <emesika(a)redhat.com&gt;, users(a)ovirt.org Sent: Tuesday, August 27, 2013 6:45:13 PM Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade I think we already have such a tool. Will check with Eli and update.

-- Best regards, Alex Lourie Software Developer in Integration Red Hat ----- Original Message ----- > From: "Jakub Bittner" <j.bittner(a)nbu.cz&gt; > To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; > Cc: "Alex Lourie" <alourie(a)redhat.com&gt;, "Eli Mesika" <emesika(a)redhat.com&gt;, > users(a)ovirt.org > Sent: Tuesday, August 27, 2013 6:31:11 PM > Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade > > Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a): > > > > ----- Original Message ----- > >> From: "Jakub Bittner" <j.bittner(a)nbu.cz&gt; > >> Cc: users(a)ovirt.org > >> Sent: Tuesday, August 27, 2013 4:33:34 PM > >> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade > >> > >> Dne 26.8.2013 15:13, Alex Lourie napsal(a): > >>> Sure, I'll investigate. > >>> > >> Maybe I found a problem which causes function owner to be postgre. I use > >> restore command as postgre (as on wiki: > >> http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr... > >> ) > >> > >> cd /usr/share/ovirt-engine/dbscripts > >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r > > Nice! > > Thank you! > > > > Eli, can you please confirm, or suggest alternate way. > > > > We should probably provide a script to change ownership for users who > > made > > restore. > > > > Regards, > > Alon > That script would be perfect, because I dont know how to easily switch > owner of function. > > Last time I did it by exporting db, manually change owner postgre to > owner engine in sql backup file and restore db from it. >