Re: Streaming Questions and Sizing

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