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