Earlier in the week, I sent out a message suggesting that we should
try to come up with a more automated way of collecting test results
from Slony-I testing.

I did a bit of rummaging around to see what the BuildFarm does; here's
a (perhaps overly flat) schema that captures all of what has come to
mind thus far.

-----------------------------------------------------------------------------
create table slony_tests (
  id serial,

  -- Preface with a whole bunch of versioning information
  smoduleversion text NOT NULL,    -- populate via @NAMESPACE at .getModuleversion();
  sv_major integer NOT NULL,       -- populate via @NAMESPACE at .slonyVersionMajor();
  sv_minor integer NOT NULL,       -- populate via @NAMESPACE at .slonyVersionMinor();
  sv_patch integer NOT NULL,       -- populate via @NAMESPACE at .slonyVersionPatchlevel();

  pg_version text NOT NULL,        -- populate via version();

  uname_m text NOT NULL,             -- output of `uname -m` - uname -m = ia64
  uname_r text NOT NULL,             -- output of `uname -r` - uname -r = 2.6.18.6
  uname_s text NOT NULL,             -- output of `uname -s` - uname -s = Linux
  uname_v text NOT NULL,             -- output of `uname -v` - uname -v = #1 SMP Fri Feb 9 20:10:44 MSK 2007

  hostname text NOT NULL,          -- output of `hostname -f`
  username text NOT NULL,          -- output of `whoami`

  tester_identity text NOT NULL,   -- email address of the tester, from getenv("SLONYTESTER")

  -- Now, test-specific data
  testname text NOT NULL,          -- which test was run?
  start_time timestamptz NOT NULL,
  end_time timestamptz NOT NULL,

  successful boolean NOT NULL,     -- was the test totally successful?
  failure_desc text,               -- A description of the failure noticed
  
  primary key(id)
);

create index st_slversion on slony_tests (sv_major, sv_minor, sv_patch);
create index st_host on slony_tests(tester_identity);
create index st_start on slony_tests(start_time);
-----------------------------------------------------------------------------
-- 
"cbbrowne","@","ca.afilias.info"
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)