Re: Streaming Questions and Sizing

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(dot)klaver(at)aklaver(dot)com