From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | <acchung(at)mit(dot)edu>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Missing or Erroneous pg_hba.conf file |
Date: | 2002-06-26 14:04:32 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGMEHCFDAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-26 14:54:31 | Re: Missing or Erroneous pg_hba.conf file |
Previous Message | Tom Lane | 2002-06-26 13:42:23 | Re: Help to restore lost database |