<div class="im">On Sun, Feb 13, 2011 at 2:17 PM, Melvin Davidson <span dir="ltr"><<a href="mailto:melvin6925@yahoo.com" target="_blank">melvin6925@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font: inherit;" valign="top"><div><div>>OK, same thing happened: disk usage on the <span class="il">Slony</span> slave is now 96%, and<br>
>this is while COPY of our large table (over 45 GB in size) is running.<br>
> 106 GB is used on disk.<br>
<br>
>Any suggestions, please?<br>
<br></div></div>
Is WAL archiving enabled on the slave? If so, turn it off, restart postgresql on the slave, then try replicating.<br></td></tr></tbody></table></blockquote></div><br>Thanks, Melvin. WAL archiving is disabled on both servers. (archive_mode = off).<br>
<br>How much disk space should I expect Postgres (8.4.4) to use when receiving a 45 GB table via <span class="il">Slony</span>?<br><br>Best,<br>Aleksey