From: | Matthew Rantala <mjrantal(at)umn(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to find calculated CRC checksum of pg_controldata |
Date: | 2014-04-10 17:38:10 |
Message-ID: | 5346D702.7010308@umn.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2014-04-10 18:41:18 | Re: [pgsql-es-ayuda] PGBOUNCER CONFIG |
Previous Message | Juan J Rosales Rodriguez | 2014-04-10 14:59:19 | PGBOUNCER CONFIG |