Re: pg_hba.conf - Mailing list pgsql-sql

From azwa@nc.com.my
Subject Re: pg_hba.conf
Date
Msg-id OF2F1D3684.13B79723-ONFFFFFF81.003A5893@nc.com.my
Whole thread Raw
In response to pg_hba.conf  (azwa@nc.com.my)
List pgsql-sql
<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/> 

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: correlated multi-set update?
Next
From: azwa@nc.com.my
Date:
Subject: Database reporting tool