Re: kill -2 - Mailing list pgsql-general

From scott.marlowe
Subject Re: kill -2
Date
Msg-id Pine.LNX.4.33.0404211358230.22303-100000@css120.ihs.com
Whole thread Raw
In response to kill -2  (Jord Tanner <jord@indygecko.com>)
Responses Re: kill -2
List pgsql-general
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.


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Unicode problem ???
Next
From: Joe Conway
Date:
Subject: Re: [OT] Tom's/Marc's spam filters?