Re: Missing or Erroneous pg_hba.conf file

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(at)ontko(dot)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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of acchung(at)mit(dot)edu
> Sent: Tuesday, June 25, 2002 5:10 PM
> To: pgsql-admin(at)postgresql(dot)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(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.
>
> Alex
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>