Thread: postmaster failing to shut down

postmaster failing to shut down

From
"Mona Gamboa"
Date:
Hi,
I'm new to PostgreSQL--have been using it for 3-4 months now.
I've been porting our Oracle DB and applications to PostgreSQL and I am using the latest release 7.3.
 
Anyway, when I do try to shutdown the postmaster with the following command:
 
pg_ctl -D /home/postgres/pgsql/DATA stop -m fast
 
I get the following:

waiting for postmaster to shut down................................................................ failed
pg_ctl: postmaster does not shut down
 
Any ideas why this is happening?  And what I can do to avoid this?
 
Thank You.
 
Mona Gamboa 

Re: postmaster failing to shut down

From
Petr Swedock
Date:
"Mona Gamboa" <mona@loopone.com> writes:

  ;; Hi,
  ;; I'm new to PostgreSQL--have been using it for 3-4 months now.
  ;; I've been porting our Oracle DB and applications to PostgreSQL
  ;; and I am using the latest release 7.3.
  ;;
  ;; Anyway, when I do try to shutdown the postmaster with the
  ;; following command:
  ;;
  ;; pg_ctl -D /home/postgres/pgsql/DATA stop -m fast
  ;;
  ;; I get the following:
  ;;
  ;; waiting for postmaster to shut down..........................
  ;; ...................................... failed
  ;; pg_ctl: postmaster does not shut down
  ;;
  ;; Any ideas why this is happening?  And what I can do to avoid this?


Hi Mona,

Pg_ctl is a bash script. As such, you can read it in order to try and
figure out  what's going on.  The default location, I believe, is
/usr/local/bin.

Peace,

Petr

Re: postmaster failing to shut down

From
Jie Liang
Date:
use command ps to find out who is still connect db, terminate those sessions then try again.
 
 
Jie Liang 
-----Original Message-----
From: Mona Gamboa [mailto:mona@loopone.com]
Sent: Wednesday, December 25, 2002 12:13 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] postmaster failing to shut down

Hi,
I'm new to PostgreSQL--have been using it for 3-4 months now.
I've been porting our Oracle DB and applications to PostgreSQL and I am using the latest release 7.3.
 
Anyway, when I do try to shutdown the postmaster with the following command:
 
pg_ctl -D /home/postgres/pgsql/DATA stop -m fast
 
I get the following:

waiting for postmaster to shut down................................................................ failed
pg_ctl: postmaster does not shut down
 
Any ideas why this is happening?  And what I can do to avoid this?
 
Thank You.
 
Mona Gamboa