Search Postgresql Archives

Re: Streaming Questions and Sizing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>




--

*Andy Erskine*

**

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

*E:*_andy.erskine@xxxxxxxxxx <mailto:andy.erskine@xxxxxxxxxx>_

*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@xxxxxxxxxxx



--

Andy Erskine

 

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

E: andy.erskine@jds.net.au

Wwww.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001

JDS Signature v1


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux