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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
