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

[Alex Lourie]

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 at nbu.cz>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: "Alex Lourie" <alourie at redhat.com>, "Eli Mesika" <emesika at redhat.com>, users at 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 at nbu.cz>
> >> Cc: users at 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_Postgresql_database
> >> )
> >>
> >> 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.
>