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.