From: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
---|---|
To: | <christine(at)ingenioussoftware(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connect to Postgres problems |
Date: | 2010-02-01 18:00:19 |
Message-ID: | BLU149-W33312986BD96A09932D222D4580@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cyber-office(dot)net; pgsql-general(at)postgresql(dot)org
> From: christine(at)ingenioussoftware(dot)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(at)postgresql(dot)org)
> >To make changes to your subscription:
> >http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
_________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Vijay Sharma | 2010-02-01 18:18:10 | How Copy from a view to CSV file |
Previous Message | David Fetter | 2010-02-01 17:54:04 | Re: Possible to set postgres in case insensitive mode ? |