Re: Missing or Erroneous pg_hba.conf file

On Tue, 25 Jun 2002 acchung@mit.edu wrote:

> Hi,
> I was trying to alter my pg_hba.conf file so that I could
> take off trust and use passwords.  I edited it inside wordpad
> and saved it but it gave me some warning that said I'm saving it in Text-Only
> format and that would remove all formatting. Not know how else to save,
> i clicked ok.  then i read that i needed to send a SIGHUP signal for the
> postmaster to recognize the editted files.  I typed in
>
> pg_ctl reload -D /usr/share/postgresql/data
>
>
> postgres@E52BPS588R /
> $ pg_ctl reload -D /usr/share/postgresql/data
> postmaster successfully signaled
>
> THen when i typed in psql template1, i get
>
> postgres@E52BPS588R /
> $ psql template1
> psql: FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log for de
> tails
>
> How do I get my pg_hba.conf file back to normal?  Also in the future,
> how should i send my SIGHUP signal , because my command is not correct.
> PLEASE HELP QUICK!
> thank you.

Did wordpad perhaps automatically add a .txt extension? Did you take a look at
the new pg_hba.conf file and the postmaster log file to see what the error is
and whether this loss of formating is actually significant?

I would have thought the loss of formating was just refering to fancy formating
rather than text stuff so I would guess that it's either the name or you made
an error of some sort.



--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants