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

From Andy Erskine
Subject Re: Streaming Questions and Sizing
Date
Msg-id CADqp7UBztF_LAy2uH-RqVUMo8fo-XBhcyX8n+Cu2vMjffGY2iw@mail.gmail.com
Whole thread Raw
In response to Re: Streaming Questions and Sizing  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Streaming Questions and Sizing
Next
From: Urs Berner
Date:
Subject: Re: Ubuntu 14.04 LTS install problem