Re: pg_standby stuck on a wal file size <16MB

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: pg_standby stuck on a wal file size <16MB
Дата
Msg-id 65937bea0805201956r9884e9vbb59470c5bef6a2a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_standby stuck on a wal file size <16MB  (Vlad Kosilov <vkosilov@contigo.com>)
Список pgsql-general
On Wed, May 21, 2008 at 4:14 AM, Vlad Kosilov <vkosilov@contigo.com> wrote:
as Greg pointed out: my use of rsync --remove-sent-files option had contributed to a short sized wal log file on standby.
changing master's postgres crontab to the following helped to resolve the issue:

# ship logs to standby:
*/2     * * * * rsync -aq /wal_archive_local/ 10.10.10.12::wal_archive/
# remove files older then remove_check file mtime
*/5     * * * * find /wal_archive_local/ ! -newer /wal_archive_local/remove_check -exec rm -f {} \; && touch /wal_archive_local/remove_check


Hmmm, nice trick.

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Следующее
От: "Andy Dale"
Дата:
Сообщение: Re: Server Configuration