Error attempting to create dwh readonly user

26 Mar 2017

      --_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_--

Berger, Sandy

Yedidyah Bar David

Berger, Sandy

Yedidyah Bar David

tags

participants (2)