Thanks. That worked. However, now when I try to use that user from a remote system I am getting this error. I’m not sure what I need to add to the pg_hba.conf file or what I need to do after editing it.
Credential validation was not successful: no pg_hba.conf entry for host "ip_address", user "username", database "ovirt_engine_history", SSL off -----Original Message----- From: Yedidyah Bar David [mailto:[email protected]] Sent: Sunday, March 26, 2017 1:43 AM To: Berger, Sandy <[email protected]> Cc: [email protected] Subject: Re: [ovirt-users] Error attempting to create dwh readonly user On Sun, Mar 26, 2017 at 6:12 AM, Berger, Sandy <[email protected]<mailto:[email protected]>> 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 > > > > [email protected]<mailto:[email protected]> > > www.QG.com<http://www.QG.com> > > > > Follow Us: Facebook | Twitter | LinkedIn | YouTube > > _______________________________________________ > Users mailing list > [email protected]<mailto:[email protected]> > http://lists.ovirt.org/mailman/listinfo/users > -- Didi Follow Us: Facebook<http://www.qg.com/social1> | Twitter<http://www.qg.com/social2> | LinkedIn<http://www.qg.com/social3> | YouTube<http://www.qg.com/social4>
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
