pg_hba.conf file
pg_hba.conf file
От:
"Robinson, Marlena CECOM RDEC I2WD"
<Marlena.Robinson@mail1.monmouth.army.mil>
Дата:
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
От:
"milind" <milind@bombay.retortsoft.com>
Дата:
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 To: 'PGSQL Admin' 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 > > > >