Re: TCP/IP connection problem - Mailing list pgsql-admin

From Jari Vauhkonen
Subject Re: TCP/IP connection problem
Date
Msg-id 1161880559.4540e3ef28106@wwwmail.joensuu.fi
Whole thread Raw
In response to Re: TCP/IP connection problem  (Ben Suffolk <ben@vanilla.net>)
List pgsql-admin
Quoting Ben Suffolk <ben@vanilla.net>:
>
>
> I suggest you try and connect from the pgsql machine locally using
> tcp :-
>
>  > psql -h = same.host.as.configured.from.windows.box -p = 5432  db user
>
> Then we can see if the problem still lies with pgsql, or with the
> firewall.
>

Ben,

All right. Now it works.

I tested your suggestion and found out from logfiles that my pg_hba.conf file
was quite corrupted ( i.e. invalid IP masks ) . I re-arranged the file, tested,
re-arranged again... and finally, it works.

Thanks to everyone who helped. I hope all of you didn't get too annoyed with all
these "PRESS ANYKEY" - "Hey, where's the anykey???" -styled questions of mine.

Jari

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres timestamps are out by one hour
Next
From: "Jim C. Nasby"
Date:
Subject: Re: CLUSTER using more memory than expected