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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin