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

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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>
> --
>
> *Andy Erskine*
>
> **
>
> *JDS Australia**
> **P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578
>
> *E:*_andy.erskine@jds.net.au <mailto:andy.erskine@jds.net.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.klaver@aklaver.com