| From: | Shane Ambler <pgsql(at)007Marketing(dot)com> |
|---|---|
| To: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
| Cc: | Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: why not kill -9 postmaster |
| Date: | 2006-10-20 14:50:35 |
| Message-ID: | 4538E23B.30506@007Marketing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dawid Kuroczko wrote:
> On 10/20/06, Shane Ambler <pgsql(at)007marketing(dot)com> wrote:
>> The one thing worse than kill -9 the postmaster is pulling the power
>> cord out of the server. Which is what makes UPS's so good.
>
>
> Well, I think that pulling the power cord is much safer than killing -9
> the postmaster. If you pull the plug, then during bootup postgresql
> will just replay every COMMITed transaction, so there won't be any
> dataloss or downtime.
If you kill -9 the postmaster the system can still finish sending
changes to disk and close the file but pulling the power cord can stop a
write in the middle of a block giving you half new data and half old
data in the one file.
It's all a matter of timing.
--
Shane Ambler
Postgres(at)007Marketing(dot)com
Get Sheeky @ http://Sheeky.Biz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christophe Roux | 2006-10-20 15:01:50 | skip duplicate key error during inserts |
| Previous Message | Ian Harding | 2006-10-20 14:45:26 | Re: why not kill -9 postmaster |