Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf

From: azwa(at)nc(dot)com(dot)my
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_hba.conf
Date: 2004-03-10 05:39:10
Message-ID: OF2F1D3684.13B79723-ONFFFFFF81.003A5893@nc.com.my (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)postgresql(dot)org
Sent by: pgsql-sql-owner(at)postgresql(dot)org
12:12 PM Today

        To:     pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org)

pgsql-sql by date

Next:From: azwaDate: 2004-03-10 06:17:31
Subject: Database reporting tool
Previous:From: Bruno Wolff IIIDate: 2004-03-10 04:52:09
Subject: Re: correlated multi-set update?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group