Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2008-04-21 14:36:11
Subject: Re: Remote / network connection fails
Previous:From: Mag GamDate: 2008-04-20 18:33:33
Subject: Re: Database theory question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group