Re: Missing or Erroneous pg_hba.conf file - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: Missing or Erroneous pg_hba.conf file
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMEHCFDAA.nickf@ontko.com
Whole thread Raw
In response to Missing or Erroneous pg_hba.conf file  (acchung@mit.edu)
List 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@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
>
>




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help to restore lost database
Next
From: Tom Lane
Date:
Subject: Re: Missing or Erroneous pg_hba.conf file