[Users] Database creation failed on engine-setup

[Yedidyah Bar David]

----- Original Message -----
> From: "Alon Bar-Lev" <alonbl at redhat.com>
> To: "Łukasz Bartnicki" <lbartnicki92 at gmail.com>
> Cc: users at ovirt.org
> Sent: Tuesday, August 20, 2013 9:04:47 AM
> Subject: Re: [Users] Database creation failed on engine-setup
> 
> 
> 
> ----- Original Message -----
> > From: "Łukasz Bartnicki" <lbartnicki92 at gmail.com>
> > To: users at ovirt.org
> > Sent: Monday, August 19, 2013 11:06:05 PM
> > Subject: Re: [Users] Database creation failed on engine-setup
> > 
> > http://lists.ovirt.org/pipermail/users/2012-August/009016.html
> > 
> > Can you describe how you use initdb command to repair plsql database ?  :)
> > 
> 
> If you start from scratch, I think the best way is to remove the entire
> database.

A scenario that can lead to this state:

install ovirt 3.3 (e.g. nightly, beta1)
engine-setup
engine-cleanup
this leaves an empty 'engine' database
install ovirt 3.2
engine-setup
this will fail
Solution:
before installing 3.2, do inside psql:
drop database engine;

> 
> # service postgresql stop
> # rm -fr /var/lib/pgsql/data

This is naturally simpler, if you have no other database there.

> # engine-setup
-- 
Didi