Re: PostgreSQL Data Loss

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: PostgreSQL Data Loss
Дата
Msg-id 45BA92E9.3000606@dunslane.net
обсуждение исходный текст
Ответ на PostgreSQL Data Loss  (BluDes <DESPAMMAMIdarocchi@PERFAVOREtiscali.it>)
Список pgsql-hackers
BluDes wrote:
> Hi everyone,
>  I have a problem with one of my costomers.
> I made a program that uses a PostgreSQL (win32) database to save its 
> data.
> My customer claims that he lost lots of data reguarding his own 
> clients and that those data had surely been saved on the database.
> My first guess is that he is the one who deleted the data but wants to 
> blame someone else, obviously I can't prove it.
>
> Could it be possible for PostgreSQL to lose its data? Maybe with a 
> file corruption? Could it be possible to restore these data?
>
> My program does not modify or delete data since its more like a log 
> that only adds information. It is obviously possible to delete these 
> logs but it requires to answer "yes" to 2 different warnings, so the 
> data can't be deleted accidentally.
>
> I have other customers with even 10 times the amount of data of the 
> one who claimed the loss but no problems with them.
> He obviously made no backups (and claims whe never told him to do them 
> so we are responsible even for this) though the program has a 
> dedicated Backup-section.
>
> Any suggestion?
>
>

This isn't any sort of report that can be responded to. We need to know 
what has happened to the machine, what is in the server logs, what are 
the symptoms of data loss. The most likely explanations are pilot error 
and hardware error.

cheers

andrew



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: How does EXEC_BACKEND process signals?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: 10 weeks to feature freeze (Pending Work)