Re: URGENT : StreamServerPort: bind() failed: Cannot - Mailing list pgsql-admin

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
perfectlybut due to 
> some requirement we stopped the DB with " pg_ctl stop -m 'fast' " command. When I tried to restart the DB/Postmaster
itsays : 
>
> 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)
startedcorrectly 
> , but when I stopped the DB server with above mentioned command and started again it throws back the same old error.
Isthere 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
understandwhat 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