Re: Fwd: corrupted files

Поиск
Список
Период
Сортировка
От Klaus Ita
Тема Re: Fwd: corrupted files
Дата
Msg-id CAGrfkYOZBaojn1xbPuV9s24hMeQJ21jQqu+5LozOEU8uL3yprA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: corrupted files  (bricklen <bricklen@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Ingmar Brouns
Дата:
Сообщение: Re: to_char with locale decimal separator
Следующее
От: sidthegeek
Дата:
Сообщение: Re: How get column-wise table info from an arbitrary query?