postmaster shutdown failed
Hello All,
After starting the postmaster, I just entered in
database like:
$ psql test
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# LOG: received smart shutdown request
test=#
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?
Regs,
Durai.
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
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.