Skip site navigation (1) Skip section navigation (2)

Re: Correct "db-stop" Script

From: "Daniel Secomb" <dan(at)ds-d(dot)com>
To: <zuhans(at)iname(dot)com>, <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Correct "db-stop" Script
Date: 2004-08-02 14:11:26
Message-ID: MCBBIFBENOMGNJNDAAJBEEHNCHAA.dan@ds-d.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
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


Responses

pgsql-cygwin by date

Next:From: mike gDate: 2004-08-03 03:35:26
Subject: Re: initdb...
Previous:From: Daniel SecombDate: 2004-08-02 13:43:54
Subject: Basic phpPgAdmin Questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group