Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41018=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UYGuy-0001FH-49
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 May 2013 14:25:00 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41018=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UYGux-0004MK-GD
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 May 2013 14:24:59 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <verissimorpinfo@gmail.com>) id 1UYGuw-0004ME-5n
	for pgsql-admin@postgresql.org; Fri, 03 May 2013 14:24:58 +0000
Received: from mail-gh0-f181.google.com ([209.85.160.181])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <verissimorpinfo@gmail.com>) id 1UYGus-0004Ca-NQ
	for pgsql-admin@postgresql.org; Fri, 03 May 2013 14:24:57 +0000
Received: by mail-gh0-f181.google.com with SMTP id z12so275613ghb.40
	for <pgsql-admin@postgresql.org>; Fri, 03 May 2013 07:24:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:from:to:references:in-reply-to:subject:date:message-id
	:mime-version:content-type:x-mailer:content-language:thread-index;
	bh=abZppx0aOJ5lxtl9OrILjcad4WLjnWdfJDOocrCWXRk=;
	b=NYIwXSPs5DaUKnU9F9iSwCipmx+4NvnWONzqi0vkPRy8Fa91rEYkfBPl1YILI6Tzvd
	DPVVIoR4do7SshForfRgePwdZ2wXxnhU0w06eGJLTAaPgIO4+83nbTYPPXm22HVPNKpR
	JnWkAvyxosNc5Zg59Bq26hng5wJPXoIESKX9of70mC48TCYaEe2nJIaHeMjseHqlJD9e
	Xo1BVcSJMIEmCzEkg0A6by6gvCHAFBS2CeTcS1ONebtkd+l2sgrR4MbtIKm8TPTLkJ8q
	UOiF5IR1ooyG6ddnuNklfFQ4DgoWocsDAKWgajQxHOw3YuxoVEDloTCb7pYZxTkoY2Ws
	zbjA==
X-Received: by 10.236.203.116 with SMTP id e80mr9262721yho.109.1367591093734;
	Fri, 03 May 2013 07:24:53 -0700 (PDT)
Received: from verissimoPC ([187.58.191.43])
	by mx.google.com with ESMTPSA id n15sm21587856yhi.2.2013.05.03.07.24.51
	for <multiple recipients>
	(version=TLSv1 cipher=RC4-SHA bits=128/128);
	Fri, 03 May 2013 07:24:52 -0700 (PDT)
From: "Marcelo Verissimo" <verissimorpinfo@gmail.com>
To: "'Nghia Truong'" <nghiatruong.vn@gmail.com>, <pgsql-admin@postgresql.org>
References: 
 <CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com>
In-Reply-To: 
 <CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com>
Subject: RES: Problem: pg_hba.conf is automatically rewritten every day
Date: Fri, 3 May 2013 11:24:51 -0300
Message-ID: <003301ce4809$fb4a9e40$f1dfdac0$@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0034_01CE47F0.D6009A90"
X-Mailer: Microsoft Outlook 14.0
Content-Language: pt-br
Thread-Index: AQD+7aoHD2h+ncNnDxt7yExqiJ8cdpqSNGQg
X-Pg-Spam-Score: -0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multipart message in MIME format.

------=_NextPart_000_0034_01CE47F0.D6009A90
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi , i dont expert in postrgres , but i'll checked why=20

This server reload configuration every day ?

after=20

Set permission the file on the her user  and check the application =
client , maybe has a new file or instrutions for rewritten

=20

may solv !

De: pgsql-admin-owner@postgresql.org =
[mailto:pgsql-admin-owner@postgresql.org] Em nome de Nghia Truong
Enviada em: sexta-feira, 3 de maio de 2013 10:45
Para: pgsql-admin@postgresql.org
Assunto: [ADMIN] Problem: pg_hba.conf is automatically rewritten every =
day

=20

Hi everyone,

Every day, the file pg_hba.conf in my server is rewritten and postgresql =
received a SIGHUP to reload configuration. The pg_hba.conf content is:

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

.......

......

local samerole all        md5  =20

host samerole all  127.0.0.1   255.255.255.255   md5  =20

local all postgres        md5  =20

host all postgres  127.0.0.1   255.255.255.255   md5 =20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=20

As a result, my application cannot connect remotely to the database on =
server. I have to manually modify the pg_hba.conf every day. I don't =
know why that happens? Is there any way to get rid of it?

Thank you very much for your help.

=20

=20

----------------------------------------------------

Nghia T. Truong


------=_NextPart_000_0034_01CE47F0.D6009A90
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-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=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta =
name=3DGenerator content=3D"Microsoft Word 14 (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:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Lucida Handwriting";
	panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","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;}
p
	{mso-style-priority:99;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
span.gingersofatwarecorrect
	{mso-style-name:ginger_sofatware_correct;}
span.gingersofatwarenosuggestion
	{mso-style-name:ginger_sofatware_nosuggestion;}
span.EstiloDeEmail20
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 3.0cm 70.85pt 3.0cm;}
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=3DPT-BR link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span =
lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Hi , i dont expert in postrgres , but i'll checked why =
<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>This server reload configuration every day ?<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>after <o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Set permission the file on the her user=C2=A0 and check the =
application client , maybe has a new file or instrutions for =
rewritten<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>may solv !<o:p></o:p></span></p><p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De:</span></=
b><span style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> =
pgsql-admin-owner@postgresql.org =
[mailto:pgsql-admin-owner@postgresql.org] <b>Em nome de </b>Nghia =
Truong<br><b>Enviada em:</b> sexta-feira, 3 de maio de 2013 =
10:45<br><b>Para:</b> pgsql-admin@postgresql.org<br><b>Assunto:</b> =
[ADMIN] Problem: pg_hba.conf is automatically rewritten every =
day<o:p></o:p></span></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><span style=3D'font-family:"Verdana","sans-serif"'>Hi =
everyone,</span><o:p></o:p></p><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>Every day, the file =
pg_hba<span class=3Dgingersofatwarecorrect>.conf</span> in my server is =
rewritten and <span =
class=3Dgingersofatwarenosuggestion>postgresql</span>&nbsp;received a =
SIGHUP to reload configuration. The pg_hba<span =
class=3Dgingersofatwarecorrect>.</span><span =
class=3Dgingersofatwarenosuggestion>conf</span> content =
is:</span><o:p></o:p></p></div><div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div><div><p =
class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</span><o:p></o:p></p></div><div><p =
class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>.......</span><o:p></o:p></p=
></div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>......</span><o:p></o:p></p>=
</div><div><div><p class=3DMsoNormal><span =
class=3Dgingersofatwarecorrect><span =
style=3D'font-family:"Verdana","sans-serif"'>local</span></span><span =
style=3D'font-family:"Verdana","sans-serif"'> <span =
class=3Dgingersofatwarecorrect>samerole</span> all &nbsp; &nbsp; &nbsp; =
&nbsp;md5 &nbsp;&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span class=3Dgingersofatwarecorrect><span =
style=3D'font-family:"Verdana","sans-serif"'>host</span></span><span =
style=3D'font-family:"Verdana","sans-serif"'> <span =
class=3Dgingersofatwarecorrect>samerole</span> all &nbsp;127.0.0.1 =
&nbsp; 255.255.255.255 &nbsp; md5 =
&nbsp;&nbsp;<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
class=3Dgingersofatwarecorrect><span =
style=3D'font-family:"Verdana","sans-serif"'>local</span></span><span =
style=3D'font-family:"Verdana","sans-serif"'> all postgres &nbsp; &nbsp; =
&nbsp; &nbsp;md5 &nbsp;&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span class=3Dgingersofatwarecorrect><span =
style=3D'font-family:"Verdana","sans-serif"'>host</span></span><span =
style=3D'font-family:"Verdana","sans-serif"'> all <span =
class=3Dgingersofatwarenosuggestion>postgres</span> &nbsp;127.0.0.1 =
&nbsp; 255.255.255.255 &nbsp; md5 =
&nbsp;<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p>=
</div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>As a result, my application =
cannot connect remotely to the database on server. I have to manually =
modify the pg_hba<span class=3Dgingersofatwarecorrect>.conf</span> every =
day. I don't know why that happens? Is there any way to get rid of =
it?<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'>Thank you very much for =
your help.<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p>=
</div><div><p class=3DMsoNormal><span =
style=3D'font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p>=
</div><div><p class=3DMsoNormal><span style=3D'font-family:"Lucida =
Handwriting";color:#1F497D'>---------------------------------------------=
-------</span><span =
style=3D'font-family:"Verdana","sans-serif"'><o:p></o:p></span></p></div>=
</div><div><div><div><p><span style=3D'font-family:"Lucida =
Handwriting";color:#1F497D'>Nghia T. =
Truong</span><o:p></o:p></p></div></div></div></div></body></html>
------=_NextPart_000_0034_01CE47F0.D6009A90--