Re: hard shut down of system - Mailing list pgsql-general

From Tom Lane
Subject Re: hard shut down of system
Date
Msg-id 19244.1144850276@sss.pgh.pa.us
Whole thread Raw
In response to hard shut down of system  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Daniel Tourde
Date:
Subject: Re: How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database
Next
From: "Andrus"
Date:
Subject: Could not send Query(connection dead)