postmaster shutdown failed

[Durai raj]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Ed L.]

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/s...-shutdown.html

and also the man page for pg_ctl options to invoke smart/fast/immediate
shutdowns.

HTH.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings