On Thursday May 20 2004 10:11, Durai raj wrote:
> When I stop the postmaster in another session or in
> terminal, I got the following error:
>
> $ pg_ctl -D /var/opt/iexpress/postgresql stop
> waiting for postmaster to shut
> down................................................................
> failed
> pg_ctl: postmaster does not shut down
> $
>
> Is there any other way to shutdown in this situation?
> (Or)
> How to know whether database is accessed or not?
> (Or)
> How to shutdown the postmaster safely from the above
> situation?
You probably have an open transaction in your psql session which prevents
the "smart" shutdown from completing. You can either finish your
transactions (for smart shutdown) or you can roll them back (with "fast"
shutdown). See the manual ... for 7.3, it's
http://www.postgresql.org/docs/7.3/static/postmaster-shutdown.html
and also the man page for pg_ctl options to invoke smart/fast/immediate
shutdowns.
HTH.