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
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 |