From: | Charlie Woloszynski <chw(at)clearmetrix(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Charlie Woloszynski <chw(at)clearmetrix(dot)com> |
Subject: | PITR status |
Date: | 2003-03-07 21:12:10 |
Message-ID: | 76110B13-50E1-11D7-9A74-000A95666CAA@clearmetrix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2003-03-07 21:13:30 | alter table / permissions |
Previous Message | Ivan | 2003-03-07 20:56:00 | 2 temp tables |