Re: Streaming Questions and Sizing

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

> 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 <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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 :
>>
>> 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
>> 4.0K ./base/pgsql_tmp
>> 6.3M ./base/1
>> 6.4M ./base/12870
>> 127G ./base
>> 764K ./pg_stat_tmp
>> 4.0K ./pg_tblspc
>> 364K ./pg_xlog/archive_status
>> 8.1G ./pg_xlog
>> 2.2M ./global
>> 4.0K ./pg_serial
>> 4.0K ./pg_snapshots
>> 4.0K ./pg_twophase
>> 137G .
>>
>> And the secondary :
>>
>> data]$ du -h
>> 6.4M ./base/12870
>> 4.0K ./base/pgsql_tmp
>> 6.3M ./base/1
>> 141G ./base/16385
>> 6.3M ./base/12865
>> 141G ./base
>> 12K ./pg_multixact/offsets
>> 232K ./pg_multixact/members
>> 248K ./pg_multixact
>> 348K ./pg_xlog/archive_status
>> 79G ./pg_xlog
>> 2.1M ./global
>> 4.0K ./pg_serial
>> 4.0K ./pg_snapshots
>> 4.0K ./pg_twophase
>> 12K ./pg_notify
>> 7.8M ./pg_clog
>> 288K ./pg_stat_tmp
>> 4.0K ./pg_tblspc
>> 68K ./pg_subtrans
>> 53M ./pg_log
>> 220G .
>>
>> So we have 80GB in the pg_xlog on the secondary ?
>>
>>
>> Does the log for the secondary show anything unusual?
>>
>> Also how did you set up the secondary?
>>
>> In other words how did you populate the $DATA directory?
>>
>>
>>
>> pg_xlog]$ du -h
>> 364K ./archive_status
>> 8.1G .
>>
>> pg_xlog]$ du -h
>> 348K ./archive_status
>> 79G .
>>
>>
>>
>>
>> --
>>
>> *Andy Erskine*
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>>
>> --
>>
>> *Andy Erskine*
>>
>> **
>>
>> *JDS Australia**
>> **P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578
>>
>> *E:*_andy(dot)erskine(at)jds(dot)net(dot)au <mailto:andy(dot)erskine(at)jds(dot)net(dot)au>_
>>
>> *W*: www.jds.net.au <http://www.jds.net.au/>
>> Level 8, 2 Russell Street, Melbourne, VIC 3000
>> GPO Box 4777, Melbourne VIC 3001
>>
>> JDS Signature v1
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--

*Andy Erskine*

*JDS Australia*
*P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578

*E:* *andy(dot)erskine(at)jds(dot)net(dot)au <andy(dot)erskine(at)jds(dot)net(dot)au>*

*W*: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001

[image: JDS Signature v1]