--_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 no= t familiar with postgres. I am using the command: psql -U postgres -c "CREATE ROLE username WITH LOGIN ENCRYPTED PASSWORD 'pa= ssword';" -d ovirt_engine_history But I am getting the error: psql: FATAL: Peer authentication failed for user "postgres" Any suggestions would be appreciated. Sandy Berger IT - EUX Quad/Graphics Performance through Innovation Sussex, Wisconsin 414.566.2123 phone 414.566.4010/2123 pager/PIN sandy.berger@qg.com<mailto:sandy.berger@qg.com> www.QG.com<http://www.qg.com/> 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> --_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
</o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.5pt;font-family:"Ar= ial",sans-serif;color:#444444"> <o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:"Ar= ial",sans-serif;color:#1E47A4">Quad/Graphics</span><span style=3D"font= -size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p><= /o:p></span></p> <p class=3D"MsoNormal"><i><span style=3D"font-size:8.0pt;font-family:"= Arial",sans-serif;color:#434D5B">Performance</span></i><span style=3D"= font-size:8.0pt;font-family:"Arial",sans-serif;color:#434D5B">&nb= sp;through </span><i><span style=3D"font-size:8.5pt;font-family:"= Arial",sans-serif;color:#434D5B">Innovation</span></i><span style=3D"f= ont-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:=
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:DejaVuSansMono; panose-1:0 0 0 0 0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;} .MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72"> <div class=3D"WordSection1"> <p class=3D"MsoNormal">I am running oVirt 4.1.1.<o:p></o:p></p> <p class=3D"MsoNormal"><o:p> </o:p></p> <p class=3D"MsoNormal">I am following the instructions in the “Data W= arehouse 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:<o:p></o:p></p> <p class=3D"MsoNormal"><o:p> </o:p></p> <p class=3D"MsoNormal" style=3D"text-autospace:none"><span style=3D"font-si= ze:8.0pt;font-family:"Courier New"">psql -U postgres -c "CRE= ATE ROLE <i>username </i>WITH LOGIN ENCRYPTED PASSWORD '<i>password</i>';" -d o= virt_engine_history<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.5pt;font-family:DejaVuSa= nsMono"><o:p> </o:p></span></p> <p class=3D"MsoNormal">But I am getting the error:<o:p></o:p></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.5pt;font-family:DejaVuSa= nsMono"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:8.0pt;font-family:"Cou= rier New"">psql: FATAL: Peer authentication failed for user &quo= t;postgres"<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:8.0pt;font-family:"Cou= rier New""><o:p> </o:p></span></p> <p class=3D"MsoNormal">Any suggestions would be appreciated.<o:p></o:p></p> <p class=3D"MsoNormal"><o:p> </o:p></p> <p class=3D"MsoNormal"><b><span style=3D"font-size:10.0pt;font-family:"= ;Arial",sans-serif;color:#1E47A4">Sandy Berger </span></b><span style=3D"font-size:10.5pt;font-family:"Arial",sa= ns-serif;color:#444444"><o:p></o:p></span></p> <p class=3D"MsoNormal"><i><span style=3D"font-size:10.0pt;font-family:"= ;Arial",sans-serif;color:#434D5B">IT - EUX</span></i><span style=3D"fo= nt-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p= p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.5pt;font-family:"Ar= ial",sans-serif;color:#434D5B"> </span><span style=3D"font-size:1= 0.5pt;font-family:"Arial",sans-serif;color:#444444"><o:p></o:p></= span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:"Ar= ial",sans-serif;color:#434D5B">Sussex, Wisconsin</span><span style=3D"= font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><o= :p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:"Ar= ial",sans-serif;color:#434D5B">414.566.2123 phone</span><span style=3D= "font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444"><= o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:"Ar= ial",sans-serif;color:#434D5B">414.566.4010/2123 pager/PIN</span><span= style=3D"font-size:10.5pt;font-family:"Arial",sans-serif;color:#= 444444"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.5pt;color:black"> <= /span><span style=3D"font-size:10.5pt;font-family:"Arial",sans-se= rif;color:#444444"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:"Ar= ial",sans-serif;color:black"><a href=3D"mailto:sandy.berger@qg.com"><s= pan style=3D"color:blue">sandy.berger@qg.com</span></a></span><span style= =3D"font-size:10.5pt;font-family:"Arial",sans-serif;color:#444444= "><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Arial",sans-se= rif;color:black"><a href=3D"http://www.qg.com/"><span style=3D"font-size:10= .0pt;color:blue">www.QG.com</span></a></span><span style=3D"font-size:10.5p= t;font-family:"Arial",sans-serif;color:#444444"><o:p></o:p></span=
</p> <p class=3D"MsoNormal"><o:p> </o:p></p> </div> Follow Us: <a href=3D"http://www.qg.com/social1">Facebook</a> | <a href=3D"= http://www.qg.com/social2"> Twitter</a> | <a href=3D"http://www.qg.com/social3">LinkedIn</a> | <a href= =3D"http://www.qg.com/social4"> YouTube</a> </body> </html>
--_000_DM5PR05MB316109DAF0F0DE0E2753E1E3D5300DM5PR05MB3161namp_--