pg_hba.conf file - Mailing list pgsql-admin

From Robinson, Marlena CECOM RDEC I2WD"
Subject pg_hba.conf file
Date
Msg-id D1EF46E76E48D411A74F0008C7CF48111E7B40@I2WD_CINDY
Whole thread Raw
List pgsql-admin

hey I think I nuked my DB,  can someone help?

Being the novice that I am (to put it lightly) I was messing around and
exploring files and I happened upon the file in subject line. I moved a #
sign, and saved. then I changed my mind about my bold little move and I put
it back, and saved again. I swear that is all I did.

I thought all was fine, but then when I went to: createdb [name]
or went to connect by typing : psql [name]

I get the following error:

Connection to database '[name]' failed.
Missing or erroneous pg_hba.conf file, see postmaster log for details.

I have wiped out all packages and re-installed the rpms from the disk, I
have overwritten all files, the last resort would be wiping out the Linux
install (I am of the windows generation) and putting 6.1 on all over again.

3 questions remain:

What should I do, how do I do it, and where is the postmaster log file?

Marlena




pgsql-admin by date:

Previous
From: Patrick Aland
Date:
Subject: User question
Next
From: "milind"
Date:
Subject: Re: pg_hba.conf file