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
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 |