From: | novnov <novnovice(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Connecting to a remote server, pg_hba.conf error? |
Date: | 2007-02-27 04:39:44 |
Message-ID: | 9175269.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Wonderful, that solved it...THANK YOU!
Douglas McNaught wrote:
>
> novnov <novnovice(at)gmail(dot)com> writes:
>
>> I am trying to connect to a postgres 8.1 installation on a ubuntu box
>> from
>> windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf
>> file
>> HINT see server log for details.
>>
>> The server ip address is 192.168.1.10. The workstation ip address is
>> 192.168.2.100. The server firewall allows connections on port 5432. I am
>> past the 'is the server open on port 5432?' errors, now it's 'missing or
>> erroneous pg_hba.conf'. I've added a line like this to that file:
>>
>> host all all 192.168.2.100 md5 (have tried trust also)
>
> I think you need a netmask on this IP:
>
> host all all 192.168.2.100/32 md5
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
View this message in context: http://www.nabble.com/Connecting-to-a-remote-server%2C-pg_hba.conf-error--tf3297991.html#a9175269
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2007-02-27 05:09:17 | Re: PostgreSQL 8.2.x and JDBC driver |
Previous Message | Douglas McNaught | 2007-02-27 03:29:49 | Re: Connecting to a remote server, pg_hba.conf error? |