Thread: pg_hba.conf

Hi,
 i try to connect to my database as $ psql dwnc biosadm  but got the error              "psql: FATAL:  No pg_hba.conf
entryfor host localhost, user
 
biosadm, database dwnc"
Below are the detail in pg_hba.conf
  # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
METHOD
     local                  all           all
trust     host                  all           all                   127.0.0.1
255.255.255.255     trust     host                 all            all              192.168.1.45
255.255.255.0      trust     host              dwnc        biosadm     192.168.1.45
255.255.255.0        trust



the line in bold has been deleted before i connect to database . then i
shutdown the database using following command :
pg_ctl -D /usr/local/pgsql/data stop -m fast

followed by startup database :
   postmaster -D /usr/local/pgsql/data > logg 2>&1  &

Does anybody know why does the above error  occur when trying to connect
database and try connect through client using pgadmin??? thanks in advance

<font face="Times New Roman" size="2">Hi,</font><br /><br /><font face="Times New Roman" size="2">   by the way i've
settlemy connection problem between client application and server itself . this is happen because of editing the
parameterin pg_hba.conf</font><br /><font face="Times New Roman" size="2">while the environment(database was running)
wasactive.  tq </font><br /><br /><br /><table width="100%"><tr valign="top"><td></td><td><div align="center"><font
face="sans-serif"size="2"><b>azwa@postgresql.org</b></font></div><div align="center"><br /><font face="sans-serif"
size="2">Sentby: pgsql-sql-owner@postgresql.org</font></div><div align="center"><p><font face="sans-serif"
size="2">12:12PM Today</font></div><div align="center"><br /></div></td><td><font face="sans-serif" size="2">       
To:       pgsql-sql@postgresql.org</font><br /><font face="sans-serif" size="2">        cc:        </font><br /><font
face="sans-serif"size="2">        Subject:        [SQL] pg_hba.conf</font></td></tr></table><br /><br /><font
face="CourierNew" size="2"><br /><br /> Hi,<br /><br />  i try to connect to my database as $ psql dwnc biosadm  but
gotthe error<br />               "psql: FATAL:  No pg_hba.conf entry for host localhost, user<br /> biosadm, database
dwnc"<br/> Below are the detail in pg_hba.conf<br /><br />   # TYPE  DATABASE    USER        IP-ADDRESS      
 IP-MASK<br/> METHOD<br /><br />      local                  all           all<br /> trust<br />      host            
    all           all                   127.0.0.1<br /> 255.255.255.255     trust<br />      host                 all  
        all              192.168.1.45<br /> 255.255.255.0      trust<br />      host              dwnc        biosadm  
 192.168.1.45<br /> 255.255.255.0        trust<br /><br /><br /><br /> the line in bold has been deleted before i
connectto database . then i<br /> shutdown the database using following command :<br /> pg_ctl -D /usr/local/pgsql/data
stop-m fast<br /><br /> followed by startup database :<br /><br />    postmaster -D /usr/local/pgsql/data > logg
2>&1 &<br /><br /> Does anybody know why does the above error  occur when trying to connect<br /> database
andtry connect through client using pgadmin??? thanks in advance<br /><br /><br /><br /><br /><br />
---------------------------(endof broadcast)---------------------------<br /> TIP 2: you can get off all lists at once
withthe unregister command<br />    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)<br
/></font><br/>