10:12 p.m.
--_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"=
<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=
></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:=
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_--