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.zierath@uni-bonn.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.zierath@uni-bonn.de
Web: http://www.coffee.uni-bonn.de
http://www.zef.de