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.kla...@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.kla...@aklaver.com > -- *Andy Erskine* *JDS Australia* *P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578 *E:* *andy.ersk...@jds.net.au <andy.ersk...@jds.net.au>* *W*: www.jds.net.au Level 8, 2 Russell Street, Melbourne, VIC 3000 GPO Box 4777, Melbourne VIC 3001 [image: JDS Signature v1]
