Re: cant connect to the database, even after doing start

this script is taken from the distribution also

but i think the second check, to do stop -m immidiate is home grown.

thanks,
regards
Surabhi

________________________________

From: Scott Marlowe [mailto:smarlowe(at)g2switchworks(dot)com]
Sent: Fri 7/14/2006 9:44 PM
To: surabhi.ahuja
Cc: pgsql general
Subject: RE: [GENERAL] cant connect to the database, even after doing start

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********

On Fri, 2006-07-14 at 02:48, surabhi.ahuja wrote:
> this is what is happening
>
> stop(){
> echo "Stopping ${NAME} service: "
> if [ "`uname`" = "Linux" ]; then
> /bin/sh -c "$PGCTL stop -D $PGDATA -s -m fast" > /dev/null
> 2>&1
> fi
> ret=$?
> if [ $ret -eq 0 ]
> then
> echo_success
> else
> echo_failure
> if [ "`uname`" = "Linux" ]; then
> /bin/sh -c "$PGCTL stop -D $PGDATA -s -m immediate"
> > /dev/null 2>&1
> fi
> fi
> echo
> }
>
> u mean to say that /bin/sh -c "$PGCTL stop -D $PGDATA -s -m
> immediate" > /dev/null 2>&1
> is causing problem
>
> what shd be done, shd it be removed?

It's not how I'd do it, certainly. Which branch gets run most the
time? Have you tested to make sure that the -m fast really runs and
gets a chance to work? What script is this from? Is it a stock one
that came with your distribution, or home grown?