Re: Remote / network connection fails

From: Nils Zierath <nils(dot)zierath(at)uni-bonn(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Remote / network connection fails
Date: 2008-04-22 09:41:49
Message-ID: 480DB2DD.3090204@uni-bonn.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Tom & Andrej,
it pretty much looks like a firewall problem. Although I am still not sure, what's wrong
with my firewall, I solved the connection problem via SSH-tunneling
(http://www.postgresonline.com/journal/index.php?/archives/38-PuTTY-for-SSH-Tunneling-to-PostgreSQL-Server.html).

Thank you so much for helping,
Nils

Tom Lane schrieb:
> Nils Zierath <nils(dot)zierath(at)uni-bonn(dot)de> writes:
>> hmm strange,
>> Andrej, I tried again and got the same output as you posted:
>
>> my_host:/etc# netstat -anp|grep postgres
>> tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 3298/postgres
>> tcp6 0 0 :::5432 :::* LISTEN 3298/postgres
>
> In that case it's probably a firewall problem. Double-check what you
> did with iptables.
>
> regards, tom lane

--
Nils Zierath

ZEF 10 Years
1997-2007: 10 Years of Development Research
on Economic, Cultural, and Ecological Change
in the Developing World

Center for Development Research
Department of Ecology and Resource Management

Walter-Flex-Strasse 3
53113 Bonn (Germany)

Tel.: +49 (0) 228 - 73-1793
FAX: +49 (0) 228 - 73-1889

E-Mail: nils(dot)zierath(at)uni-bonn(dot)de
Web: http://www.coffee.uni-bonn.de
http://www.zef.de

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Szentpali Janos 2008-04-22 10:03:30 Re: convert text file to database
Previous Message Andrej Ricnik-Bay 2008-04-22 09:36:50 Re: Remote / network connection fails