Search Postgresql Archives

Re: Streaming Questions and Sizing

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

 



I initially populated the directory using basebackup and pulled the data directory across from the master.

On 2 July 2015 at 10:13, Adrian Klaver <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



--

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