From: Scott Marlowe <scott.marlowe@gmail.com>
To: Nicola Mauri <nicola.mauri@saga.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: Crash with data corruption under Windows
Date: Mon, 23 Feb 2009 10:07:11 -0700
Message-ID: <dcc563d10902230907pf20a56bs3ce25bb73a6e44ff@mail.gmail.com> (raw)
In-Reply-To: <49A2D39F.7060203@saga.it>
References: <499EBEF0.1010408@saga.it>
<dcc563d10902200814l6c43566fkc1ea70ceb93631a1@mail.gmail.com>
<49A2D39F.7060203@saga.it>
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.
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: scott.marlowe@gmail.com, nicola.mauri@saga.it
Subject: Re: Crash with data corruption under Windows
In-Reply-To: <dcc563d10902230907pf20a56bs3ce25bb73a6e44ff@mail.gmail.com>
* 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