Re: wal archiving question

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "akp geek" <akpgeek(at)gmail(dot)com>,"pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal archiving question
Date: 2012-12-05 20:32:52
Message-ID: 20121205203252.142840@gmx.com
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

Replicating how? Are these WAL files in the pg_xlog directory, the
location your archive script copies them to, or somewhere else?
What is your overall backup strategy? How many base backups do you
keep, how far back? What sort of recovery options do you need
(e.g., point in time recovery to any point in the last year, or
something less extreme?)

-Kevin

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-12-05 20:38:03 Re: wal archiving question
Previous Message akp geek 2012-12-05 20:12:00 wal archiving question