Re: Fwd: corrupted files

From: Klaus Ita <klaus(at)worstofall(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: raghu ram <raghuchennuru(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fwd: corrupted files
Date: 2013-07-30 15:37:58
Message-ID: CAGrfkYOZBaojn1xbPuV9s24hMeQJ21jQqu+5LozOEU8uL3yprA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

i guess logical, caused by whatever. i really cannot say, the wal files all
*look* ok, still, they lead to a situation that's a definite dead end.
we did have a hard-drive failure (one in 13) at the time, but due to raid5
+ hot spare no data should have been corrupted. i mean it's an lsi
controller, ... not fond of it, but it's not bad stuff.

lg,k

On Tue, Jul 30, 2013 at 5:29 PM, bricklen <bricklen(at)gmail(dot)com> wrote:

>
> On Tue, Jul 30, 2013 at 8:18 AM, Klaus Ita <klaus(at)worstofall(dot)com> wrote:
>
>>
>> thank you! It turned out that really there was a corruption in the main
>> pg server which was 'virally' propagated to
>>
>> 1. streaming replica
>> 1. replaying wal receiver
>> 1. old backup that tried to replay the wal's
>>
>> I really thought with a master and 3 backups i'd be safe.
>>
>
>
> Physical corruption in the master, or logical?
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2013-07-30 16:17:27 Re: [BUGS] Incorrect response code after XA recovery
Previous Message bricklen 2013-07-30 15:29:11 Re: Fwd: corrupted files

Browse pgsql-general by date

  From Date Subject
Next Message Giuseppe Broccolo 2013-07-30 15:56:16 Re: Alter table never finishes
Previous Message Ingmar Brouns 2013-07-30 15:34:54 Re: to_char with locale decimal separator