JDBC No jalan !!!!

[Israel Zavalza Bahena]

Posiblemente, el problemita no esta en los JDBC's sino el los sockets
Unix de postgresql...




doy esto  desde otra maquina ...


# psql -h icaro
Connection to database 'root' failed.
connectDB() failed: Is the postmaster running and accepting TCP/IP(with
-i) connections at 'icaro' on port '5432'?
# 




y para verificar, doy telnet desde otra maquina...



$ telnet zeus 5432
Trying 200.34.40.125...
telnet: Unable to connect to remote host: Connection refused
$ telnet icaro 5432
Trying 200.34.40.65...
telnet: Unable to connect to remote host: Connection refused
$ 



este es mi archivo de configuracion pg_hba localizado en
/usr/local/pgsql/data...


# The above would allow anyone anywhere except from 192.168.0.1 to
connect to
# any database under any username.

#host         all        192.168.0.0  255.255.255.0      ident    
omicron
#
# The above would allow users from 192.168.0.x hosts to connect to any
# database, but if e.g. Ident says the user is "bryanh" and he requests
to
# connect as Postgres user "guest1", the connection is only allowed if
# there is an entry for map "omicron" in pg_ident.conf that says
"bryanh" is 
# allowed to connect as "guest1".

# By default, allow anything over UNIX domain sockets and localhost.

local        all                                         trust
host         all         127.0.0.1     255.255.255.255   trust
host	     all	 0.0.0.0       255.255.255.255	 trust     




Estoy haciendo algo mal?    me falta algo? POR FAVOR  !!!!!!




gracias.











Israel Zavalza Bahena wrote:
> 
> Hola ...
> 
> tengo un problemita con los JDBC's para postgresql-6.3.2
> 
> Tengo ya compilado el programa en un RedHat y Solaris, corriendo el
> demonio de postmaster...
> 
> PERO, a la hora de querer probar la interfase java con los ejemplos,
> aparece el siguiente mensaje ...
> 
> # java example.psql jdbc:postgresql:regression postgres checo
> PostgreSQL psql example v6.3 rev 1
> 
> Connecting to Database URL = jdbc:postgresql:regression
> Exception caught.
> java.sql.SQLException: Connection failed: java.net.ConnectException:
> Connection refused
> java.sql.SQLException: Connection failed: java.net.ConnectException:
> Connection refused
>         at postgresql.Connection.<init>(Connection.java:190)
>         at postgresql.Driver.connect(Driver.java:87)
>         at java.sql.DriverManager.getConnection(DriverManager.java:91)
>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
>         at example.psql.<init>(psql.java:30)
>         at example.psql.main(psql.java:204)
> 
> Tengo otra maquina con Postgres 6.1 y Linux Slackware, y alli jalan los
> drivers sin problema....
> 
> alguna idea ?
> 
> Gracias.