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

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?