Hi, i try to connect to my database as $ psql dwnc biosadm but got the error "psql: FATAL: No pg_hba.conf entry for 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])