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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, June 25, 2002 5:10 PM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
