Re: How to find calculated CRC checksum of pg_controldata

On 4/9/2014 11:44 AM, Bruce Momjian wrote:
> On Thu, Apr  3, 2014 at 08:58:26AM -0500, Matthew Rantala wrote:
>> Hello,
>>
>> Question: Is there a way to obtain the calculated CRC checksum for
>> pg_controldata from the command line?
> Did you try pg_resetxlog?  That should set the checksum properly.
>
Thanks, Bruce

I think I actually tried that and while it did correct the checksum, I
think it also closed/finalized the first log file
(00000001000000000000001) and modified the checkpoint locations which
wasn't going to work in my recovery. There may be a way to avoid that by
passing the correct parameters, but I found digging into the source code
easier.

Thanks again,

Matt

--

Matthew J Rantala, GISP
Minnesota Geological Survey
University of Minnesota
2642 University Ave.
St. Paul, MN 55114-1057
(612) 627-4780 x206