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 < [email protected]> 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 <[email protected]> wrote: > >> Would it make sense to make the file read-only and see if a write error >> pops up somewhere? >> >> Fred >> >> >>> Nghia Truong <[email protected]> 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 <[email protected]> wrote: >> >>> Chef/Puppet? >>> >>> >>> On Fri, May 3, 2013 at 10:28 AM, Ray Stell <[email protected]> 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. >>>> >>> >>> >> >
