hard shut down of system

I will first check the logfiles then the stale pid file.

On 4/12/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:

if postmaster is running and i do,

kill -9 -1
i.e. i did abrupt shut down

now when i brought back the system

i am not able to start postmaster

actually i want to simulate, the scenario is which the user will do
'hard shut down / Power off'
while system is in working state..

and i want to ensure that postmaster is able to recover from this kind of
errors when
the system is is brought up..

how should i handle the above situation?

--
Jonel Rienton
mailto:jonel@rientongroup.com
powered by: google

"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:

if postmaster is running and i do,
kill -9 -1
i.e. i did abrupt shut down

i am not able to start postmaster

What happens exactly when you try --- what error messages does it print?
What method are you using to try to start the postmaster (pg_ctl,
some init script (whose), etc)?

The reasons I know about for failure to restart in this situation
include
* you forgot to kill all the postmaster child processes too;
* you didn't remove the shared memory segment and/or semaphores,
and the system's SysV limits are too small to let a new postmaster
create a whole duplicate set.
None of these things have anything to do with what happens in a real
system crash.

regards, tom lane