Thread

  1. Mirrors that don't suck.

    Dan Vande More <dvm@firstlink.com> — 2003-12-23T18:39:14Z

    Hey list, I'm just wondering if anyone can point me in the direction of a mirror that doesn't suck.
    
    I generally don't do alot with postgres other than downloading and installing the newest releases.
    Everytime there is a release, it takes forever for it to show up on an ftp server. 
    This is in the case that the ftp server even works. Now in a case where one likes to browse with the browser of their choice, it totally blows because it's _so_ slow.
    
    So is there maybe an http download somewhere? Or an FTP site that doesn't give me an "directory doesn't exist" error, or one that has more than 15k available, or one that maybe has the newest releases(7.4.1)? All of those would be perfect...
    
    Dan
    
    
    
    
  2. Re: Mirrors that don't suck.

    B. van Ouwerkerk <bvo@atz.nl> — 2003-12-23T19:14:41Z

    >So is there maybe an http download somewhere? Or an FTP site that doesn't 
    >give me an "directory doesn't exist" error, or one that has more than 15k 
    >available, or one that maybe has the newest releases(7.4.1)? All of those 
    >would be perfect...
    
    I got a working 7.4.1 from one of the German mirrors.
    
    
    
    B. 
    
    
    
  3. Re: Mirrors that don't suck.

    Robert Treat <xzilla@users.sourceforge.net> — 2003-12-23T19:17:37Z

    On Tue, 2003-12-23 at 13:39, Dan Vande More wrote:
    > Hey list, I'm just wondering if anyone can point me in the direction of a mirror that doesn't suck.
    > 
    > I generally don't do alot with postgres other than downloading and installing the newest releases.
    > Everytime there is a release, it takes forever for it to show up on an ftp server. 
    > This is in the case that the ftp server even works. Now in a case where one likes to browse with the browser of their choice, it totally blows because it's _so_ slow.
    > 
    > So is there maybe an http download somewhere? Or an FTP site that doesn't give me an "directory doesn't exist" error, or one that has more than 15k available, or one that maybe has the newest releases(7.4.1)? All of those would be perfect...
    > 
    > Dan
    
    So this is how not to write an email asking people for help, seriously. 
    I just checked the first 5 mirror sites on the ftp mirrors page and
    everyone of them had the latest code under pub/source/v7.4.1/ (or
    something similar).  What might have been a more helpful email would be
    to point out that the ftp site are still showing 7.4.0 in the main
    directory and the directory for latest is also pointing to 7.4.0, both
    should be updated to 7.4.1.  You might have also included a list of the
    mirror sites you were having trouble with so problems with those sites
    could be tracked down easier. You might also want to CC
    webmaster@postgresql.org as well as posting to the -general list. 
    
    Oh, and for future reference you can download via http at
    http://developer.postgresql.org/ftpsite/, and also at the sourceforge
    site http://sourceforge.net/projects/pgsql/ (though I hesitate to
    mention it because I haven't uploaded 7.4.1 there quite yet...)
    
    I hope this helps. 
    
    Robert Treat 
    -- 
    Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    
    
    
  4. Re: Mirrors that don't suck.

    Gavin M. Roy <gmr@ehpg.net> — 2003-12-23T19:45:21Z

    http://mirror.ehpg.net/postgresql/  doesn't suck ;-)  But I'm partial.
    
    http://mirror.ehpg.net/postgresql/source/v7.4.1/ is a direct URL.
    
    Gavin
    
    Robert Treat wrote:
    
    >On Tue, 2003-12-23 at 13:39, Dan Vande More wrote:
    >  
    >
    >>Hey list, I'm just wondering if anyone can point me in the direction of a mirror that doesn't suck.
    >>
    >>I generally don't do alot with postgres other than downloading and installing the newest releases.
    >>Everytime there is a release, it takes forever for it to show up on an ftp server. 
    >>This is in the case that the ftp server even works. Now in a case where one likes to browse with the browser of their choice, it totally blows because it's _so_ slow.
    >>
    >>So is there maybe an http download somewhere? Or an FTP site that doesn't give me an "directory doesn't exist" error, or one that has more than 15k available, or one that maybe has the newest releases(7.4.1)? All of those would be perfect...
    >>
    >>Dan
    >>    
    >>
    >
    >So this is how not to write an email asking people for help, seriously. 
    >I just checked the first 5 mirror sites on the ftp mirrors page and
    >everyone of them had the latest code under pub/source/v7.4.1/ (or
    >something similar).  What might have been a more helpful email would be
    >to point out that the ftp site are still showing 7.4.0 in the main
    >directory and the directory for latest is also pointing to 7.4.0, both
    >should be updated to 7.4.1.  You might have also included a list of the
    >mirror sites you were having trouble with so problems with those sites
    >could be tracked down easier. You might also want to CC
    >webmaster@postgresql.org as well as posting to the -general list. 
    >
    >Oh, and for future reference you can download via http at
    >http://developer.postgresql.org/ftpsite/, and also at the sourceforge
    >site http://sourceforge.net/projects/pgsql/ (though I hesitate to
    >mention it because I haven't uploaded 7.4.1 there quite yet...)
    >
    >I hope this helps. 
    >
    >Robert Treat 
    >  
    >
    
    
    
    
  5. Re: Mirrors that don't suck.

    Brian Hirt <bhirt@mobygames.com> — 2003-12-23T19:46:43Z

    I've run into problems with some of the mirrors being consistently 
    unavailable and really slow to download 4k/sec on a lot of them.
    
    ftp://ftp9.us.postgresql.org/pub/mirrors seems to work great all the 
    time.  Now I hope this doesn't come across as complaining, because the 
    reason for this email is a question.   What type bandwidth can you 
    expect to use if you become a mirror (1meg/sec? more less?)  Also are 
    http mirrors acceptable?   I would like to offer up one of our servers 
    on mobygames.com because I love postgresql and it would be a way to 
    help out a bit, but I don't really know enough about the requirements 
    right now.
    
    Who should i talk to?
    
    However, there are already 7 US mirrors.
    
    
    On Dec 23, 2003, at 12:17 PM, Robert Treat wrote:
    
    > On Tue, 2003-12-23 at 13:39, Dan Vande More wrote:
    >> Hey list, I'm just wondering if anyone can point me in the direction 
    >> of a mirror that doesn't suck.
    >>
    >> I generally don't do alot with postgres other than downloading and 
    >> installing the newest releases.
    >> Everytime there is a release, it takes forever for it to show up on 
    >> an ftp server.
    >> This is in the case that the ftp server even works. Now in a case 
    >> where one likes to browse with the browser of their choice, it 
    >> totally blows because it's _so_ slow.
    >>
    >> So is there maybe an http download somewhere? Or an FTP site that 
    >> doesn't give me an "directory doesn't exist" error, or one that has 
    >> more than 15k available, or one that maybe has the newest 
    >> releases(7.4.1)? All of those would be perfect...
    >>
    >> Dan
    >
    > So this is how not to write an email asking people for help, seriously.
    > I just checked the first 5 mirror sites on the ftp mirrors page and
    > everyone of them had the latest code under pub/source/v7.4.1/ (or
    > something similar).  What might have been a more helpful email would be
    > to point out that the ftp site are still showing 7.4.0 in the main
    > directory and the directory for latest is also pointing to 7.4.0, both
    > should be updated to 7.4.1.  You might have also included a list of the
    > mirror sites you were having trouble with so problems with those sites
    > could be tracked down easier. You might also want to CC
    > webmaster@postgresql.org as well as posting to the -general list.
    >
    > Oh, and for future reference you can download via http at
    > http://developer.postgresql.org/ftpsite/, and also at the sourceforge
    > site http://sourceforge.net/projects/pgsql/ (though I hesitate to
    > mention it because I haven't uploaded 7.4.1 there quite yet...)
    >
    > I hope this helps.
    >
    > Robert Treat
    > -- 
    > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    >
    >
    > ---------------------------(end of 
    > broadcast)---------------------------
    > TIP 5: Have you checked our extensive FAQ?
    >
    >                http://www.postgresql.org/docs/faqs/FAQ.html
    
    
    
  6. Re: Mirrors that don't suck.

    Joshua D. Drake <jd@commandprompt.com> — 2003-12-23T20:05:14Z

    Brian Hirt wrote:
    
    > I've run into problems with some of the mirrors being consistently 
    > unavailable and really slow to download 4k/sec on a lot of them.
    
    I can second this.
    
    Sincerely,
    
    Joshua D. Drake
    
    
    
    -- 
    Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
    Postgresql support, programming shared hosting and dedicated hosting.
    +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
    Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
    
    
    
  7. Re: Mirrors that don't suck.

    B. van Ouwerkerk <bvo@atz.nl> — 2003-12-23T20:15:06Z

    >>I've run into problems with some of the mirrors being consistently 
    >>unavailable and really slow to download 4k/sec on a lot of them.
    >
    >I can second this.
    
    Perhaps you should wait a day or so until all mirrors are fully up to date 
    and the ppl who are in a hurry to get the source have got it..
    
    Alternatively you US boys could get out of bed early and download it before 
    50% of the USA starts to download. I have got it about 12 hours ago from a 
    German mirror at a normal speed.
    
    
    
    B. 
    
    
    
  8. Re: Mirrors that don't suck.

    Marc G. Fournier <scrappy@postgresql.org> — 2003-12-23T20:31:39Z

    On Tue, 23 Dec 2003, Robert Treat wrote:
    
    > What might have been a more helpful email would be to point out that the
    > ftp site are still showing 7.4.0 in the main directory and the directory
    > for latest is also pointing to 7.4.0, both should be updated to 7.4.1.
    
    All of the above fixed ...
    
    ----
    Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    
    
  9. Re: Mirrors that don't suck.

    Marc G. Fournier <scrappy@postgresql.org> — 2003-12-23T20:32:33Z

    On Tue, 23 Dec 2003, Joshua D. Drake wrote:
    
    > Brian Hirt wrote:
    >
    > > I've run into problems with some of the mirrors being consistently
    > > unavailable and really slow to download 4k/sec on a lot of them.
    >
    > I can second this.
    
    Any idea of how fast your mirror is running at right now?
    
    ----
    Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    
    
  10. Re: Mirrors that don't suck.

    Joshua D. Drake <jd@commandprompt.com> — 2003-12-23T20:40:25Z

    >>I can second this.
    >>    
    >>
    >
    >Any idea of how fast your mirror is running at right now?
    >
    >  
    >
    I just tried :
    
     ftp6.us.postgresql.org
    
    Which doesn't even have PostgreSQL on it ;) It is the home of opennms 
    (at least to some degree).
    
    
    
    >----
    >Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    >Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    >  
    >
    
    
    -- 
    Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
    Postgresql support, programming shared hosting and dedicated hosting.
    +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
    Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
    
    
    
  11. Re: Mirrors that don't suck.

    Marc G. Fournier <scrappy@postgresql.org> — 2003-12-23T20:47:50Z

    On Tue, 23 Dec 2003, Joshua D. Drake wrote:
    
    > I just tried :
    >
    >  ftp6.us.postgresql.org
    >
    > Which doesn't even have PostgreSQL on it ;) It is the home of opennms
    > (at least to some degree).
    
    If it doesn't have PostgreSQL on it, why is it listed as one? :)
    
    ----
    Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    
    
  12. Re: Mirrors that don't suck.

    Tony <tony@unihost.net> — 2003-12-23T20:58:42Z

    Use the torrent.... it's quite quick!
    
    T.
    
    
    Marc G. Fournier wrote:
    
    >On Tue, 23 Dec 2003, Joshua D. Drake wrote:
    >
    >  
    >
    >>I just tried :
    >>
    >> ftp6.us.postgresql.org
    >>
    >>Which doesn't even have PostgreSQL on it ;) It is the home of opennms
    >>(at least to some degree).
    >>    
    >>
    >
    >If it doesn't have PostgreSQL on it, why is it listed as one? :)
    >
    >----
    >Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    >Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    >
    >---------------------------(end of broadcast)---------------------------
    >TIP 8: explain analyze is your friend
    >  
    >
    
  13. Re: Mirrors that don't suck.

    Oliver Elphick <olly@lfix.co.uk> — 2003-12-23T21:07:13Z

    On Tue, 2003-12-23 at 20:31, Marc G. Fournier wrote:
    > On Tue, 23 Dec 2003, Robert Treat wrote:
    > 
    > > What might have been a more helpful email would be to point out that the
    > > ftp site are still showing 7.4.0 in the main directory and the directory
    > > for latest is also pointing to 7.4.0, both should be updated to 7.4.1.
    > 
    > All of the above fixed ...
    
    It would be helpful if someone were to add to the links page the UK
    mirror http://www.mirror.ac.uk/sites/ftp.postgresql.org/
    
    -- 
    Oliver Elphick                                Oliver.Elphick@lfix.co.uk
    Isle of Wight, UK                             http://www.lfix.co.uk/oliver
    GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                     ========================================
         "And this shall be a sign unto you; Ye shall find the 
          babe wrapped in swaddling clothes, lying in a manger."
                                  Luke 2:12 
    
    
    
  14. Re: Mirrors that don't suck.

    Marc G. Fournier <scrappy@postgresql.org> — 2003-12-23T21:08:32Z

    On Tue, 23 Dec 2003, Oliver Elphick wrote:
    
    > On Tue, 2003-12-23 at 20:31, Marc G. Fournier wrote:
    > > On Tue, 23 Dec 2003, Robert Treat wrote:
    > >
    > > > What might have been a more helpful email would be to point out that the
    > > > ftp site are still showing 7.4.0 in the main directory and the directory
    > > > for latest is also pointing to 7.4.0, both should be updated to 7.4.1.
    > >
    > > All of the above fixed ...
    >
    > It would be helpful if someone were to add to the links page the UK
    > mirror http://www.mirror.ac.uk/sites/ftp.postgresql.org/
    
    Send the details to webmaster@ so that the guys can add it to the database
    ... but, how are you mirroring?  All official mirrors use rsync, and they
    are auto-added to the list of mirrors, and updated nightly ...
    
    ----
    Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    
    
  15. Re: Mirrors that don't suck.

    bpalmer <bpalmer@crimelabs.net> — 2003-12-24T00:49:01Z

    > Hey list, I'm just wondering if anyone can point me in the direction of a mirror that doesn't suck.
    
    At least in the US,  I think I should be pretty decent 
    (ftp3.us.postgresql.org).  I've rate limited down to 6M/s but that should 
    be enough for anyone.  I rsync every 4 hours.  If anyone can't get to the 
    site of it's slow,  please complain to me,  I would love to know.
    
    - Brandon
    
    ----------------------------------------------------------------------------
     c: 917-697-8665                                            h: 201-435-6226
     b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5
    
    
  16. Re: Mirrors that don't suck.

    Mark Kirkwood <markir@paradise.net.nz> — 2003-12-24T08:41:24Z

    ftp://ftp.au.postgresql.org/pub/postgresql/ is still only displaying 
    7.4.0 right now...
    
    
    Marc G. Fournier wrote:
    
    >
    >Send the details to webmaster@ so that the guys can add it to the database
    >... but, how are you mirroring?  All official mirrors use rsync, and they
    >are auto-added to the list of mirrors, and updated nightly ...
    >
    >----
    >Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
    >Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
    >
    >---------------------------(end of broadcast)---------------------------
    >TIP 8: explain analyze is your friend
    >
    >
    >  
    >
    
    
    
  17. Re: [webmaster] Mirrors that don't suck.

    Dave Page <dpage@vale-housing.co.uk> — 2003-12-24T23:46:24Z

    It's rumoured that Brian Hirt once said:
    > What type bandwidth can you
    > expect to use if you become a mirror (1meg/sec? more less?)
    
    I honestly couldn't say, but I would suspect it would be a *lot* less than
    that. Whilst PostgreSQL is popular, the type of application that it is
    means that it will never get anything remotely like the level of downloads
    of say, Mozilla or OpenOffice.
    > Also are
    > http mirrors acceptable?
    
    Currently only to mirror the web content (this is mainly because the
    mirror code expects an ftp mirror to use ftp and a web mirror to use http
    - changing this would require a fair bit of recoding).
    > I would like to offer up one of our servers
    > on mobygames.com because I love postgresql and it would be a way to
    > help out a bit, but I don't really know enough about the requirements
    > right now.
    >
    > Who should i talk to?
    
    Me please. I'll need your server IP, and the IP of whatever boxes will be
    used to rsync the content. For web mirrors you must be able to setup a
    virtual host, for ftp, I alsoneed to know the path to the content (eg.
    /pub/postgresql/)
    > However, there are already 7 US mirrors.
    
    There's closer to 20, but most are not active :-(
    
    Regards, Dave.
    
    
    
    
  18. Re: [webmaster] Mirrors that don't suck.

    Brian Hirt <bhirt@mobygames.com> — 2003-12-25T00:19:22Z

    Dave,
    
    I can go about setting up a web mirror, but i cannot offer a download 
    mirror if we have to use ftp.   Our security policies are not to allow 
    ftp access.  It's just one more thing to worry about if we open up our 
    firewall.  I hope you understand.   Will it be a problem only offer the 
    web mirror?  We have a 10mbit/sec connection, but probably wouldn't 
    want postgresql to take up more than 1mbit/sec on average.  we also 
    have several free gigabytes of disk.
    
    Best Regards,
    
    Brian Hirt
    
    On Dec 24, 2003, at 4:46 PM, Dave Page wrote:
    
    > It's rumoured that Brian Hirt once said:
    >> What type bandwidth can you
    >> expect to use if you become a mirror (1meg/sec? more less?)
    >
    > I honestly couldn't say, but I would suspect it would be a *lot* less 
    > than
    > that. Whilst PostgreSQL is popular, the type of application that it is
    > means that it will never get anything remotely like the level of 
    > downloads
    > of say, Mozilla or OpenOffice.
    >> Also are
    >> http mirrors acceptable?
    >
    > Currently only to mirror the web content (this is mainly because the
    > mirror code expects an ftp mirror to use ftp and a web mirror to use 
    > http
    > - changing this would require a fair bit of recoding).
    >> I would like to offer up one of our servers
    >> on mobygames.com because I love postgresql and it would be a way to
    >> help out a bit, but I don't really know enough about the requirements
    >> right now.
    >>
    >> Who should i talk to?
    >
    > Me please. I'll need your server IP, and the IP of whatever boxes will 
    > be
    > used to rsync the content. For web mirrors you must be able to setup a
    > virtual host, for ftp, I alsoneed to know the path to the content (eg.
    > /pub/postgresql/)
    >> However, there are already 7 US mirrors.
    >
    > There's closer to 20, but most are not active :-(
    >
    > Regards, Dave.
    >
    >