Re: Streaming Questions and Sizing

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Streaming Questions and Sizing
Дата
Msg-id 5594B929.8020906@aklaver.com
обсуждение исходный текст
Ответ на Re: Streaming Questions and Sizing  (Andy Erskine <andy.erskine@jds.net.au>)
Ответы Re: Streaming Questions and Sizing  (Andy Erskine <andy.erskine@jds.net.au>)
Список pgsql-general
On 07/01/2015 05:51 PM, Andy Erskine wrote:
> If i grep for errors i get some invalid page header in block 56072 of
> relation base/16385/77373 errors.
>
> But not sure what else to look for ?

Well the above seems to be the smoking gun. You have a corrupted $DATA
directory in the standby and the WAL logs being streaming from the
master are stacking up on the standby because it can not process them.
You need to shut down the standby and start over on setting up its $DATA
directory.

Just to clarify. From your previous post:

"I initially populated the directory using basebackup and pulled the
data directory across from the master."

So did you do a basebackup and then copy the data data directory over,
or where you saying the basebackup is how you pulled over the data
directory?


>

>
>
> --
>
> *Andy Erskine*
>
> **
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Andy Erskine
Дата:
Сообщение: Re: Streaming Questions and Sizing
Следующее
От: Andy Erskine
Дата:
Сообщение: Re: Streaming Questions and Sizing