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

[Jakub Bittner]

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.