Re: How to simulate crashes of PostgreSQL?

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: How to simulate crashes of PostgreSQL?
Дата
Msg-id 50588aedc05d62961a128a22e47590ef@biglumber.com
обсуждение исходный текст
Ответ на How to simulate crashes of PostgreSQL?  (Sergey Samokhin <prikrutil@gmail.com>)
Ответы Re: How to simulate crashes of PostgreSQL?
Re: How to simulate crashes of PostgreSQL?
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


>> Is there a way to disconnect all the clients as if the server has
>> crashed? It should look like a real crash from the client's point of
>> view.

> ifconfig ethx down ?

Or even:

iptables -I INPUT -p tcp --dport 5432 -j DROP

Keep in mind that both of those are simulating network failures, not
a "server crash". But network failures are something your application
should handle gracefully too. :) To make something look like a real
crash, you should do a real crash. In this case, kill -9 the backend(s).

A server crash is a pretty rare event in the Postgres world, so I
would not spend too many cycles on this...

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200908221849
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkqQd2sACgkQvJuQZxSWSsg6TwCfXMZ/GNi33qc2TyMa4uf1asw8
vVcAn3bUUZMP+cmSNEd5EABH/09gLeE/
=Uowh
-----END PGP SIGNATURE-----


В списке pgsql-general по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: How to simulate crashes of PostgreSQL?
Следующее
От: John DeSoi
Дата:
Сообщение: Re: join from array or cursor