Re: Problem: pg_hba.conf is automatically rewritten every day

From: Nghia Truong <nghiatruong(dot)vn(at)gmail(dot)com>
To: Prashanth Goriparthi <gprashanthkumar(at)gmail(dot)com>
Cc: Fred Parkinson <FredP(at)abag(dot)ca(dot)gov>, Johnny Tan <johnnydtan(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Ray Stell <stellr(at)vt(dot)edu>
Subject: Re: Problem: pg_hba.conf is automatically rewritten every day
Date: 2013-05-04 00:26:29
Message-ID: CAHD-CS34PKWLAtdSUczRe7WYuVjki1k=4+vc50qXNhdKngGBjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I have found the reason. It is due to an update of cpanel. According to its
author, to "automatically secures the pg_hba.conf file":
http://forums.cpanel.net/f354/cpanel-update-changed-pg_hba-conf-samerole-338982.html
Thank you very much.

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

Nghia T. Truong

On Fri, May 3, 2013 at 11:18 PM, Prashanth Goriparthi <
gprashanthkumar(at)gmail(dot)com> wrote:

> Look at the timestamp of when this file [pg_hba.conf] is updated and see
> if there is any correlation to system messages [/var/log/messages or
> equivalent of your kernel].
>
> Thanking you,
> Prashanth Kumar Goriparthi
> Mobile : 312 316 4396
>
>
> On Fri, May 3, 2013 at 10:13 AM, Fred Parkinson <FredP(at)abag(dot)ca(dot)gov> wrote:
>
>> Would it make sense to make the file read-only and see if a write error
>> pops up somewhere?
>>
>> Fred
>>
>> >>> Nghia Truong <nghiatruong(dot)vn(at)gmail(dot)com> 05/03/2013 8:59 AM >>>
>> 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?
>>
>> ----------------------------------------------------
>>
>> Nghia T. Truong
>>
>>
>>
>> On Fri, May 3, 2013 at 10:52 PM, Johnny Tan <johnnydtan(at)gmail(dot)com> wrote:
>>
>>> Chef/Puppet?
>>>
>>>
>>> On Fri, May 3, 2013 at 10:28 AM, Ray Stell <stellr(at)vt(dot)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.
>>>>
>>>
>>>
>>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2013-05-06 10:32:53 Re: pg_stat_tmp file
Previous Message Prashanth Goriparthi 2013-05-03 16:18:26 Re: Problem: pg_hba.conf is automatically rewritten every day