Re: truncate transaction log

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: truncate transaction log
Дата
Msg-id dcc563d10708070847t5aab9713t65c79dacb1d9a848@mail.gmail.com
обсуждение исходный текст
Ответ на truncate transaction log  (Sergei Shelukhin <realgeek@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 8/5/07, Sergei Shelukhin <realgeek@gmail.com> wrote:
> Hi.
>
> Is there any way to truncate WAL log in postgres?
> We want to use full-backup strategy where we stop the server and copy
> the data directory, however WAL log is taking dozens gigabytes of
> spaces.
> Is there any way to remove it while keeping the database operational/
> restore-able by copying it back?

This sounds unusually high.  What non-default settings are there in
your postgresql.conf file?  Are you using PITR or something like that?

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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: finding out vacuum completion %, and vacuum VS vacuum full
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: How do I connect postgres table structures and view structures to an existing svn repository?