Warm Standby looking for already applied log files

Поиск
Список
Период
Сортировка
От Colin Wilson
Тема Warm Standby looking for already applied log files
Дата
Msg-id A51C2757-6A50-4E0A-B1C9-6E07CD4393A9@blackducksoftware.com
обсуждение исходный текст
Ответы Re: Warm Standby looking for already applied log files  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Hello all,
We have a two Postgres servers running 8.3 set up for warm standby using xlog shipping.  We had some problems with our warm standby locking up and needing to be rebooted and have grub reinstalled for the system to boot.  Once the server was back up we noticed the xlog file it was looking for was one that the logs say was already applied.  It was 7 xlogs back to be exact.  We have our log shipping target replay the xlogs and then delete them when it is done so we don't have these old 7 to move back so Postgres can replay them.  Is Postgres looking for an older xlog as part of its start up consistency check?  If the xlogs were really applied as we can see in the logs can we skip over the next 7 some how to get the system to start applying the logs we have?  Thanks for the help.

--Colin

Colin Wilson
Linux Systems Administrator

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

Предыдущее
От: "PriceGoblin Accounts"
Дата:
Сообщение: Re: Should autovacuum do a database wide vacuum near transaction limit?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Warm Standby looking for already applied log files