PostgreSQL Discussion - postmaster does not shut down

Author

postmaster does not shut down

surabhi.ahuja

2005-09-30, 3:23 am

when i grep for postmaster
ps -aef | grep postmaster

it says:
/usr/bin/postmaster -D /export/home1/sdc_image_pool/dbx -p 5432

when i try to stop postmaster doing

/usr/bin/pg_ctl -D /export/home1/sdc_image_pool/dbx/ stop
the following is displayed:
waiting for postmaster to shut down............................................................... failed
pg_ctl: postmaster does not shut down

i grepped for PGDATA

echo $PGDATA
it says undefined variable

please tell me what to do

thanks
regards
surabhi ahuja

Peter Eisentraut

2005-09-30, 3:23 am

Am Freitag, 30. September 2005 07:07 schrieb surabhi. ahuja:
> /usr/bin/pg_ctl -D /export/home1/sdc_image_pool/dbx/ stop
> the following is displayed:
> waiting for postmaster to shut
> down............................................................... failed
> pg_ctl: postmaster does not shut down

This could well be because there are still connected clients. Read about the
"mode" option (-m) on the pg_ctl man page.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links