Обсуждение: Missing or Erroneous pg_hba.conf file

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.

Alex

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

Alex

It sounds like perhaps you were using a windows editor?? You were correct to
tell it you want no formatting, but I'd guess that even in text-only mode,
your file got saved with DOS/Windows EOL markers, rendering it unreadable on
your Unix box.

I'll send a plain vanilla pg_hba.conf to you off-list, and you can use it as
a starting point to edit again, (using a unix editor this time <grin>). Or
alternately, you can probably use a dos->unix filter on the old file.

Regards,

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of acchung@mit.edu
> Sent: Tuesday, June 25, 2002 5:10 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Missing or Erroneous pg_hba.conf file
>
>
> 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.
>
> Alex
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>

"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> On Tue, 25 Jun 2002 acchung@mit.edu wrote:
>> How do I get my pg_hba.conf file back to normal?

> Did wordpad perhaps automatically add a .txt extension?

I'm betting it added CR/LF (\r\n) newlines.  A quick look at the sources
shows that PG does not like \r in pg_hba.conf.  I've made it more
forgiving for 7.3, but for now, you'd better resave with Unix-style
newlines (\n only).

            regards, tom lane

At 05:49 PM 6/25/02 , Nigel J. Andrews wrote:
>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?

Or did it replace the newline characters (0x0a) with carriage return/line
feed pairs (0x0a/0x0d)?


         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona   85016-3228