| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Why is my pg_xlog directory so huge? |
| Date: | 2013-03-18 09:26:17 |
| Message-ID: | CABUevEzBZFjMz_UwiPuxfd1C-9ShutnRWtj5H6yy_1sYWnKy4A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Mar 18, 2013 at 10:14 AM, Niels Kristian Schjødt
<nielskristian(at)autouncle(dot)com> wrote:
> After installing my new server I just discovered something that doesn't seem right:
>
> sudo du -h /var/lib/postgresql/9.2/main
<snip>
> As you can see the pg_xlog folder is 202G, which is more than my entire database - this seems wrong to me, however I have no clue why this would happen.
My first guess would be that your archive_command is failing - so
check your logs for that. If that command fails, no xlog files will
ever be rotated (since it would invalidate your backups).
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Kristian Schjødt | 2013-03-18 14:08:42 | Re: Why is my pg_xlog directory so huge? |
| Previous Message | Niels Kristian Schjødt | 2013-03-18 09:14:52 | Why is my pg_xlog directory so huge? |