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":
Thank you very much.
----------------------------------------------------
Nghia T. Truong
On Fri, May 3, 2013 at 11:18 PM, Prashanth Goriparthi <gprashanthkumar@xxxxxxxxx> 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 4396On Fri, May 3, 2013 at 10:13 AM, Fred Parkinson <FredP@xxxxxxxxxxx> wrote:Would it make sense to make the file read-only and see if a write error pops up somewhere?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@xxxxxxxxx> wrote:
Chef/Puppet?
On Fri, May 3, 2013 at 10:28 AM, Ray Stell <stellr@xxxxxx> 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.
