From: Marcelo Verissimo <verissimorpinfo@gmail.com>
To: 'Nghia Truong' <nghiatruong.vn@gmail.com>
To: pgsql-admin@postgresql.org
Subject: RES: Problem: pg_hba.conf is automatically rewritten every day
Date: Fri, 3 May 2013 11:24:51 -0300
Message-ID: <003301ce4809$fb4a9e40$f1dfdac0$@gmail.com> (raw)
In-Reply-To: <CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com>
References: <CAHD-CS2ZJ2pTxV8TZ9ACBGxGGbN4=Eg2FopyfZ=Yp=bZP9cb=w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: verissimorpinfo@gmail.com, nghiatruong.vn@gmail.com
Subject: Re: RES: Problem: pg_hba.conf is automatically rewritten every day
In-Reply-To: <003301ce4809$fb4a9e40$f1dfdac0$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox