Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3878E632F70 for ; Fri, 23 Apr 2010 17:05:40 -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 86768-04-4 for ; Fri, 23 Apr 2010 20:05:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f202.google.com (mail-iw0-f202.google.com [209.85.223.202]) by mail.postgresql.org (Postfix) with ESMTP id 0F71D633BCF for ; Fri, 23 Apr 2010 17:05:18 -0300 (ADT) Received: by iwn40 with SMTP id 40so1391150iwn.1 for ; Fri, 23 Apr 2010 13:05:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=Vmykr82jtF2kMdcBsKlnv5ybAJSGkE2iC2VJgrXw4ew=; b=MOjgCf2iEEvfsoifm8Xt9vHTI/CvkkVKSy5FMdBo1t9WD1ldVtjL1hc4MgJT/J9gnw q8kg2/bk8WA8Ut+wPyovM32d/OogJATyZs3R/dqfK6pgrrGdueR67/NCOaJCMVlNFpRq MRAy2IAHxLcBTAk36Nmjl2qZqtjkihCw+Ji3M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=FNcpye2hMw+YJujC2ChUs6DCFILBf6EohqQLicd6HnJHW9jpmK2LogGEHHLLkkV/61 Bc6GPq02WEe3U70OKseyf0YN1onkpWoMp1EcsatqQYZyr6WzIZHBV4Vks8r4h+s0WHGB mF019hFaK15sd7jelFwyYXMbPogmT5cIGfq30= MIME-Version: 1.0 Received: by 10.231.153.67 with SMTP id j3mr145984ibw.28.1272053117847; Fri, 23 Apr 2010 13:05:17 -0700 (PDT) Received: by 10.231.20.12 with HTTP; Fri, 23 Apr 2010 13:05:17 -0700 (PDT) Date: Fri, 23 Apr 2010 16:05:17 -0400 Message-ID: Subject: pg Windows to PG FreeBSD From: herbey zepeda To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0050450158a63988fb0484ecf2da X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201004/320 X-Sequence-Number: 34414 --0050450158a63988fb0484ecf2da Content-Type: text/plain; charset=ISO-8859-1 hi I have one install of postgresql in Windows, and a second in FreeBSD. Both 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 myUser -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?" 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. I already placed the "*" in the listen_addresses option and "host all all 10.10.90.0/24 trust". I'm not sure what to do now, again, windows to windows there is no problem, thanks --0050450158a63988fb0484ecf2da Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
hi
=A0
I have one install of postgresql in Windows, and a second in FreeBSD. = Both are the 8.4 version
I am trying to connect from the windows install to the FreeBSD server = install
=A0
=A0
psql -h 10.10.90.125 -U=A0myUser -d template1
=A0
and the result is:
=A0
=A0
"Could not connect to server connection refused....is the server = running on host .... and accepting tcp/ip connections on port 5432?"
=A0
I searched in severa places, one of them is:
=A0
=A0
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
=A0
=A0
=A0
in addition to the manual,
=A0
=A0
I do not have the same problem when I try a Windows to Windows connect= ion.
=A0
=A0
I already placed the "*" in the listen_addresses option and= =A0 "host all all 10.10.90.0/24 trust".
=A0
I'm not sure what to do now, again, windows to windows there is no= problem,
=A0
thanks
--0050450158a63988fb0484ecf2da--