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.kla...@aklaver.com> 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.kla...@aklaver.com >> <mailto: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 <mailto:adrian.kla...@aklaver.com> >> >> >> >> >> -- >> >> *Andy Erskine* >> >> ** >> >> *JDS Australia** >> **P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578 >> >> *E:*_andy.ersk...@jds.net.au <mailto:andy.ersk...@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.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]
