Thread: pg_hba.conf file

pg_hba.conf file

From
"Robinson, Marlena CECOM RDEC I2WD"
Date:

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




Re: pg_hba.conf file

From
"milind"
Date:
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.Robinson@mail1.monmouth.army.mil>
To: 'PGSQL Admin' <pgsql-admin@postgresql.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
>
>
>
>