Re: Streaming Questions and Sizing - Mailing list pgsql-general

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@aklaver.com