Re: PITR Backups

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: PITR Backups
Дата
Msg-id 1182788599.9276.598.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: PITR Backups  (Dan Gorman <dgorman@hi5.com>)
Список pgsql-performance
On Mon, 2007-06-25 at 08:28 -0700, Dan Gorman wrote:
> I took several snapshots. In all cases the FS was fine. In one case
> the db looked like on recovery it thought there were outstanding
> pages to be written to disk as seen below and the db wouldn't start.
>
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [9-1] 2007-06-21
> 00:39:43 PDTLOG:  redo done at 71/99870670
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [10-1] 2007-06-21
> 00:39:43 PDTWARNING:  page 28905 of relation 1663/16384/76718 was
> uninitialized

OK, please put log_min_messages = DEBUG2 and re-run the recovery please.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



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

Предыдущее
От: Dan Gorman
Дата:
Сообщение: Re: PITR Backups
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PITR Backups