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