From: herbey zepeda <zepedaherbey@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg Windows to PG FreeBSD
Date: Fri, 23 Apr 2010 22:30:56 -0400
Message-ID: <m2j49856ef1004231930w94ecaa3cv425299d750d938d@mail.gmail.com> (raw)
In-Reply-To: <x2kdcc563d11004231311rc397b8e0sc5f8de05da79a5b2@mail.gmail.com>
References: <w2j49856ef1004231305q94348736va34fba002babd0d0@mail.gmail.com>
<x2kdcc563d11004231311rc397b8e0sc5f8de05da79a5b2@mail.gmail.com>
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 <scott.marlowe@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 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?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: zepedaherbey@gmail.com, scott.marlowe@gmail.com
Subject: Re: pg Windows to PG FreeBSD
In-Reply-To: <m2j49856ef1004231930w94ecaa3cv425299d750d938d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox