Postgresql broken with Red Hat 9?

Поиск
Список
Период
Сортировка
Искать

Postgresql broken with Red Hat 9?

От:
"panon" <panonst@eunet.yu>
Дата:
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?

От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
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?

От:
Kris Deugau <kdeugau@webhart.net>
Дата:
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
-- 
 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?

От:
Chris Travers <chris@travelamericas.com>
Дата:
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
>  
>

FAQ