Martijn van Oosterhout <> writes:
> But I'm just sprouting ideas here, the proof is in the pudding. If the
> logs are easily available (or a subset of, say the last month) then
> people could play with that and see what happens...

Anyone who wants to play around can replicate what I did, which was to
download the table that Andrew made available upthread, and then pull
the log files matching interesting rows.  I used the attached functions
to generate URLs for the failing stage logs, and then a shell script
looping over lwp-download ...

CREATE FUNCTION lastfile(mfailures) RETURNS text
    AS $$
select replace(
    '' || $1.sysname || '&dt=' || $1.snapshot ||
    '&stg=' ||
    replace($1.log_archive_filenames[array_upper($1.log_archive_filenames, 1)],
        '.log', ''),
  ' ', '%20')
    LANGUAGE sql;

CREATE FUNCTION lastlog(mfailures) RETURNS text
    AS $$
select '' || lastfile($1)
    LANGUAGE sql;

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to