From: mike g <mike@thegodshalls.com>
To: sirath@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot
Date: Thu, 03 Jun 2004 22:56:14 -0500
Message-ID: <1086321373.21104.11.camel@localhost.localdomain> (raw)
In-Reply-To: <09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com>
References: <09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com>
Hi,
I believe a fast shutdown prevents new connections to the db, sends
termination signals to any applications with current connections, and
then after it receives confirmation that those applications have aborted
their transactions and closed their connections the db stops.
It sounds like your application is either not responding to or
confirming the shutdown request from the db.
The details in that archive were trying to explain how to find which
process / application are still connected to the db after the fast
shutdown attempted to terminate them.
Without root access though maybe you aren't able to see which process is
still attached to the db?
Try doing a ps -A and see if the postmaster is still showing up in the
process list. If it is then you know for sure that the db is not truly
shutdown.
On Thu, 2004-06-03 at 21:22, Siddharth Rath (sirath) wrote:
> Hi,
> I've an application running on RedHat Linux and we are using Postgres as our DB. Initially the DB was running perfectly but due to
> some requirement we stopped the DB with " pg_ctl stop -m 'fast' " command. When I tried to restart the DB/Postmaster it says :
>
> StreamServerPort: bind() failed: Cannot assign requested address
> Is another postmaster already running on port 5432?
> If not, wait a few seconds and retry.
> cannot create INET stream port
>
> Since I don't have root access , I took the help of the Sysadmin to reboot the system and the DB server(POSTGRES) started correctly
> , but when I stopped the DB server with above mentioned command and started again it throws back the same old error. Is there anyway
> to get rid of these.
>
> I found some details in archieves at http://list.linux-vserver.org/archive/vserver/msg04095.html . But I don't understand what to do
> next.
>
> The O/P of >netstat -plunt | grep 5432
>
> (Not all processes could be identified, non-owned process info
> will not be shown, you would have to be root to see it all.)
> tcp 0 0 0.0.0.0:54320 0.0.0.0:* LISTEN -
> udp 0 0 0.0.0.0:54321 0.0.0.0:* -
>
> And O/P of netstat -ranv
>
> Kernel IP routing table
> Destination Gateway Genmask Flags MSS Window irtt Iface
> 10.83.103.0 0.0.0.0 255.255.255.192 U 0 0 0 eth2
> 64.102.29.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
> 169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth2
> 127.0.0.0 0.0.0.0 255.0.0.0 U 0 0 0 lo
> 0.0.0.0 64.102.29.1 0.0.0.0 UG 0 0 0 eth0
>
> Any pointers/help in resolving this issue will be highly appreciated.
>
> Thanx and regards
> Sidd
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@thegodshalls.com, sirath@cisco.com
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot
In-Reply-To: <1086321373.21104.11.camel@localhost.localdomain>
References: <09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com> <1086321373.21104.11.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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