pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtcp 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