Re: wal archiving question

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "akp geek *EXTERN*" <akpgeek(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal archiving question
Date: 2012-12-05 20:38:03
Message-ID: A737B7A37273E048B164557ADEF4A58B05784ADA@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 akp geek 2012-12-05 20:43:09 Re: wal archiving question
Previous Message Kevin Grittner 2012-12-05 20:32:52 Re: wal archiving question