From: Nicola Mauri <nicola.mauri@saga.it>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Crash with data corruption under Windows
Date: Mon, 23 Feb 2009 19:18:18 +0100
Message-ID: <49A2E86A.60409@saga.it> (raw)
In-Reply-To: <dcc563d10902230907pf20a56bs3ce25bb73a6e44ff@mail.gmail.com>
References: <499EBEF0.1010408@saga.it>
<dcc563d10902200814l6c43566fkc1ea70ceb93631a1@mail.gmail.com>
<49A2D39F.7060203@saga.it>
<dcc563d10902230907pf20a56bs3ce25bb73a6e44ff@mail.gmail.com>
-------- Messaggio Originale --------
Oggetto: Re: [ADMIN] Crash with data corruption under Windows
Da: Scott Marlowe <scott.marlowe@gmail.com>
> On Mon, Feb 23, 2009 at 9:49 AM, Nicola Mauri <nicola.mauri@saga.it> wrote:
>
>> -------- Messaggio Originale --------
>> Oggetto: Re: [ADMIN] Crash with data corruption under Windows
>> Da: Scott Marlowe <scott.marlowe@gmail.com>
>>
>>> Usually when I see the permission denied thing there's anti-virus
>>> software hard locking pgsql files in the middle of the day.
>>>
>>>
>> Have you experienced data loss too in that case?
>> (however, we already excluded pgsql directories from anti-virus scanning).
>>
>
> I've not, but I rarely run postgresql under windows. When we do it's
> on a laptop for personal use / demo use. All our servers run Linux.
> However, on this list, when I've seen this happen, it has been known
> to result in data loss.
>
> Note that once your database is corrupted, no amount of fixing can
> make it safe to keep using. you need to get a good reliable dump from
> it, reinitdb and reload your data. So not trust a database that's
> gotten corrupted and seems mostly fixed. It's a timebomb.
>
>
Hi Scott,
we had to recreate the cluster and reload data from a dump, because we
were unable to read any table (some critical indexes was broken).
However we would like to try to recovery the most recent data from the
corrupted datafiles (as a help for manual insertion). Is there any
method to extract raw data from the pgsql table files?
regards,
Nicola
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nicola.mauri@saga.it, scott.marlowe@gmail.com
Subject: Re: Crash with data corruption under Windows
In-Reply-To: <49A2E86A.60409@saga.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox