Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41024=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UYIWt-0000YS-2b
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 May 2013 16:08:15 +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+M41024=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UYIWs-0003GM-HV
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 May 2013 16:08:14 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UYIWr-0003FJ-7y
	for pgsql-admin@postgresql.org; Fri, 03 May 2013 16:08:13 +0000
Received: from mail2.reptiles.org ([198.96.210.226])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UYIWo-000613-JI
	for pgsql-admin@postgresql.org; Fri, 03 May 2013 16:08:12 +0000
Received: from localhost by mailbox.reptiles.org
	via sendmail with STDIO (2631 bytes) (sender: <jim@reptiles.org>)
	(ident <jim> using UNIX) id <m1UYIWm-000tAiC@mailbox.reptiles.org>
	for <pgsql-admin@postgresql.org>;
	Fri, 3 May 2013 12:08:08 -0400 (EDT)
	(Smail-3.2.0.121 2005-Nov-17 #10 built 2010-Jul-16)
Date: Fri, 3 May 2013 12:08:08 -0400
From: Jim Mercer <jim@reptiles.org>
To: Nghia Truong <nghiatruong.vn@gmail.com>
Cc: Johnny Tan <johnnydtan@gmail.com>, Ray Stell <stellr@vt.edu>,
	pgsql-admin@postgresql.org
Subject: Re: Problem: pg_hba.conf is automatically rewritten every
 day
Message-ID: <20130503160808.GA37995@reptiles.org>
References: 
 <CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com>
	<DF565F16-FAE9-4C0E-84C2-CE70EF707381@vt.edu>
	<CABMVzL2B358Va8WVeGmUKGg2HVMjFF2EUUf0mMSFZzoG7Ha-ig@mail.gmail.com>
	<CAHD-CS3Qo+TDg5uHM6F8nBPU+ZG7BJm24HXR_47TPyrPiZVhAg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAHD-CS3Qo+TDg5uHM6F8nBPU+ZG7BJm24HXR_47TPyrPiZVhAg@mail.gmail.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -4.5 (----)
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

On Fri, May 03, 2013 at 10:59:09PM +0700, Nghia Truong wrote:
> Hi all,
> I am the root user (except that my dedicated server is under the control of
> its company). I don't have any sysadmin script. The problem just suddenly
> occurs. I don't know why?

as best i know, with the standard postgresql installations, there is no
component that modifies the pg_hba.conf file.

from the systems perspective, it is a static config file, like postgresql.conf

some external script/facility/action is updating your pg_hba.conf file,
and that external script/facility/action is likely unique to your environment,
os installation, server management facilities.

if the timestamp of the file is being set to the same time every day, you
might check the following files:
(may or may not be on your system)

/etc/crontab
/etc/cron.d/*
/var/cron/crontab/*
/var/spool/cron/crontab/*

grep for the timestamp in:
/var/log/cron*
/var/log/auth* (remote system automatically doing sysadmin via ssh?)

--jim






> 
> ----------------------------------------------------
> 
> Nghia T. Truong
> 
> 
> 
> On Fri, May 3, 2013 at 10:52 PM, Johnny Tan <johnnydtan@gmail.com> wrote:
> 
> > Chef/Puppet?
> >
> >
> > On Fri, May 3, 2013 at 10:28 AM, Ray Stell <stellr@vt.edu> wrote:
> >
> >>
> >> On May 3, 2013, at 9:45 AM, Nghia Truong wrote:
> >>
> >> Hi everyone,
> >> Every day, the file pg_hba.conf in my server is rewritten and postgresql received
> >> a SIGHUP to reload configuration.
> >>
> >>
> >> Sounds like some sysadmin scripted rsync gone wild.
> >>
> >
> >

-- 
Jim Mercer     Reptilian Research      jim@reptiles.org    +1 416 410-5633
"He who dies with the most toys is nonetheless dead"


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin