Skip site navigation (1) Skip section navigation (2)

Re: Bug #807: Sequence currupted on recovery after kill -9

From: Florian Weimer <Weimer(at)CERT(dot)Uni-Stuttgart(dot)DE>
To: Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: mthomp(at)tierfleet(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #807: Sequence currupted on recovery after kill -9
Date: 2002-10-31 20:25:59
Message-ID: 87iszi73u0.fsf@Login.CERT.Uni-Stuttgart.DE (view raw or flat)
Thread:
Lists: pgsql-bugs
Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:

> I'm sure if you read the footers on Tom's email's it's pretty clearly stated 
> 'do not kill -9 the postmaster'. 
> So I'm not so sure that this is really a bug. 

The operating environment is free to kill -9 the postmaster at any
time, and PostgreSQL is expected to ensure database consistency
nevertheless.

After all, PostgreSQL is a database and not a cardbox.

(But holes in sequence numbers certainly do not endanger database
consistency.)

-- 
Florian Weimer 	                  Weimer(at)CERT(dot)Uni-Stuttgart(dot)DE
University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT                          fax +49-711-685-5898

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-11-01 01:40:52
Subject: Bug #809: View not using index
Previous:From: Stefan SchwarzerDate: 2002-10-31 18:33:56
Subject: Bug with child tables referencing parent table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group