Re: pg Windows to PG FreeBSD

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda <zepedaherbey@xxxxxxxxx> 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?

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux