Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: corrupted files - Mailing list pgsql-general

From Klaus Ita
Subject Re: Fwd: corrupted files
Date
Msg-id CAGrfkYOZBaojn1xbPuV9s24hMeQJ21jQqu+5LozOEU8uL3yprA@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: corrupted files  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:

On Tue, Jul 30, 2013 at 8:18 AM, Klaus Ita <klaus@worstofall.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?


pgsql-general by date:

Previous
From: Ingmar Brouns
Date:
Subject: Re: to_char with locale decimal separator
Next
From: sidthegeek
Date:
Subject: Re: How get column-wise table info from an arbitrary query?