Thread: 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
"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
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 downHi,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 fastI get the following:
waiting for postmaster to shut down................................................................ failed
pg_ctl: postmaster does not shut downAny ideas why this is happening? And what I can do to avoid this?Thank You.Mona Gamboa