Re: How to simulate crashes of PostgreSQL?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to simulate crashes of PostgreSQL?
Date: 2009-08-25 15:49:51
Message-ID: b42b73150908250849u560f20d4t430fda1f3449825@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 24, 2009 at 2:10 AM, Scott Marlowe<scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Sat, Aug 22, 2009 at 4:55 PM, Greg Sabino Mullane<greg(at)turnstep(dot)com> wrote:
>> A server crash is a pretty rare event in the Postgres world, so I
>> would not spend too many cycles on this...
>
> I've been running pg in production since 7.0 came out.  zero server crashes.

I've found a few...I discovered the aggregate problem in 8.4. I also
co-discovered the prepared query/alter table that can trivially crash
any pg server up to 8.2.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2009-08-25 15:56:31 Re: New database or New Schema?
Previous Message Guy Helmer 2009-08-25 15:39:20 Re: Invalid memory alloc request