Re: problem connecting from JDBC

Ravi-

I'd suggest checking in postgresql.conf to make sure tcpip_socket is set to
on & also check pg_hba.conf to make sure the authorization info is set up to
allow local connections.

Take a look here for a more complete explanation:

http://www.fankhausers.com/postgresql/jdbc/welcome.html#tcpip


-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Ravi Kanth
> Sent: Monday, November 10, 2003 11:44 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] problem connecting from JDBC
>
>
> Hi,
> I am trying to access postgresql database (7.3.2 - that came by
> default with
> RedHat Linux 9 distro) using JDBC. I have a Linux user called
> "oracle" that
> I have created in postgresql also and gave that user privileges
> to create a
> database.
> I tried to create a databse using createdb and it works.
> The url that I am using in JDBC is:
> "jdbc:postgresql://localhost:5432/test",
> "oracle", "". It reverts bck with error that says:
> SQLException: Connection refused. Check that the hostname and port are
> correct and that the postmaster is accepting TCP/IP connections.
> I am using JDK 1.4.2 and NetBeans IDE.
> Can anyone plz help? Thanks.
>
> Ravi.
>
> _________________________________________________________________
> Compare high-speed Internet plans, starting at $26.95.
> https://broadband.msn.com (Prices may vary by service area.)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>