Re: [HACKERS] Point in Time Recovery
От | Gaetano Mendola |
---|---|
Тема | Re: [HACKERS] Point in Time Recovery |
Дата | |
Msg-id | 40F8F3BB.8030002@bigfoot.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] Point in Time Recovery (Simon Riggs <simon@2ndquadrant.com>) |
Список | pgsql-admin |
Simon Riggs wrote: > On Wed, 2004-07-14 at 03:31, Christopher Kings-Lynne wrote: > >>Can you give us some suggestions of what kind of stuff to test? Is >>there a way we can artificially kill the backend in all sorts of nasty >>spots to see if recovery works? Does kill -9 simulate a 'power off'? >> > > > I was hoping some fiendish plans would be presented to me... > > But please start with "this feels like typical usage" and we'll go from > there...the important thing is to try the first one. > > I've not done power off tests, yet. They need to be done just to > check...actually you don't need to do this to test PITR... > > We need to exhaustive tests of... > - power off > - scp and cross network copies > - all the permuted recovery options > - archive_mode = off (i.e. current behaviour) > - deliberately incorrectly set options (idiot-proof testing) If you write also how to perform these tests it's also good in order to show which problem PITR is addressing, I mean I know that is addressing a power off but how I will recover it ? Regards Gaetano Mendola
В списке pgsql-admin по дате отправления: