Thread: How to allow a JDBC to connect to my postgres database

How to allow a JDBC to connect to my postgres database

From
Kumar S
Date:
Dear group,
  my collaborator wants to connect his java
application to my database using JDBC.  He is facing
problems in connecting to the database and reports
'port problems'.

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

Thank you,

Kumar



__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com



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

From
brew@theMode.com
Date:
> 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@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================