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