Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- Original Message -----
From: "Eli Mesika" <emesika(a)redhat.com>
To: "Alex Lourie" <alourie(a)redhat.com>, "Alon Bar-Lev"
<alonbl(a)redhat.com>
Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 6:59:10 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- Original Message -----
> From: "Alex Lourie" <alourie(a)redhat.com>
> To: "Jakub Bittner" <j.bittner(a)nbu.cz>
> Cc: "Alon Bar-Lev" <alonbl(a)redhat.com>, "Eli Mesika"
<emesika(a)redhat.com>,
> 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.
I have such a script , do you want me to post it upstream ???
Yes, it will be great.
It should be run on 3.2 and prepare it to upgrade in case of post-restore.
>
> --
>
> Best regards,
>
> Alex Lourie
> Software Developer in Integration
> Red Hat
>
>
> ----- Original Message -----
> > From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> > Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli Mesika"
> > <emesika(a)redhat.com>,
> > 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>
> > >> 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.
> >
>