pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
tcp port
3+ messages / 3 participants
[nested] [flat]

* tcp port
@ 2004-03-08 17:54  philippe haas <philippe.haas@free.fr>
  0 siblings, 1 reply; 3+ messages in thread

From: philippe haas @ 2004-03-08 17:54 UTC (permalink / raw)
  To: pgsql-admin

Hi,
port 5432 (postmaster postgres reserved) on my machine(suze 8.2), with 
PostgreSQL 7.4.1 ) is unreachable
When i launche postmaster with tcp/op option, i've the message :
LOG:  could not bind IPv4 socket: Address already in use.
HINT:  Is another postmaster already running on port 5432? If not, wait a few 
seconds and retry.

I've launched nmap (nmap localhost -p 5432), port scanner and got :
The 1 scanned port on localhost (127.0.0.1) is: closed.

I suppose having mis-uninstalled an old version of postgres

Any idea ?

thanks
philipe



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: tcp port
@ 2004-03-10 07:42  Peter Eisentraut <peter_e@gmx.net>
  parent: philippe haas <philippe.haas@free.fr>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2004-03-10 07:42 UTC (permalink / raw)
  To: philippe haas <philippe.haas@free.fr>; pgsql-admin

philippe haas wrote:
> port 5432 (postmaster postgres reserved) on my machine(suze 8.2),
> with PostgreSQL 7.4.1 ) is unreachable
> When i launche postmaster with tcp/op option, i've the message :
> LOG:  could not bind IPv4 socket: Address already in use.
> HINT:  Is another postmaster already running on port 5432? If not,
> wait a few seconds and retry.

You can ignore this problem.  Notice that it does not say "ERROR" 
anywhere.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: tcp port
@ 2004-03-13 18:18  Michiel Lange <michiel@minas.demon.nl>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Michiel Lange @ 2004-03-13 18:18 UTC (permalink / raw)
  To: pgsql-admin

It is possible that due some weird stuff the port is not made free... 
check with

$ netstat --all --numeric-ports -p | grep 5432

this -for example- is my output:
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               
LISTEN      12775/postmaster
unix  2      [ ACC ]     STREAM     LISTENING     24015  
12775/postmaster    /tmp/.s.PGSQL.5432

If there is output, then check the PID which is just before the slash, 
in this case 12775

$ ps 12775

output:
  PID TTY      STAT   TIME COMMAND
12775 ?        S      0:00 /usr/local/pgsql/bin/postmaster -i

As you can see: there is a postmaster running
You might want to try to kill -TERM the process... don't use kill -KILL 
(or kill -9) on a running database, as you may very well very much 
damage your database...
Don't use kill -SEGV either! It's even more devastating...
kill -TERM is a request to shutdown as soon as possible. The process is 
allowed to shut down nicely and neatly.
kill -KILL is an order to stop immediately. There's no buffer flushing, 
finishing writes etc etc
kill -SEGV tells the program it made a segmentation fault and it crashed 
(core dump situation)

hope this information helps...

Peter Eisentraut wrote:

>philippe haas wrote:
>  
>
>>port 5432 (postmaster postgres reserved) on my machine(suze 8.2),
>>with PostgreSQL 7.4.1 ) is unreachable
>>When i launche postmaster with tcp/op option, i've the message :
>>LOG:  could not bind IPv4 socket: Address already in use.
>>HINT:  Is another postmaster already running on port 5432? If not,
>>wait a few seconds and retry.
>>    
>>
>
>You can ignore this problem.  Notice that it does not say "ERROR" 
>anywhere.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>  
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-03-13 18:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-08 17:54 tcp port philippe haas <philippe.haas@free.fr>
2004-03-10 07:42 ` Peter Eisentraut <peter_e@gmx.net>
2004-03-13 18:18   ` Michiel Lange <michiel@minas.demon.nl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox