Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem: pg_hba.conf is automatically rewritten every day - Mailing list pgsql-admin

From Prashanth Goriparthi
Subject Re: Problem: pg_hba.conf is automatically rewritten every day
Date
Msg-id CA+Mf8bVyb-bpAFJ5eD=r5yf_=aZjO=RceDZVoOstdkyWOGf7iA@mail.gmail.com
Whole thread Raw
In response to Re: Problem: pg_hba.conf is automatically rewritten every day  ("Fred Parkinson" <FredP@abag.ca.gov>)
Responses Re: Problem: pg_hba.conf is automatically rewritten every day  (Nghia Truong <nghiatruong.vn@gmail.com>)
List pgsql-admin
Tree view
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@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.vn@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 <johnnydtan@gmail.com> wrote:
Chef/Puppet?


On Fri, May 3, 2013 at 10:28 AM, Ray Stell <stellr@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.



pgsql-admin by date:

Previous
From: "Fred Parkinson"
Date:
Subject: Re: Problem: pg_hba.conf is automatically rewritten every day
Next
From: matthias ritzkowski
Date:
Subject: Best practice to create a read-only user?