On Wed, Mar 15, 2017 at 10:42 PM, Martin Perina <mperina@redhat.com> wrote:
> Hi,
>
> I think you have forgotten 'su' command at beginning, correct commands are:
>
>   su - postgres -c "psql -d template1 -c \"create user engine password
> 'engine';\""
>   su - postgres -c "psql -d template1 -c \"create database engine owner
> engine template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype
> 'en_US.UTF-8';\""
>

You can also use this:

/usr/share/ovirt-engine/setup/bin/ovirt-engine-provisiondb
--otopi-environment="OVESETUP_PROVISION_DB/database=str:engine
OVESETUP_PROVISION_DB/user=str:engine
OVESETUP_PROVISION_DB/password=str:mypassword"

It should do "everything" - initdb, create user and db, configure pg, etc.

If you messed up your pg setup and want to start from scratch (which you
at least partially did, if you have bad permissions on pg_hba.conf), you
can do this:

1. Disconnect everything that's connected to pg, if any
2. systemctl stop postgresql
3. rm -rf /var/lib/pgsql/data

Then try again (following the web page or using above command).

Best,

>
> Martin
>
>
> On Wed, Mar 15, 2017 at 5:30 PM, shubham dubey <sdubey504@gmail.com> wrote:
>>
>> Hello,
>> I am trying to setup ovirt-engine using this link
>> http://www.ovirt.org/develop/developer-guide/engine/engine-development-environment/.
>> Now when I am trying these commands I am getting following error
>> $postgres -c "psql -d template1 -c \"create user engine password
>> 'engine';\""
>> FATAL:  -c psql -d template1 -c "create user engine password 'engine';"
>> requires a value
>>
>> and
>> $postgres -c "psql -d template1 -c "create database engine \
>> owner engine template template0 encoding 'UTF8' lc_collate \
>> 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\""
>> FATAL:  -c psql -d template1 -c "create database engine owner engine
>> template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype
>> 'en_US.UTF-8';" requires a value
>>
>> So I think the syntax given there is not right,So can anyone tell me the
>> correct syntax.Or maybe I am doing something wrong.
>>
>> Thanks,
>> Shubham
>>
>> _______________________________________________
>> Devel mailing list
>> Devel@ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/devel
>
>
>
> _______________________________________________
> Devel mailing list
> Devel@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel

--
Didi