Re: wal archiving question

From: akp geek <akpgeek(at)gmail(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal archiving question
Date: 2012-12-05 20:43:09
Message-ID: CACnhOfKnakXMKh=U_vy=+X+xcb-B7Ax0GHE3rPkpeFaQo4DHbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

WAL archives is growing, not the files in pg_xlog.

Regards

On Wed, Dec 5, 2012 at 3:38 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> akp geek wrote:
> > We have postgres 9.0.4 since an year. Replication also set up and works
> fine.
> > On the master. The wal files are growing and it's almost gone to 90% of
> the disk.
> > How can I handle the situation. Can I delete the old files. Please
> advice
>
> Are the WAL files (the ones in pg_xlog) growing or the WAL archives?
>
> If the former, then you maybe got an archiving problem
> (consult the server log).
>
> If the latter, you'd have to manually delete some,
> but take care that you don't delete any that you still
> need either for restoring a backup or for the standby to
> catch up.
>
> Yours,
> Laurenz Albe
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-12-05 21:25:48 Re: wal archiving question
Previous Message Albe Laurenz 2012-12-05 20:38:03 Re: wal archiving question