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