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.
>
>
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
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 ?
On 2 July 2015 at 10:41, Adrian Klaver wrote:
> On 07/01/2015 05:20 PM, Andy Erskine wrote:
>
>> I initially populated the directory using basebackup and
On 07/01/2015 05:20 PM, Andy Erskine wrote:
I initially populated the directory using basebackup and pulled the data
directory across from the master.
So what does the standby log show?
On 2 July 2015 at 10:13, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 07/01/2015 05:04
I initially populated the directory using basebackup and pulled the data
directory across from the master.
On 2 July 2015 at 10:13, Adrian Klaver wrote:
> On 07/01/2015 05:04 PM, Andy Erskine wrote:
>
>> the cmd you listed did work it didn't like the -d option
>>
>> however on the master :
>>
>>
On 07/01/2015 05:04 PM, Andy Erskine wrote:
the cmd you listed did work it didn't like the -d option
however on the master :
data]$ du -h
7.9M./pg_clog
168K./pg_subtrans
232K./pg_multixact/members
120K./pg_multixact/offsets
356K./pg_multixact
12K ./pg_notify
1.9G./pg
the cmd you listed did work it didn't like the -d option
however on the master :
data]$ du -h
7.9M./pg_clog
168K./pg_subtrans
232K./pg_multixact/members
120K./pg_multixact/offsets
356K./pg_multixact
12K ./pg_notify
1.9G./pg_log
127G./base/16385
6.3M./base/12865
On 07/01/2015 06:24 AM, Andy Erskine wrote:
CCing list
Yes that's configured on the master
So the segments would pile up there not on the standby. You do not say
what OS you are using, but if it is a Unixen variation, then run:
du -h
on the master and standby directories to see where the
On 06/30/2015 09:14 PM, Andy Erskine wrote:
I have db of 123GB Currently and this is streaming to a secondary DB
which also shows a size of 123GB (Using pgAdmin)
The db's both reside on a 250GB directorys and on the Master i'm using
60% of capacity which seems expected
On the secondary i am usin
