From: | Allan Kamau <kamauallan(at)yahoo(dot)com> |
---|---|
To: | jesse(at)cks(dot)co(dot)za, pgsql-admin(at)postgresql(dot)org |
Subject: | Error |
Date: | 2005-03-01 09:53:05 |
Message-ID: | 20050301095305.12112.qmail@web53504.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)cks(dot)co(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Dorian Büttner | 2005-03-01 11:16:01 | Re: Database Name |
Previous Message | Richard Sitompul | 2005-03-01 08:33:10 | Re: Whats the file extention for custom format in pg_dump |