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 > >