Error

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/

Browse pgsql-admin by date

  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