<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 11:04:37 Friday, 5 October 2012 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.3612670b-8da0-4d42-925a-3a891dad0e5d {
MARGIN: 0cm 0cm 0pt
}
LI.3612670b-8da0-4d42-925a-3a891dad0e5d {
MARGIN: 0cm 0cm 0pt
}
DIV.3612670b-8da0-4d42-925a-3a891dad0e5d {
MARGIN: 0cm 0cm 0pt
}
TABLE.3612670b-8da0-4d42-925a-3a891dad0e5dTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* 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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
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="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"></p>
<div class="WordSection1">
<p class="MsoNormal">Last night we did some hardware maintenance on a server running Postgresql 9.1.3.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On trying to restart the DB afterwards we got:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">LOG: peer authentication is only supported on local sockets<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">CONTEXT: line 86 of configuration file "/database/postgresql/pgsql/data/pg_hba.conf"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LOG: peer authentication is only supported on local sockets<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">CONTEXT: line 88 of configuration file "/database/postgresql/pgsql/data/pg_hba.conf"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">FATAL: could not load pg_hba.conf<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">/database/postgresql/pgsql being where we have the database instead of the default /var…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">As a test we attempted to restart postgresql setup similarly on a test server and saw exactly the same issue. The DBA at first blush found suggestion to use md5 startup rather than peer and it did start the DB but this morning we’re seeing
some batch processes failing.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Line 86 and 88 of the configuration file are the “localhost” IPs for IPV4 and IPV6 respectively. This file hasn’t been changed recently but it has been some months since the DB was last started previously.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone seen the above messages and do you have any suggestions as to how to resolve so that we’re not changing the start method?<o:p></o:p></p>
</div>
<p></p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"></p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font face="Arial"><font color="fuchsia"><font style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" size="2"></font></font></font> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font face="Arial"><font color="fuchsia"><font style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" size="2">Athena<font size="1">®</font>, Created for the Cause</font><font size="1">™
</font></font></font></p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font size="2" face="Arial">Making a Difference in the Fight Against Breast Cancer</font></p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font size="2" face="Arial"></font> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font size="2" face="Arial"></font> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font face="Arial"><font size="2"><strong>How and Why I Should Support Bottled Water!<br>
</strong>Do not relinquish your right to choose bottled water as a healthy alternative to beverages that contain sugar, calories, etc. Your support of bottled water will make a difference! Your signatures count! Go to
<a href="http://www.bottledwatermatters.org/luv-bottledwater-iframe/dswaters">http://www.bottledwatermatters.org/luv-bottledwater-iframe/dswaters</a> and sign a petition to support your right to always choose bottled water. Help fight federal and state issues,
such as bottle deposits (or taxes) and organizations that want to ban the sale of bottled water. Support community curbside recycling programs. Support bottled water as a healthy way to maintain proper hydration. Our goal is 50,000 signatures. Share this petition
with your friends and family today!</font></font></p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><font size="2" face="Arial"></font> </p>
<p class="3612670b-8da0-4d42-925a-3a891dad0e5d"><span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">---------------------------------<br>
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information
is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.<br>
----------------------------------</span><span style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt"><o:p></o:p></span></p>
<p> </p>
<p></p>
<p></p>
</body>
</html>