Re: 8.0RC1 tomorrow

Peter Eisentraut wrote:

>Andrew Dunstan wrote:
>
>
>>If you have something missing from here I'm especially interested in
>>hearing from you.
>>
>>
>
>I think "Linux" entries are quite useless. We need to know what
>distribution (and version) it is. The kernel is actually a pretty
>uninteresting part of the porting process.
>
>

I would very much welcome your input and that of other major developers on
a) how we classify farm members,
b) what steps should be run for a farm test, and
c) what information would be useful from a build run.

Unfortunately I got hit with some unexpected issues about a month ago
that have restricted my available time rather.

So far I have been concentrating on getting the clients working robustly
- Windows and Cygwin have been something of a challenge, as expected.
The server side is extremely simple - crude even. The database is as
just 2 tables like this:

pgbuildfarm=# \d buildsystems

Table "public.buildsystems"

Column | Type | Modifiers

-----------------+------+-----------

name | text | not null

secret | text | not null

operating_system | text | not null

os_version | text | not null

compiler | text | not null

compiler_version | text | not null

architecture | text | not null

status | text | not null

sys_owner | text | not null

owner_email | text | not null

Indexes:

"buildsystems_pkey" primary key, btree (name)

pgbuildfarm=# \d build_status

Table "public.build_status"

Column | Type | Modifiers

----------------------+-----------------------------+-----------

sysname | text | not null

snapshot | timestamp without time zone | not null

status | integer |

stage | text |

log | text |

conf_sum | text |

branch | text |

changed_this_run | text |

changed_since_success | text |

Indexes:

"build_status_pkey" primary key, btree (sysname, snapshot)

"bs_branch_snapshot_idx" btree (branch, snapshot)

"bs_sysname_branch_idx" btree (sysname, branch)

Foreign-key constraints:

"bs_fk" FOREIGN KEY (sysname) REFERENCES buildsystems(name) ON UPDATE CASCADE ON DELETE CASCADE

These were really more or less placeholders while I got things up and running.

Any constructive input is welcome. Anyone who would like to make the web
site look spiffy rather than pedestrian would be especially welcome
(it's done in perl + template toolkit).

cheers

andrew