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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
