Skip site navigation (1) Skip section navigation (2)

Re: Warm Standby - log shipping

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Warm Standby - log shipping
Date: 2008-12-18 22:20:35
Message-ID: 1229638835.7559.15.camel@jd-laptop.pragmaticzealot.org (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Michael MonnerieDate: 2008-12-18 23:18:20
Subject: Re: DROP INDEX causes errors
Previous:From: Kevin GrittnerDate: 2008-12-18 22:19:38
Subject: Re: Warm Standby - log shipping

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group