Re: How to allow a JDBC to connect to my postgres databa

Yes you have to setup postgres to accept connections from other machines, if
I remember you need
to start it with a "-i" option. You also have to allow connections in the
config files.

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of brew(at)theMode(dot)com
Sent: Monday, November 08, 2004 2:30 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] How to allow a JDBC to connect to my postgres database

> Is there any crucial step for allowing a JDBC and remote hosts to
> connect to database. Please suggest some pointers or documentation.

From the faq:

3.5) How do I control connections from other hosts?

By default, PostgreSQL only allows connections from the local machine using
Unix domain sockets or TCP/IP connections. Other machines will not be able
to connect unless you modify listen_addresses in the postgresql.conf and
enable host-based authentication by modifying the file $PGDATA/pg_hba.conf
accordingly.

brew

==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
==========================================================================

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html