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 ? pg_xlog]$ du -h 364K ./archive_status 8.1G . pg_xlog]$ du -h 348K ./archive_status 79G . On 1 July 2015 at 23:59, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 07/01/2015 06:56 AM, Andy Erskine wrote: > >> /opt/database on both servers has been assigned 250gb only postgres has >> been installed on them. >> >> I cannot get the output you requested til back at work. >> > > When you do, post that information to the list. > > >> Cheers. >> >> > > -- > 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]