Обсуждение: BUG #1211: JDBC connection

The following bug has been logged online:

Bug reference:      1211
Logged by:          Diego

Email address:      netmaniac@libero.it

PostgreSQL version: 7.5 Dev

Operating system:   win xp pro

Description:        JDBC connection

Details:

I'm unable to connect to my 8.0 beta1 from JDBC, even remote or local
connection.
I'have try to edit postgresql.conf, setting listen_address='*' and
pg_hba.conf but the error is always :
org.postgresql.util.PSQLException: Con
nessione rifiutata. Controllare che il nome dell'host e la porta siano
corretti, e che il server (po
stmaster) Þ in esecuzione con l'opzione -i, che abilita le connessioni
attraverso la rete TCP/IP.

With psql the connection is ok.

----

On my italian windows version postgres report a Warning log event, the Event
Viewer say:
WARNING: could not find a match for Windows timezone "ora solare Europa
occidentale"

On Wed, 11 Aug 2004, PostgreSQL Bugs List wrote:

> Bug reference:      1211
> Email address:      netmaniac@libero.it
> PostgreSQL version: 7.5 Dev
> Operating system:   win xp pro
> Description:        JDBC connection
>=20
> I'm unable to connect to my 8.0 beta1 from JDBC, even remote or local=20
> connection.=20
> I'have try to edit postgresql.conf, setting listen_address=3D'*' and=20
> pg_hba.conf but the error is always :=20
> org.postgresql.util.PSQLException: Con
> nessione rifiutata. Controllare che il nome dell'host e la porta siano=20
> corretti, e che il server (po=20
> stmaster) =C3=9E in esecuzione con l'opzione -i, che abilita le connessio=
ni=20
> attraverso la rete TCP/IP.=20

Did you restart postgresql after making the change to postgresql.conf?

> With psql the connection is ok.
>=20

Does it work when using the -h argument to psql?  By default psql does not=
=20
use tcpip to connect to the server.

Kris Jurka