| From: | Nghia Truong <nghiatruong(dot)vn(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Problem: pg_hba.conf is automatically rewritten every day |
| Date: | 2013-05-03 13:45:01 |
| Message-ID: | CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 | matthias ritzkowski | 2013-05-03 14:03:02 | Best practice to create a read-only user? |
| Previous Message | bricklen | 2013-05-02 22:25:05 | Re: Copy one database to another server |