That's easy. You need to add an entry to the pg_hba.conf file that looks something like
host all 192.168.100.0 255.255.255.0 trust
and restart the the postmaster. It says "There are hosts, who can connect to all databases, whose ip addresses are
192.168.100.x,with a netmask of 255.255.255.0, who I will trust to connect with no password or other authentication."
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org
>>> "Jillian Carroll" <jillian@koskie.com> 04/10/02 09:53AM >>>
I'm getting the error:
no pg_hba.conf entry for host (IP), user (user), database (db)
I'm new to this and not really sure where to begin with this file...
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Ian Harding
Sent: April 10, 2002 10:53 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PGAdmin
I installed it last night on XP and it worked great, but gave a harmless
error when I clicked directly on the Tables node in the tree. I haven't
reported it yet either... I was very impressed with it, though.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org
>>> Devrim GUNDUZ <devrim@oper.metu.edu.tr> 04/10/02 09:40AM >>>
hi,
On Wed, 10 Apr 2002, Jillian Carroll wrote:
> Has anybody had any problems with PGAdmin II? Anything I should watch out
> for?
Today, I installed pgadminII on an XP. I could connect to the server,
however, when I click on "databases", I see a runtime error... Could not
report it to the developers yet.
Best regards,
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
