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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
