Re: wal archiving question

Поиск
Список
Период
Сортировка
От akp geek
Тема Re: wal archiving question
Дата
Msg-id CACnhOfLn+UL+gPJ11mrbF0yJ3ZKVjxNuYQ145uQ+t0-d+28mSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: wal archiving question  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: wal archiving question
Список pgsql-general
thank you all. There is a mistake I did then. I created a base backup when I started the DB , that was exactly an year ago. I need to do that again and then delete the old files.

Regards



On Wed, Dec 5, 2012 at 4:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
akp geek <akpgeek@gmail.com> writes:
>  WAL archives is growing, not the files  in pg_xlog.

You need to prune the archives of files that are too old to be
interesting.  This doesn't happen automatically since PG has no
idea what your archiving requirements are.

Be sure to keep WAL files at least back to the start of your
last base backup.  Some people like to keep them back to the
next-to-last base backup.

                        regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: wal archiving question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: wal archiving question