Re: Request for download stats on release

> -----Original Message-----
> From: pgsql-www-owner@postgresql.org
> [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Dave Page
> Sent: 12 August 2004 22:59
> To: josh@agliodbs.com
> Cc: PostgreSQL www
> Subject: Re: [pgsql-www] Request for download stats on release
>
> We can only ask. I'll see if I can find the script I got them
> to run last time round tomorrow.
>

OK, found it. This is the email I sent to all the ftp mirrors last time.
Do you want to handle this the same way again? Any changes to the
message (other than the obvious!)?

Regards, Dave


Hello,

You have received this email because your email address is registered as
the contact address for one of the ftp.postgresql.org mirror sites. If
this is incorrect, please contact me and I will amend our records.

As you may be aware, on the 17th of November the PostgreSQL Global
Development Group announced the release of PostgreSQL 7.4. In order to
try to guage the usage and take-up of the new release, we would
appreciate it if you could find a few minutes to provide us with some
statistics. The data we are looking for is simply the number of
downloads for each of four files:

/pub/source/v7.4/postgresql-7.4.tar.gz
/pub/source/v7.4/postgresql-7.4.tar.bz2
/pub/source/v7.4/postgresql-base-7.4.tar.gz
/pub/source/v7.4/postgresql-base-7.4.tar.bz2

This information may be obtained from standard ftp server transfer logs
on a Unix system using a command similar to the following:

grep /var/spool/ftp/pub/source/v7.4/ /var/log/xferlog | \ awk '{print
$9}' | \ egrep
"postgresql-7.4.tar.bz2|postgresql-7.4.tar.gz|postgresql-base-7.4.tar.bz
2|postgresql-base-7.4.tar.gz" | \ egrep -v "md5" | \ sort | \ uniq -c |
\ sort -nr

Note that the directory and logfilename may need to be adjusted for your
particular system. This command should produce output similar to:

 210 /var/spool/ftp/pub/source/v7.4/postgresql-7.4.tar.gz
 111 /var/spool/ftp/pub/source/v7.4/postgresql-7.4.tar.bz2
  20 /var/spool/ftp/pub/source/v7.4/postgresql-base-7.4.tar.bz2
  19 /var/spool/ftp/pub/source/v7.4/postgresql-base-7.4.tar.gz

Please email the output from your system to me, and thank you for
helping support PostgreSQL!

Regards, Dave.

--
Dave Page
PostgreSQL Web Team