[ovirt-users] Error attempting to create dwh readonly user

[Yedidyah Bar David]

On Sun, Mar 26, 2017 at 6:12 AM, Berger, Sandy <SBERGER at qg.com> wrote:
> I am running oVirt 4.1.1.
>
>
>
> I am following the instructions in the “Data Warehouse Guide” to create an
> account for readonly access to the data warehouse history database. I am not
> familiar with postgres. I am using the command:
>
>
>
> psql -U postgres -c "CREATE ROLE username WITH LOGIN ENCRYPTED PASSWORD
> 'password';" -d ovirt_engine_history
>
>
>
> But I am getting the error:
>
>
>
> psql: FATAL:  Peer authentication failed for user "postgres"
>
>
>
> Any suggestions would be appreciated.

Are you doing this as root? Please try to do this from OS user 'postgres'.

Best,

>
>
>
> Sandy Berger
>
> IT - EUX
>
>
>
> Quad/Graphics
>
> Performance through Innovation
>
>
>
> Sussex, Wisconsin
>
> 414.566.2123 phone
>
> 414.566.4010/2123 pager/PIN
>
>
>
> sandy.berger at qg.com
>
> www.QG.com
>
>
>
> Follow Us: Facebook | Twitter | LinkedIn | YouTube
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>



-- 
Didi