From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | acchung(at)mit(dot)edu |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Missing or Erroneous pg_hba.conf file |
Date: | 2002-06-26 00:49:12 |
Message-ID: | Pine.LNX.4.21.0206260145370.14254-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 25 Jun 2002 acchung(at)mit(dot)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(at)E52BPS588R /
> $ pg_ctl reload -D /usr/share/postgresql/data
> postmaster successfully signaled
>
> THen when i typed in psql template1, i get
>
> postgres(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Ellis | 2002-06-26 00:58:52 | New dia2sql Made |
Previous Message | acchung | 2002-06-25 22:09:39 | Missing or Erroneous pg_hba.conf file |