| From: | "Marcelo Verissimo" <verissimorpinfo(at)gmail(dot)com> |
|---|---|
| To: | "'Nghia Truong'" <nghiatruong(dot)vn(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | RES: Problem: pg_hba.conf is automatically rewritten every day |
| Date: | 2013-05-03 14:24:51 |
| Message-ID: | 003301ce4809$fb4a9e40$f1dfdac0$@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] Em nome de Nghia Truong
Enviada em: sexta-feira, 3 de maio de 2013 10:45
Para: pgsql-admin(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray Stell | 2013-05-03 14:28:38 | Re: Problem: pg_hba.conf is automatically rewritten every day |
| Previous Message | matthias ritzkowski | 2013-05-03 14:03:02 | Best practice to create a read-only user? |