9:22 a.m.
----- Original Message -----
From: "Alon Bar-Lev" <alonbl(a)redhat.com>
To: "Eli Mesika" <emesika(a)redhat.com>
Cc: "Alex Lourie" <alourie(a)redhat.com>, "Jakub Bittner"
<j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 7:54:15 PM
Subject: 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.
Should that be located in dbscripts or dbutils (or you don't mind ....)
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.
> > >
> >
>