Обсуждение: No connection could be made because the target machine actively refused it

I am trying to connect to a PostgreSQL server from another machine on my
small home network. When I click the Test button in the ODBC data mnager
for my system DSN I get the error "No connection could be made because
the target machine actively refused it." That may not be the exact
message but it is close.

I have no problem connecting using localhost on the machine where
PostgresSQL is running. However, if I connect using the machine's IP
address (10.0.0.9) either locally or from another PC I get the error
above. I have disabled the Windows firewall and my antivirus software
but the error persists.

Any suggestions? I am new to PostgreSQL so assume I have done something
really dumb.<g>

Bill

In response to Bill Todd :
> I am trying to connect to a PostgreSQL server from another machine on my
> small home network. When I click the Test button in the ODBC data mnager
> for my system DSN I get the error "No connection could be made because
> the target machine actively refused it." That may not be the exact
> message but it is close.
>
> I have no problem connecting using localhost on the machine where
> PostgresSQL is running. However, if I connect using the machine's IP
> address (10.0.0.9) either locally or from another PC I get the error
> above. I have disabled the Windows firewall and my antivirus software
> but the error persists.
>
> Any suggestions? I am new to PostgreSQL so assume I have done something
> really dumb.<g>

You have to edit your postgresql.conf:

listen_addresses = '*'


and your pg_hba.conf to enable remote access. Read the documentation and
the comments at the end of the pg_hba.conf - file.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

On 2009-04-22, Bill Todd <pg@dbginc.com> wrote:
> I am trying to connect to a PostgreSQL server from another machine on my
> small home network. When I click the Test button in the ODBC data mnager
> for my system DSN I get the error "No connection could be made because
> the target machine actively refused it." That may not be the exact
> message but it is close.

You mention ODBC so I'm going to assUme both PCs are running windows.

> I have no problem connecting using localhost on the machine where
> PostgresSQL is running. However, if I connect using the machine's IP
> address (10.0.0.9) either locally or from another PC I get the error
> above. I have disabled the Windows firewall and my antivirus software
> but the error persists.
>
> Any suggestions? I am new to PostgreSQL so assume I have done something
> really dumb.<g>

upto three things..

1: open port 5432/TCP in any firewalls

2: in postgresql.conf file it should not say 'listen addresses="localhost"'
   listen_addresses="*" is good unless your server doubles as a firewall/router
   in which case you probably want to list the lan interfaces (and localhost).

3: you may need to modify pg_hba.conf  too.

at work we wrap the postgresql MSI installer with our own NSIS installer and
optionally (attempt to) do those tweaks

these conf files are in the postgres "data" directory on windows
machines, there may be a link in your start menu for editing them.