Re: Correct "db-stop" Script

Hi Hans,

Thanks for your valuable information regarding the "kill..." function. Does
that significantly change the "db-stop" script?

This is the "db-stop" script as I understand it to be at the moment:

echo
echo "PostgreSQL finishing..."
pg_ctl stop -w -D /var/postgresql/data -s -m smart
ps -f
echo
echo "cygserver finishing..."
ps -f
kill <process-number>
ps -f
kill <process-number>
(until all processes have been killed)

But when I typed the following in:

$ echo

$ echo "PostgreSQL finishing..."
PostgreSQL finishing...
$ pg_ctl stop -w -D /var/postgresql/data -s -m smart

I got the following response:

pg_ctl: could not find /var/postgresql/data/postmaster.pid
Is postmaster running?
$

Weird eh? Any reason why it's doing that?

Once again, your help is EXTREMELY appreciated!!!!

Dan

-----Original Message-----
From: zuhans(at)iname(dot)com [mailto:zuhans(at)iname(dot)com]
Sent: Saturday, July 31, 2004 3:11 AM
To: Daniel Secomb
Subject: initdb...

hi dan,

what i forgot to say:
if you really type in one command after the other (so as to learn what's
going on), then - instead of typing in "./db-stop" - you have to type in
all commands from my "db-stop"-script-lines.

but then the "kill..."-line won't work! instead just type in "ps -f",
then you get the list of all processes running at the moment, remember
the process-number of cygserver (very left coloumn of ps - output) and
then type in: "kill <process-number>" (e.g. kill 3024). this makes a
shutdown of cygserver.

hope that helps!
hans