Обсуждение: Postgresql broken with Red Hat 9?
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
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
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.
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 > >