Greetings,
already I looked some people who work with postgresql in Brazil and not
obtained to explain me as to solve an error of connection gone off when my
applet tries to connect with postgreSQL. A detailed description of the
error is soon to follow:

Erro: java.net.ConnectException: Connection refused: connect
Erro: Conexão negada. Verifique se o nome da máquina e a porta estão
corretos e se o postmaster está aceitando conexões TCP/IP

I am using [ PostgreSQL 8 ] and the applet meets in the following address:
http://www.ufgen.ufg.br/krub/jsp/gra...Monitoramento/


PS: With the DB2 I did not have problems, however I am liking the form of
work with postgreSQL and if I not to obtain to decide this problem of
connection, go to have that to abandon postgreSQL.

In case that it will be possible to help me, I am describing still for its
analysis the archives [ pg_hba.conf ] and [ postgresql.conf ]



[pg_hba.conf]
....
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
local all postgres trust
host all postgres 127.0.0.1 255.255.255.255 trust
host all all 0.0.0.0/0 trust
# IPv6 local connections:
#host all all ::1/128 trust
....


[postgresql.conf]
....
listen_addresses = '*'
port = 5432
....

[Parameters that use to load the postmaster]
/usr/local/pgsql/bin/postmaster -i -p 5432 -o -e -D/usr/local/pgsql/data &

Leonardo.



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

http://www.postgresql.org/docs/faq

"Leonardo Ribeiro Queiros" <leonardo@eee.ufg.br> writes:

> analysis the archives [ pg_hba.conf ] and [ postgresql.conf ]
>
>
>
> [pg_hba.conf]
> ...
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> local all postgres trust
> host all postgres 127.0.0.1 255.255.255.255 trust
> host all all 0.0.0.0/0 trust
> # IPv6 local connections:
> #host all all ::1/128 trust


Your pg_hba.conf is missing a line that corresponds to the interface to the world
of the network card.

You should add a line for the subnet your computer is connected to, for example:

host all all 172.17.1.87 255.255.248.0 md5

This is for the connection from all computers in my subnet with md5 password-authentication.
If you do not use localhost as hostname in the connection string, this is needed even
for local connections.


--
Roland Walter mailto: rwa (at) mosaic-ag (dot) com
MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-41 1
Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1
D-53340 Meckenheim http://www.mosaic-ag.com


Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich
fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte,
vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger
oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung,
Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt.
Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte
unverzueglich den Absender und vernichten Sie die E-Mail.

This e-mail message and any attachment are intended exclusively for the named
addressee. They may contain confidential information which may also be protected
by professional secrecy. Unless you are the named addressee (or authorised to
receive for the addressee) you may not copy or use this message or any attachment
or disclose the contents to anyone else. If this e-mail was sent to you by mistake
please notify the sender immediately and delete this e-mail.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

>>[pg_hba.conf]
>>...
>># TYPE DATABASE USER CIDR-ADDRESS METHOD
>>
>># "local" is for Unix domain socket connections only
>>local all all trust
>># IPv4 local connections:
>>local all postgres trust
>>host all postgres 127.0.0.1 255.255.255.255 trust
>>host all all 0.0.0.0/0 trust
>># IPv6 local connections:
>>#host all all ::1/128 trust
>>
>>
>
>
>Your pg_hba.conf is missing a line that corresponds to the interface to the world
>of the network card.
>
>You should add a line for the subnet your computer is connected to, for example:
>
>host all all 172.17.1.87 255.255.248.0 md5
>
>This is for the connection from all computers in my subnet with md5 password-authentication.
>If you do not use localhost as hostname in the connection string, this is needed even
>for local connections.
>
>

scary, however, is...

host all all 0.0.0.0/0 trust

I read that to say, trust anyone from any IP to be anyone they say they want to be.

wouldn't that trump your subnet md5 line ?



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Leonardo Ribeiro Queiros wrote:

> Erro: java.net.ConnectException: Connection refused: connect
> Erro: Conexão negada. Verifique se o nome da máquina e a porta estão
> corretos e se o postmaster está aceitando conexões TCP/IP

I guess this is a localization of "Connection refused"?

Can you use psql running on the client machine to connect to the server
successfully? If not, JDBC isn't going to work either. I'd check for
firewalls between the client and server.

From JDBC's perspective, it's tried to establish a TCP connection to
port 5432 on your server and got a connection refused error. There is
nothing that the driver can do about that, you've got a connectivity
problem somewhere.

-O

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

http://www.postgresql.org/docs/faq