Re: pg_hba.conf file

Hi,

Try putting ip address of the system from which you are connecting to
database.

If A is the m/c from which you are connecting to the m/c B on which the
postgres is running,put entry into the pg_hba.conf file for the m/c A.
pg_hba.conf file resides mostly in /var/lib/pgsql/data directory(where
/var/lib/pgsql is the home directory for postgres user).It may happen that
you may have pg_hba.conf file in another directory also but editing that
files wont help you.

Bye...

Milind
----- Original Message -----
From: Robinson, Marlena CECOM RDEC I2WD
<Marlena(dot)Robinson(at)mail1(dot)monmouth(dot)army(dot)mil>
To: 'PGSQL Admin' <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, August 17, 2000 11:11 PM
Subject: [ADMIN] pg_hba.conf file

>
>
> 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
>
>
>
>