Re: PITR status

PITR is months away.

---------------------------------------------------------------------------

Charlie Woloszynski wrote:
> Can anyone comment on the status of point-in-time recovery (PITR?)  I  
> am looking to move an application over to PostgreSQL onto a Mac (I'll  
> try to avoid the divide-by-zero issue :-) ) and PITR would really help  
> the backup/recovery plan to accept PostgreSQL as a solution with fast  
> recovery times.
> 
> Thanks,
> 
> Charlie
> 
> 
> On Friday, March 7, 2003, at 02:43 PM, Tom Lane wrote:
> 
> > Josh Berkus <josh@agliodbs.com> writes:
> >> So ... the workaround for 7.2.4 would be to have a server-side script  
> >> hunt for
> >> idle connections after shutdown and kill -9 them?
> >
> > Yuck.  I'd recommend back-porting the patch to 7.2 instead; should be
> > easy enough:
> > http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/ 
> > commands/async.c.diff?r1=1.91&r2=1.92
> >
> > Now, if you can reproduce the problem even with that patch in place,  
> > I'm
> > very interested in looking at the state of the system ...
> >
> > 			regards, tom lane
> >
> > ---------------------------(end of  
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to  
> > majordomo@postgresql.org
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073