From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Charlie Woloszynski <chw(at)clearmetrix(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PITR status |
Date: | 2003-03-07 22:07:55 |
Message-ID: | 200303072207.h27M7tr02160@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)agliodbs(dot)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(at)postgresql(dot)org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tanu Shankar Bhatnagar | 2003-03-07 22:10:43 | digest mode? |
Previous Message | Stephan Szabo | 2003-03-07 21:56:28 | Re: alter table / permissions |