On Thu, 2008-12-18 at 16:43 -0500, Mark Steben wrote:
> Hi folks,
> recovery mode, letting the updates catch up for the
> next days processing.
>
> My questions are:
>
> 1. Is this a proper usage of log shipping?
Sure but you will have to run a base backup every night. You can't exit
recovery, run queries, resume recovery. You have to exit recovery, run
queries, perform based backup, resume recovery.
> 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?
>
How did you do that? What are you using to copy the logs? You may want
to look at pitr tools. It will make your life easier:
https://projects.commandprompt.com/public/pitrtools
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
