Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Nghia Truong
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.

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Prashanth Goriparthi
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 wrote: > Wou

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Fred Parkinson
Would it make sense to make the file read-only and see if a write error pops up somewhere? Fred >>> Nghia Truong 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 suddenl

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Jim Mercer
On Fri, May 03, 2013 at 10:59:09PM +0700, Nghia Truong wrote: > 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? as best i know, with the standard postgresql

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Nghia Truong
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 T

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Johnny Tan
Chef/Puppet? On Fri, May 3, 2013 at 10:28 AM, Ray Stell 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

Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Ray Stell
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.

RES: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Marcelo Verissimo
l.org [mailto:pgsql-admin-ow...@postgresql.org] Em nome de Nghia Truong Enviada em: sexta-feira, 3 de maio de 2013 10:45 Para: pgsql-admin@postgresql.org Assunto: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day Hi everyone, Every day, the file pg_hba.conf in my server is rewritte

[ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Nghia Truong
Hi everyone, Every day, the file pg_hba.conf in my server is rewritten and postgresql received a SIGHUP to reload configuration. The pg_hba.conf content is: = ... .. local samerole allmd5 host samerole all 127.0.0.1 255.255.255.255 m