Re: Connect to Postgres problems - Mailing list pgsql-general

From Chris Barnes
Subject Re: Connect to Postgres problems
Date
Msg-id BLU149-W33312986BD96A09932D222D4580@phx.gbl
Whole thread Raw
In response to Re: Connect to Postgres problems  (Christine Penner <christine@ingenioussoftware.com>)
List pgsql-general
 
Telnet is usually installed by default on windows or unix box, telnet to the database box should work.
telnet 207.6.93.IP  5432      should work
 
Make sure that windows firewall and antivirus software firewall are temporarily disabled to test.
 
 
 
 
> Date: Mon, 1 Feb 2010 09:49:49 -0800
> To: raanders@cyber-office.net; pgsql-general@postgresql.org
> From: christine@ingenioussoftware.com
> Subject: Re: [GENERAL] Connect to Postgres problems
>
> I set up port forwarding. I assume that means all IP addresses using
> port 5432 will be sent to my laptop (that Postgres is running on). I
> don't remember setting up permissions for a specific IP in the router
> but it was a while ago so I could be wrong. When I get home I will
> have another look at the firewall settings and see.
>
> Christine
>
> At 09:20 AM 01/02/2010, you wrote:
> >Christine Penner wrote:
> >>Hi,
> >>I'm having trouble getting a connection to Postgres to work from
> >>outside of my local network. It was working fine at one point. Then
> >>I had to change IP addresses and I can't get it to work. This is
> >>what I've done.
> >>On the computer with Postgres installed I have this in the pg_hba.conf file:
> >>host all all 207.6.93.152/32 md5
> >>in the postgresql.conf file I have this:
> >>listen_addresses = '*'
> >>port = 5432
> >>I also have the router set up to forward port 5432 to the computer
> >>with Postgres installed.
> >
> >Did you check the firewall on the machine running Pg? Iptables etc.
> >
> >
> >\\||/
> >Rod
> >--
> >
> >
> >--
> >Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> >To make changes to your subscription:
> >http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Not using Hotmail on your phone? Why not? Get it now.

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Possible to set postgres in case insensitive mode ?
Next
From: Vijay Sharma
Date:
Subject: How Copy from a view to CSV file