Re: Patch for fail-back without fresh backup - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Patch for fail-back without fresh backup
Date
Msg-id CABOikdOeix_kxCAj_YKow+Odx89rVxGgWqbHG2V6TBRkPUQRnA@mail.gmail.com
Whole thread Raw
In response to Re: Patch for fail-back without fresh backup  (Benedikt Grundmann <bgrundmann@janestreet.com>)
List pgsql-hackers



On Fri, Jun 14, 2013 at 2:51 PM, Benedikt Grundmann <bgrundmann@janestreet.com> wrote:
 
A alternative proposal (which will probably just reveal my lack of understanding about what is or isn't possible with WAL).  Provide a way to restart the master so that it rolls back the WAL changes that the slave hasn't seen.   

WAL records in PostgreSQL can only be used for physical redo. They can not be used for undo. So what you're suggesting is not possible though I am sure a few other databases do that.

Thanks,
Pavan

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Patch for fail-back without fresh backup
Next
From: Heikki Linnakangas
Date:
Subject: Re: Patch for fail-back without fresh backup