PITR status
Charles H. Woloszynski <chw@clearmetrix.com>
From: Charlie Woloszynski <chw@clearmetrix.com>
To: pgsql-general@postgresql.org
Cc: Charlie Woloszynski <chw@clearmetrix.com>
Date: 2003-03-07T21:12:10Z
Lists: pgsql-general
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