Re: Streaming Questions and Sizing - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Streaming Questions and Sizing
Date
Msg-id 5594B929.8020906@aklaver.com
Whole thread Raw
In response to Re: Streaming Questions and Sizing  (Andy Erskine <andy.erskine@jds.net.au>)
Responses Re: Streaming Questions and Sizing  (Andy Erskine <andy.erskine@jds.net.au>)
List 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 by date:

Previous
From: Andy Erskine
Date:
Subject: Re: Streaming Questions and Sizing
Next
From: Andy Erskine
Date:
Subject: Re: Streaming Questions and Sizing