From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | herbey zepeda <zepedaherbey(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg Windows to PG FreeBSD |
Date: | 2010-04-23 20:11:19 |
Message-ID: | x2kdcc563d11004231311rc397b8e0sc5f8de05da79a5b2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda <zepedaherbey(at)gmail(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Raúl Andrés Duque | 2010-04-23 20:21:16 | Re: [pgsql-es-ayuda] REF: Migracion de Sqlserver a Postgresql |
Previous Message | herbey zepeda | 2010-04-23 20:05:17 | pg Windows to PG FreeBSD |