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

From Marcelo Verissimo
Subject RES: Problem: pg_hba.conf is automatically rewritten every day
Date
Msg-id 003301ce4809$fb4a9e40$f1dfdac0$@gmail.com
Whole thread Raw
In response to Problem: pg_hba.conf is automatically rewritten every day  (Nghia Truong <nghiatruong.vn@gmail.com>)
List pgsql-admin

Hi , i dont expert in postrgres , but i'll checked why

This server reload configuration every day ?

after

Set permission the file on the her user  and check the application client , maybe has a new file or instrutions for rewritten

 

may solv !

De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@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 rewritten and postgresql received a SIGHUP to reload configuration. The pg_hba.conf content is:

 

=============================================

.......

......

local samerole all        md5   

host samerole all  127.0.0.1   255.255.255.255   md5   

local all postgres        md5   

host all postgres  127.0.0.1   255.255.255.255   md5  

=============================================

 

As a result, my application cannot connect remotely to the database on server. I have to manually modify the pg_hba.conf every day. I don't know why that happens? Is there any way to get rid of it?

Thank you very much for your help.

 

 

----------------------------------------------------

Nghia T. Truong

pgsql-admin by date:

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