I m using PostgreSQL 9.0. It hangs during shutdown.
when I used pg_ctl stop
it hangs and after sometime its displaying msg:
pg_ctl: server does not shut down
and when I used psql its showing:
psql: FATAL: the database system is shutting down
and in logs its writing these msgs
DEBUG: postmaster received signal 15
2011-07-14 09:36:00 ETC/GMT LOG: received smart shutdown request
Please tell me how to resolve it?