At the risk of stating the obvious, also check to make sure Postmaster
is listening on port 5432. To do this log in as root and run /sbin/fuser
-vn tcp 5432. If postmaster is not listed it may only be running with
unix sockets. This measn that you must pass the -i flag to postmaster
when it starts up.
Kris Deugau wrote:
>>I was using Postgres 7.3.2 and later 7.3.3 on Red Hat 8 and everyhing
>>worked fine. Yesterday we upgraded to Red Hat 9 (with 7.3.3 shipped)
>>and since then I can't connect through TCP/IP to database. I am using
>>latest ODBC drivers. Has Red Hat broken something in this release. I
>>tried putting Postgres' RPMS instead of Red Hat's but it didn't work
>>either. Thx in advance.
>Check your firewall; RedHat has locked things down even tighter with
>RH9. Check the hosts.(allow|deny) files too.
In response to
pgsql-admin by date
|Next:||From: Renney Thomas||Date: 2003-07-21 22:11:15|
|Subject: Replication/Failover/HA solution|
|Previous:||From: Kris Deugau||Date: 2003-07-21 21:21:50|
|Subject: Re: Postgresql broken with Red Hat 9?|