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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
