Re: Remote / network connection fails - Mailing list 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.zierath@uni-bonn.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.zierath@uni-bonn.de
Web:    http://www.coffee.uni-bonn.de
         http://www.zef.de