Re: Connect to Postgres problems

Поиск
Список
Период
Сортировка
От Chris Barnes
Тема Re: Connect to Postgres problems
Дата
Msg-id BLU149-W33312986BD96A09932D222D4580@phx.gbl
обсуждение исходный текст
Ответ на Re: Connect to Postgres problems  (Christine Penner <christine@ingenioussoftware.com>)
Список 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Possible to set postgres in case insensitive mode ?
Следующее
От: Vijay Sharma
Дата:
Сообщение: How Copy from a view to CSV file