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@iname.com [mailto:zuhans@iname.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