-----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@xxxxxxxxxxxx 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general