Re: Warm Standby - log shipping

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