Thread: Postgresql broken with Red Hat 9?

Postgresql broken with Red Hat 9?

From
"panon"
Date:
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.
 
Dragan
 

Re: Postgresql broken with Red Hat 9?

From
Sam Barnett-Cormack
Date:
Have you correctly set postgres.conf to allow tcp/ip connection, and
pg_hba to allow them from the correct machines?

On Mon, 7 Jul 2003, panon 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.
>
> Dragan
>
>

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

Re: Postgresql broken with Red Hat 9?

From
Kris Deugau
Date:
panon 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.

-kgd
--
<erno> hm. I've lost a machine.. literally _lost_. it responds to
ping, it works completely, I just can't figure out where in my
apartment it is.

Re: Postgresql broken with Red Hat 9?

From
Chris Travers
Date:
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:

>panon 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.
>
>-kgd
>
>