From: Scott Marlowe <scott.marlowe@gmail.com>
To: herbey zepeda <zepedaherbey@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg Windows to PG FreeBSD
Date: Fri, 23 Apr 2010 14:11:19 -0600
Message-ID: <x2kdcc563d11004231311rc397b8e0sc5f8de05da79a5b2@mail.gmail.com> (raw)
In-Reply-To: <w2j49856ef1004231305q94348736va34fba002babd0d0@mail.gmail.com>
References: <w2j49856ef1004231305q94348736va34fba002babd0d0@mail.gmail.com>
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: scott.marlowe@gmail.com, zepedaherbey@gmail.com
Subject: Re: pg Windows to PG FreeBSD
In-Reply-To: <x2kdcc563d11004231311rc397b8e0sc5f8de05da79a5b2@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