Re: Streaming Questions and Sizing

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

--

*Andy Erskine*

*JDS Australia*
*P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578

*E:* *andy(dot)erskine(at)jds(dot)net(dot)au <andy(dot)erskine(at)jds(dot)net(dot)au>*

*W*: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001

[image: JDS Signature v1]