Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 4AE186333C5 for ; Fri, 23 Apr 2010 23:31:10 -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 52740-08 for ; Sat, 24 Apr 2010 02:30:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id 408496331DC for ; Fri, 23 Apr 2010 23:30:58 -0300 (ADT) Received: by gwj19 with SMTP id 19so3034300gwj.19 for ; Fri, 23 Apr 2010 19:30:56 -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; bh=fWoLCNPHLjc++OunQYRlRnPFRqlLhzadAtFZjkZBmeA=; b=UQWRMlxcRdCgT9ZNTvsuVY766kAEjDW7nV1Pzi2F7Vw7hg6i4L8LAKYKJzIzfvu0w+ Jcv2pMYYABA5FVdtVwSyXxM4VU04WwM+RAL5XDjOvJCVOa4HbsERmo/2WSHS0KrtZE+G GvJvMH8ifne6KMZNyaaQJL0ZFZg3cYX1npsWE= 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; b=yDJlJFAjOHLWuvZJdDC67Jvqchwcw+tXDFoiUGgcz+AAJ1ckMkCwcMyztEr8gfO9qQ SZClwiEvCs1t00g9S5AT79d1BIoYL/7hpT7njYMrlnSL4zdgzf55cpVh94PgxTGFe3Tg 88tzVfP8fAQ2ffC8ZOmpbUEvcWQUzDSDtSAMs= MIME-Version: 1.0 Received: by 10.151.93.11 with SMTP id v11mr934554ybl.94.1272076256658; Fri, 23 Apr 2010 19:30:56 -0700 (PDT) Received: by 10.231.20.12 with HTTP; Fri, 23 Apr 2010 19:30:56 -0700 (PDT) In-Reply-To: References: Date: Fri, 23 Apr 2010 22:30:56 -0400 Message-ID: Subject: Re: pg Windows to PG FreeBSD From: herbey zepeda To: Scott Marlowe Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd2454667c68a0484f255df X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.249 tagged_above=-10 required=5 tests=AWL=-0.351, BAYES_00=-1.9, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201004/325 X-Sequence-Number: 34419 --000e0cd2454667c68a0484f255df Content-Type: text/plain; charset=ISO-8859-1 I appologize, I did everything as stated in the manuals and more, but I did not remove the comment character from the configuration file postgres.conf. The connection from pg WIndows to pg Freebsd was succesful, thanks for your reply On Fri, Apr 23, 2010 at 4:11 PM, Scott Marlowe wrote: > On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda > wrote: > > 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?" > > 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 "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? > --000e0cd2454667c68a0484f255df Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I appologize,
=A0
I did everything as stated in the manuals and= more, but I did not remove the comment character from the configuration fi= le postgres.conf. The connection from pg WIndows to pg Freebsd was succesfu= l,=A0
=A0
thanks for your reply


=A0
On Fri, Apr 23, 2010 at 4:11 PM, Scott Marlowe <= span dir=3D"ltr"><scott.marlo= we@gmail.com> wrote:
On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda <zepedaherbey@gmail.com> wrote:> 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 in= stall 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 connectio= ns on port 5432?"

So, the windows machine can't get t= o port 5432 on the bsd machine.
The problem can be anything from a firewall (exxternal) to the app not
r= unning on the host machine.

Does that same string work on the bsd bo= x?

> 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-h= ba-conf.html
> http://www.postgresql.= org/docs/8.4/static/runtime-config-connection.html
> http://www.cyberciti.biz/tips/postgr= es-allow-remote-access-tcp-connection.html
> in addition to the m= anual,
>
> 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".

Whe= re did you change this? =A0On the bsd box or the windows box (should
be bsd) =A0If on bsd did you then restart the server on bsd?

--000e0cd2454667c68a0484f255df--