Try putting ip address of the system from which you are connecting to
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.
----- Original Message -----
From: Robinson, Marlena CECOM RDEC I2WD
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
> 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
> 3 questions remain:
> What should I do, how do I do it, and where is the postmaster log file?
In response to
pgsql-admin by date
|Next:||From: John Clark L. Naldoza||Date: 2000-08-18 07:30:08|
|Subject: Re: [GENERAL] I screwed it up, my installation :(|
|Previous:||From: AlphaByte||Date: 2000-08-18 05:02:34|
|Subject: I screwed it up, my installation :(|