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

Поиск
Список
Период
Сортировка
От surabhi.ahuja
Тема Re: cant connect to the database, even after doing start
Дата
Msg-id 8626C1B7EB748940BCDD7596134632BE398698@jal.iiitb.ac.in
обсуждение исходный текст
Ответ на cant connect to the database, even after doing start of postmaster using a script  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Список pgsql-general
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@g2switchworks.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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Timothy Smith
Дата:
Сообщение: permission to create user
Следующее
От: Stefan Schwarzer
Дата:
Сообщение: INSERT 0 1 "problems"