Re: lesslog "incorrect resource manager data checksum."

Поиск
Список
Период
Сортировка
От Koichi Suzuki
Тема Re: lesslog "incorrect resource manager data checksum."
Дата
Msg-id a778a7260811191604j456098abhd11e8d9539e31212@mail.gmail.com
обсуждение исходный текст
Ответ на lesslog "incorrect resource manager data checksum."  ("Jean-Christophe Arnu" <jcarnu@gmail.com>)
Ответы Re: lesslog "incorrect resource manager data checksum."  ("Jean-Christophe Arnu" <jcarnu@gmail.com>)
Список pgsql-general
Hi,

Sorry I was out and late to find your report.

Lesslog replaces full page write to corresponding incremental log to
decrease the size and so you should turn full_page_writes "on" for
lesslog to work.

Did you specify "pg_decpmpresslog" as restore command?  If so, I don't
see anything missing so far.   Pg_decompresslog must be used in place
of "cat".

If possible, could you try to share your archive log (a part may help)
and let me know how you built lesslog?  (Did you use rpm?)   They will
help.   I've tested lesslog against pgbench and DBT-2 so I believe the
coverage is reasonable.

Sorry for the inconvenience and thanks a lot for your help.

---------
Koichi Suzuki

2008/11/18 Jean-Christophe Arnu <jcarnu@gmail.com>:
> Hi,
>
> I'm trying to use lesslog 1.1 (out of NTT rpm available on pgfoundry) on my
> pg_xlog files out of a 8.3.3 postgresql server.
> I always get messages such as "incorrect resource manager data checksum."
>
> This message is issued (as I've read the sources) when there's CRC mismatch
> in a record.
>
> Do you have any idea of what's going wrong (i.e. why my CRC are not
> matching)? Does this deals with full_page_writes to be set to on (by default
> in GUC)  which is commented in my GUC (thus set to on) ? Is there something
> missing?
>
> Note : I'm transferring my xlog to another node with rsync. The log I get (a
> bunch of) for my test purpose are the ones on the remote node, they should
> be exactly the same as the one on the server.
>
> Thanks by advance for any ideao!
>
> --
> Jean-Christophe Arnu
>

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

Предыдущее
От: Scara Maccai
Дата:
Сообщение: Re: return MAX and when it happened
Следующее
От: novice
Дата:
Сообщение: date range query help