Re: Streaming Questions and Sizing

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