Re: kill -2

On Wed, 21 Apr 2004, Jord Tanner wrote:

> 
> Greetings,
> 
> Does anyone know what the effect of sending an INT signal (kill -2) to
> each of:
>         - pg backend
>         - psql running an insert or select into
>         - Perl script with DBI connection to pg, running insert or
>         select into
>         - vacuumdb
> 
> I'm getting some database corruption, and I'm wondering if the use of
> 'kill -2' could be the cause. 

No, kill -2 should not cause corruption.

About once a month we get someone on the lists getting corruption.  almost 
every time it's either a bad hard drive, memory, or system/cpu/mobo 
causing it.  Have you tested your memory (memtest86) or drives (badblocks 
on linux) to make sure they aren't the cause of your problem?  Just 
because a server is new doesn't mean it's free of all flaws.