Re: hard shut down of system

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: hard shut down of system
Date: 2006-04-12 13:57:56
Message-ID: 19244.1144850276@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2006-04-12 14:32:33 Re: [HACKERS] RH9 postgresql 8.0.7 rpm
Previous Message Daniel Tourde 2006-04-12 12:01:22 Re: How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database