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.