Re: Streaming Questions and Sizing - Mailing list pgsql-general
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.klaver@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.klaver@aklaver.com
Andy Erskine
JDS Australia
P 1300 780 432 | M 0431919301 | F 03 90124578
E: andy.erskine@jds.net.au
W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
Attachment
pgsql-general by date: