From: azwa@nc.com.my
To: pgsql-sql@postgresql.org
Subject: Re: pg_hba.conf
Date: Wed, 10 Mar 2004 13:39:10 +0800
Message-ID: <OF2F1D3684.13B79723-ONFFFFFF81.003A5893@nc.com.my> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: azwa@nc.com.my
Subject: Re: pg_hba.conf
In-Reply-To: <OF2F1D3684.13B79723-ONFFFFFF81.003A5893@nc.com.my>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox