Re: PITR recover ends unexpected

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: PITR recover ends unexpected
Дата
Msg-id 20051107184909.GA19551@pervasive.com
обсуждение исходный текст
Ответ на PITR recover ends unexpected  (Bernd Rieke <bernd@rhm.de>)
Список pgsql-admin
Next time it happens please post the exact error message, and keep all
the files that are involved.

On Fri, Nov 04, 2005 at 10:43:16PM +0100, Bernd Rieke wrote:
> Hi,
> since some month we use PITR and it works fine. We make a base backup
> once a week. For testing if everything will work when needed we replay
> the wal files every day to the base backup on a second machine. It works
> fine except for two time when we saw a strange problem. The recovery
> process stated a zero length record in the wal file and stop 'as
> expected' as it told us. The recovered database was useable but we had a
> gap in the recovered data from the time it stops replaying wal files up
> to the next base backup. We didn't see any hardware problems or problems
> while copying the wal files to the second machine. So our question is if
> anybody out there saw a similar problem.
>
> Thanks in advance for your replies
>
> Bernd Rieke
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: [webmaster] How can I join in the PostgreSql developing team ?
Следующее
От: "Tomeh, Husam"
Дата:
Сообщение: DB Links in Postgres?