Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2EB72633648 for ; Fri, 23 Apr 2010 17:11:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 88014-03 for ; Fri, 23 Apr 2010 20:11:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 00EC16333E3 for ; Fri, 23 Apr 2010 17:11:20 -0300 (ADT) Received: by vws17 with SMTP id 17so296770vws.19 for ; Fri, 23 Apr 2010 13:11:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=6sg8aVcoeziS6+KcQOggq8FOut3jlAnF5FTz8H+DIuo=; b=IJHrU1LPaDLTq6dcuHGFMLpY2iwTEXAAGKCT9e+TJM1oQ8IItHBclm9U8QNg550MOZ 102OLixKyW8a9U92sXuJ63SQvUEdGYZ6OqrFSr+3KgJbJ0K3v32+kUJkV9gwKj+E9qha mt3fyUzgyUqQTRWzS8C3zEcHylCvzU9SAfmOg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=PzaJ4ZxIxaHtiFni9e3d94RVG7ic+jtHBPzydt+Rlv+xCFv5yb+ihcwhg+OqVqgeAR RLDUlJ9FUadMvIi71rEcAivnjTCpNA8tFJwXQcDrSeSXuGtRwFfDliy6W7Hsxk0PlkfU LrdjbAW0ZyrEScLtaMB2abkuXsgN4nAIq2K9A= MIME-Version: 1.0 Received: by 10.220.126.153 with SMTP id c25mr392752vcs.20.1272053479810; Fri, 23 Apr 2010 13:11:19 -0700 (PDT) Received: by 10.150.134.20 with HTTP; Fri, 23 Apr 2010 13:11:19 -0700 (PDT) In-Reply-To: References: Date: Fri, 23 Apr 2010 14:11:19 -0600 Message-ID: Subject: Re: pg Windows to PG FreeBSD From: Scott Marlowe To: herbey zepeda Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.071 tagged_above=-10 required=5 tests=AWL=-0.171, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/321 X-Sequence-Number: 34415 On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda wro= te: > hi > > I have one install of postgresql in Windows, and a second in FreeBSD. Bot= h > are the 8.4 version > I am trying to connect from the windows install to the FreeBSD server > install > > > psql -h 10.10.90.125 -U=A0myUser -d template1 > > and the result is: > > > "Could not connect to server connection refused....is the server running = on > host .... and accepting tcp/ip connections on port 5432?" So, the windows machine can't get to port 5432 on the bsd machine. The problem can be anything from a firewall (exxternal) to the app not running on the host machine. Does that same string work on the bsd box? > I searched in severa places, one of them is: > http://www.postgresql.org/docs/8.3/static/server-start.html > http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html > http://www.postgresql.org/docs/8.4/static/runtime-config-connection.html > http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection= .html > in addition to the manual, > > I do not have the same problem when I try a Windows to Windows connection= . Of course, the problem is likely that the bsd box isn't answering on that port for whatever reason. > I already placed the "*" in the listen_addresses option and=A0 "host all = all > 10.10.90.0/24 trust". Where did you change this? On the bsd box or the windows box (should be bsd) If on bsd did you then restart the server on bsd?