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?
>
>
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 |
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 |