Re: Connect to Postgres problems

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

_________________________________________________________________

In response to

Browse pgsql-general by date

  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 ?