X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C5AA5D1DCD8 for ; Wed, 10 Mar 2004 04:35:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51325-07 for ; Wed, 10 Mar 2004 00:35:46 -0400 (AST) Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131]) by svr1.postgresql.org (Postfix) with ESMTP id 537B0D1BA93 for ; Wed, 10 Mar 2004 00:35:45 -0400 (AST) Subject: pg_hba.conf To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999 Message-ID: From: azwa@nc.com.my Date: Wed, 10 Mar 2004 12:12:39 +0800 X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22, 2000) at 03/10/2004 12:12:42 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/97 X-Sequence-Number: 17196 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