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