Re: How to simulate crashes of PostgreSQL?

From: Sergey Samokhin <prikrutil(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to simulate crashes of PostgreSQL?
Date: 2009-08-24 20:36:49
Message-ID: e42595410908241336k3c74cae5y5c4ce0b77b77c982@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

> You should also test your client's response to the Pg server remaining
> up but becoming non-responsive (eg: failed disk array causes Pg backends
> to remain in uninterruptable disk I/O system calls in the kernel). A
> possibly good way to do this is to SIGSTOP the backend(s).

I haven't thought about it yet. It's possible the place where I should
use timeouts on the operations involving calls to PostgreSQL.

--
Sergey Samokhin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-24 20:39:57 Re: R: Field's position in Table
Previous Message Sergey Samokhin 2009-08-24 20:31:18 Re: What approach should I use instead of creating tables on the fly?