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