On Fri, 2004-05-28 at 00:02, Peter Galbavy wrote:
> Bruno Wolff III wrote:
> > For long running transactions where you want to recover as much as possible,
> > one might also want to recover up until just before a specific transaction
> > committed (as opposed to started).
> If your DB has died and you are recovering it, how do you reestablish a
> session so that a transaction can complete ? Doesn't all client
> connections assume that a transaction has failed if the connection to
> the DB fails ?
You re-establish connection, but cannot resume the failed transaction.
PostgreSQL already has crash recovery...this is for restore from backup
Best Regards, Simon Riggs
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2004-04-27 22:46:34|
|Subject: Re: [HACKERS] What can we learn from MySQL?|
|Previous:||From: Simon Riggs||Date: 2004-04-27 22:35:40|
|Subject: Re: PITR Phase 2 - Design Planning|