Thread: Opening postgres 5432 port

I can't access postegresl via ODBC, because 5432 port seems to be closed.
How can I open it?
I'm running postgres 7 on Redhat 7.2

Thanks

On 14 Oct 2002 at 10:57, Benny wrote:

> I can't access postegresl via ODBC, because 5432 port seems to be closed.
> How can I open it?
> I'm running postgres 7 on Redhat 7.2

Probably postgresql listening on that port has terminated. Restart the database
server..

Bye
 Shridhar

--
gossip, n.:    Hearing something you like about someone you don't.        -- Earl Wilson

On Monday 14 October 2002 04:57 am, Benny wrote:
> I can't access postegresl via ODBC, because 5432 port seems to be closed.
> How can I open it?
> I'm running postgres 7 on Redhat 7.2

IIRC Red Hat 7.2 shipped with PostgreSQL 7.1.3.  Thus, edit
/var/lib/pgsql/data/postgresql.conf to uncomment the line about tcpip_socket
and make it true instead of false.  Then restart with 'service postgresql
restart' (as root).  This replaces the need to edit the
/etc/init.d/postgresql script to add a '-i' to the pg_ctl line.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11