Re: Recovery Features
От | Simon Riggs |
---|---|
Тема | Re: Recovery Features |
Дата | |
Msg-id | 1089069746.17493.142.camel@stromboli обсуждение исходный текст |
Ответ на | Re: Recovery Features (Mike Mascari <mascarm@mascari.com>) |
Ответы |
Re: Recovery Features
|
Список | pgsql-hackers |
On Mon, 2004-07-05 at 23:40, Mike Mascari wrote: > Simon Riggs wrote: > > > > > ...Nobody is shouting YES, so its a dodo... > > The point at which the above process becomes > too complex (or less than obvious) for hand-recovery is precisely > when unforeseen consequences of nixing a single transaction become > too great. > Agreed. The potential for unforeseen consequences is just too high, and although I'm fairly sure they would always be spotted during recovery and cause an error - I think it is something that requires proof. And I don't have that. So, lets leave that idea alone for 100 years. > ... hand-recovery ... hmmm...not sure I know what you mean. It is very-very-close-to-impossible to edit the transaction logs manually, unless some form of special-format editor were written for the purpose. Is it clear that the PITR features are completely different from pg_dump? (Which would allow a manual edit and recover). The xlogs are binary files that refer to all changes to all tables in a cluster ordered by time, rather than by table. Best regards, Simon Riggs
В списке pgsql-hackers по дате отправления: