Re: Remote / network connection fails

From: Nils Zierath <nils(dot)zierath(at)uni-bonn(dot)de>
To: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Remote / network connection fails
Date: 2008-04-21 10:21:20
Message-ID: 480C6AA0.4010706@uni-bonn.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
udp 0 0 127.0.0.1:33092 127.0.0.1:33092 ESTABLISHED 3298/postgres
unix 2 [ ACC ] STREAM LISTENING 383161 3298/postgres
/var/run/postgresql/.s.PGSQL.5432

As far as I know, I am running only one instance of Postgres version 8.3 running:

my_host:/etc# ps -efl
...
0 S postgres 3298 1 0 78 0 - 10546 - 11:57 pts/0 00:00:00
/usr/lib/postgresql/8.3/bin/postgres
1 S postgres 3300 3298 0 75 0 - 10546 - 11:57 ? 00:00:00 postgres:
writer process
1 S postgres 3301 3298 0 75 0 - 10546 - 11:57 ? 00:00:00 postgres: wal
writer process
1 S postgres 3302 3298 0 75 0 - 10613 - 11:57 ? 00:00:00 postgres:
autovacuum launcher process
1 S postgres 3303 3298 0 75 0 - 3410 - 11:57 ? 00:00:00 postgres: stats
collector process

my_host:/etc# ls -al /var/run/postgresql/
total 16
drwxrwsr-x 2 postgres postgres 4096 2008-04-21 11:57 .
drwxr-xr-x 19 root root 4096 2008-04-21 11:13 ..
-rw------- 1 postgres postgres 5 2008-04-21 11:57 8.3-main.pid
srwxrwxrwx 1 postgres postgres 0 2008-04-21 11:57 .s.PGSQL.5432
-rw------- 1 postgres postgres 33 2008-04-21 11:57 .s.PGSQL.5432.lock

Is that giving you some more information on where to look?

Thanks,
Nils

Andrej Ricnik-Bay schrieb:
> On 18/04/2008, Nils Zierath <nils(dot)zierath(at)uni-bonn(dot)de> wrote:
>
>> I tried 'netstat -anp' while being logged into my server via ssh:
>> ..
>> unix 2 [ ACC ] STREAM LISTENING 317212 2992/postgres
>> /var/run/postgresql/.s.PGSQL.5432
>> ..
>
>> So that looks alright?
>
> No, it doesn't. That's the local socket, it's not listening on
> any network interface. You'd expect something more like this:
>
> netstat -anp|grep postgr
> tcp 0 0 0.0.0.0:5432 0.0.0.0:*
> LISTEN 5233/postgres
> tcp6 0 0 :::5432 :::*
> LISTEN 5233/postgres
> udp 0 0 127.0.0.1:32769 127.0.0.1:32769
> ESTABLISHED5233/postgres
> unix 2 [ ACC ] STREAM LISTENING 18729
> 5233/postgres /var/run/postgresql/.s.PGSQL.5432
>
>
>> What else could I try?
>
> Not quite sure what's going wrong there. Have you got
> more than one version of postgres installed?
>
>> Cheers,
>> nilson
> Cheers,
> Andrej
>
>

--
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 Tom Lane 2008-04-21 14:36:11 Re: Remote / network connection fails
Previous Message Mag Gam 2008-04-20 18:33:33 Re: Database theory question