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 < gprashanthku...@gmail.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 <fr...@abag.ca.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...@gmail.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 <johnnyd...@gmail.com> wrote: >> >>> Chef/Puppet? >>> >>> >>> On Fri, May 3, 2013 at 10:28 AM, Ray Stell <ste...@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. >>>> >>> >>> >> >