pg_hba.conf

From: azwa(at)nc(dot)com(dot)my
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_hba.conf
Date: 2004-03-10 04:12:39
Message-ID: OF670CE485.A3CDBC3D-ON48256E53.00170751@nc.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2004-03-10 04:52:09 Re: correlated multi-set update?
Previous Message Stephan Szabo 2004-03-10 02:17:04 Re: Converting query to view - duplicate fields