Why so long between archive calls?

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Why so long between archive calls?
Дата
Msg-id 1d219a6f0608290835u6647a8e1g437dfd4cedb81658@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why so long between archive calls?
Список pgsql-admin
I am working on getting my development system working with archive logging so I can use the pitr features of Postgres.  However, I am finding that the actual archiving is not keeping up with the generation of the logs.  I am now over 500 wal archive files behind (8+ GB).

What controls how often the archive_command is called?

The actual running of my archive script is taking 1-2 seconds, so I'm not sure why we are so far behind.

Thanks for any advise,

Chris

PG 8.1.3
RH AS 4

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

Предыдущее
От: "Lane Van Ingen"
Дата:
Сообщение: dbsize.so for PostgreSQL 8.1.4 on Red Hat Enterprise Linux 4.0
Следующее
От: "Chris Hoover"
Дата:
Сообщение: Re: dbsize.so for PostgreSQL 8.1.4 on Red Hat Enterprise Linux 4.0