On Thu, 2008-12-18 at 16:43 -0500, Mark Steben wrote:
> 3. I am currently in a state where a log got partially copied and
> postgres
> cannot find a valid checkpoint to restart. What is the best way to
> remedy
> this situation? Pg_resetxlog perhaps?
Now, pg_resetxlogs, but in future don't delete WAL files that may be
needed for recovery.
You can use
pg_controldata test | grep REDO | cut -d: -f 2
to find out the LSN of the last restartpoint, which can then be
converted into an xlogfilename using pg_xlogfile_name().
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support