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