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 F36BED1DC2A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Mar 2004 06:02:19 +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 70977-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 10 Mar 2004 02:02:17 -0400 (AST)
Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131])
	by svr1.postgresql.org (Postfix) with ESMTP id CC65ED1DC6B
	for <pgsql-sql@postgresql.org>; Wed, 10 Mar 2004 02:02:15 -0400 (AST)
Subject: Re: pg_hba.conf
To: pgsql-sql@postgresql.org
X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999
Message-ID: <OF2F1D3684.13B79723-ONFFFFFF81.003A5893@nc.com.my>
From: azwa@nc.com.my
Date: Wed, 10 Mar 2004 13:39:10 +0800
X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22,
	2000) at 03/10/2004 01:39:13 PM,
	Serialize complete at 03/10/2004 01:39:13 PM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_alternative 0021155C48256E53_="
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/99
X-Sequence-Number: 17198

This is a multipart message in MIME format.
--=_alternative 0021155C48256E53_=
Content-Type: text/plain; charset="us-ascii"

Hi,

   by the way i've settle my connection problem between client application 
and server itself . this is happen because of editing the parameter in 
pg_hba.conf
while the environment(database was running) was active.  tq 




azwa@postgresql.org
Sent by: pgsql-sql-owner@postgresql.org
12:12 PM Today

        To:     pgsql-sql@postgresql.org
        cc: 
        Subject:        [SQL] 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 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 majordomo@postgresql.org)


--=_alternative 0021155C48256E53_=
Content-Type: text/html; charset="us-ascii"



<font size=2 face="Times New Roman">Hi,</font>
<br>
<br><font size=2 face="Times New Roman">&nbsp; &nbsp;by the way i've settle my connection problem between client application and server itself . this is happen because of editing the parameter in pg_hba.conf</font>
<br><font size=2 face="Times New Roman">while the environment(database was running) was active. &nbsp;tq </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td>
<div align=center><font size=2 face="sans-serif"><b>azwa@postgresql.org</b></font></div>
<div align=center>
<br><font size=2 face="sans-serif">Sent by: pgsql-sql-owner@postgresql.org</font></div>
<div align=center>
<p><font size=2 face="sans-serif">12:12 PM Today</font></div>
<div align=center>
<br></div>
<td><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; To: &nbsp; &nbsp; &nbsp; &nbsp;pgsql-sql@postgresql.org</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; cc: &nbsp; &nbsp; &nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; Subject: &nbsp; &nbsp; &nbsp; &nbsp;[SQL] pg_hba.conf</font></table>
<br>
<br><font size=2 face="Courier New"><br>
<br>
Hi,<br>
<br>
 &nbsp;i try to connect to my database as $ psql dwnc biosadm &nbsp;but got the error<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;psql: FATAL: &nbsp;No pg_hba.conf entry for host localhost, user<br>
biosadm, database dwnc&quot;<br>
Below are the detail in pg_hba.conf<br>
<br>
 &nbsp; # TYPE &nbsp;DATABASE &nbsp; &nbsp;USER &nbsp; &nbsp; &nbsp; &nbsp;IP-ADDRESS &nbsp; &nbsp; &nbsp; &nbsp;IP-MASK<br>
METHOD<br>
<br>
 &nbsp; &nbsp; &nbsp;local &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all<br>
trust<br>
 &nbsp; &nbsp; &nbsp;host &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 127.0.0.1<br>
255.255.255.255 &nbsp; &nbsp; trust<br>
 &nbsp; &nbsp; &nbsp;host &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;192.168.1.45<br>
255.255.255.0 &nbsp; &nbsp; &nbsp;trust<br>
 &nbsp; &nbsp; &nbsp;host &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dwnc &nbsp; &nbsp; &nbsp; &nbsp;biosadm &nbsp; &nbsp; 192.168.1.45<br>
255.255.255.0 &nbsp; &nbsp; &nbsp; &nbsp;trust<br>
<br>
<br>
<br>
the line in bold has been deleted before i connect to 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>
 &nbsp; &nbsp;postmaster -D /usr/local/pgsql/data &gt; logg 2&gt;&amp;1 &nbsp;&amp;<br>
<br>
Does anybody know why does the above error &nbsp;occur when trying to connect<br>
database and try connect through client using pgadmin??? thanks in advance<br>
<br>
<br>
<br>
<br>
<br>
---------------------------(end of broadcast)---------------------------<br>
TIP 2: you can get off all lists at once with the unregister command<br>
 &nbsp; &nbsp;(send &quot;unregister YourEmailAddressHere&quot; to majordomo@postgresql.org)<br>
</font>
<br>
--=_alternative 0021155C48256E53_=--