From: Allan Kamau <kamauallan@yahoo.com>
To: jesse@cks.co.za
To: pgsql-admin@postgresql.org
Subject: Error
Date: Tue, 1 Mar 2005 01:53:05 -0800 (PST)
Message-ID: <20050301095305.12112.qmail@web53504.mail.yahoo.com> (raw)
Be sure you've supplied the username, password and
database name when connecting, also check to see you
don't have a reject policy that may impede your
connection attempt.
Be sure to instruct postgresql to reload the
configuration files once you've modified the
pg_hba.conf file.
You may start by adding line similar to this at the
end of your pg_hba.conf file.
host all all
<your_client's_ip_address>/32 password
Where your_client's_ip_address will be the IP
address of the computer your attempting to connect to
PostgreSQL from, in your case it will be the computer
your running M$ Access from.
Allan.
--- Maritza Landsberg <jesse@cks.co.za> wrote:
> Hi
>
> I need help with the following error I am getting
> when trying to connect
> with Microsoft Access to my Postgresql database.
>
> FATAL 1: No host found in pg_hba.conf for IP
> address, database name,
> postgres user...
>
> I have changed the pg_hba.conf to include the IP
> address.
>
> Please could someone assist me with this?
>
> Thanks
>
> Maritza Landsberg
>
>
__________________________________
Do you Yahoo!?
Yahoo! Sports - Sign up for Fantasy Baseball.
http://baseball.fantasysports.yahoo.com/
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-admin@postgresql.org
Cc: kamauallan@yahoo.com, jesse@cks.co.za
Subject: Re: Error
In-Reply-To: <20050301095305.12112.qmail@web53504.mail.yahoo.com>
* 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