On Thu, 2006-12-14 at 19:10 -0500, Tom Lane wrote: 
> You'd have to modify pg_resetxlog to force that value into the sysid
> rather than whatever is there.  Hand-editing wouldn't work very well
> because of (a) the CRC on pg_control and (b) the need to copy the
> value into extant WAL segments.

Well, I ended up just using the pg_control file from the running
installation. The seemed to work in combination with pg_resetxlog but
now the restore is not working because the postmaster has a shutdown
timestamp of today's date and the recovery is thinking that it has
already recovered past the proper point in time. :(

Does anyone know how I can convince the postmaster to believe it was
shutdown at approximately the time the pg_dumpall happened?

Thank you all again for any assistance!

-- 
Joshua Colson <[EMAIL PROTECTED]>
iNation, LLC


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to