Re: Streaming Questions and Sizing

Hi,

So the basebackup pulls the data directory over from the master.

I am pulling over anther copy of the data directory using basebackup

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