Re: Is Postgres broken in Red Hat 9?

On Tue, 8 Jul 2003, Dragan Matic wrote:

> Hi, there is a small problem here I have, I would appreciate any
> suggestion.
>
> We were using Postgres 7.2.x and later 7.3.x under Red Hat 8, and
> everything worked fine. Clients are working under windows and are
> communicating to Postgres via ODBC. This weekend we tried to upgrade to
> Red Hat 9 (and PG 7.3.3 shipped with it), but we just couldn't connect
> to server through ODBC. Postgres starts fine, I can access it through
> psql, but we simply can't access it from client machines. It is
> configured properly (it should accept tcp/ip connections, and
> appropriate rights are given). I simply can't find what is going wrong.
> I even trien putting older (Postgres made) rpms, but the problem
> persists. Are there any similar experiences, is this a RedHat bug, has
> it closed something somehow, or where should I start looking? Tnx.

Can you connect to it locally by using your machine's IP address? I.e. if
your machine's eth0 sits on 10.0.0.2, does psql -h 10.0.0.2 work?

You may have a firewall setup to block all ports by default.
firewall-config or something like it was the name of the firewall config
util in 7.2.