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:
Does the log for the secondary show anything unusual?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 ?
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
W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
