Обсуждение: Mirrors that don't suck.
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, orone 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 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.
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, orone 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
Hey Robert,
Well I got an answer, and that's what I was looking for.
Thanks for the (http)link at the bottom. Looks great.
As far as the sites:
ftp://ftp13.us.postgresql.org/pub/postgresql/ - Directory not found, clicked right on the webpage.
ftp://ftp8.us.postgresql.org/pub/pgsql - Directory not found, clicked right on the webpage
ftp3 times out
**Note: The following are probably user error, wget and lynx both error trying to retrieve it, but double clicking in
mybrowser works. So much for getting it from a command line tool.
**********************************************************************
--12:28:24-- ftp://ftp15.us.postgresql.org/source/v7.4/postgresql-7.4.tar.gz
=> `postgresql-7.4.tar.gz'
Resolving ftp15.us.postgresql.org... done.
Connecting to ftp15.us.postgresql.org[216.29.164.5]:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done. ==> PWD ... done.
==> TYPE I ... done. ==> CWD /source/v7.4 ... done.
==> PORT ... done. ==> RETR postgresql-7.4.tar.gz ...
Error in server response, closing control connection.
Retrying.
**********************************************************************
--11:26:53-- ftp://ftp3.ca.postgresql.org/pub/source/v7.4/postgresql-7.4.tar.gz
(try: 5) => `postgresql-7.4.tar.gz'
Connecting to ftp3.ca.postgresql.org[64.141.14.48]:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done. ==> PWD ... done.
==> TYPE I ... done. ==> CWD /pub/source/v7.4 ... done.
==> PORT ... done. ==> RETR postgresql-7.4.tar.gz ...
Error in server response, closing control connection.
Retrying.
**********************************************************************
--11:28:10-- ftp://ftp10.us.postgresql.org/pub/postgresql/v7.4/postgresql-7.4.tar.gz
(try: 5) => `postgresql-7.4.tar.gz'
Connecting to ftp10.us.postgresql.org[141.142.2.89]:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done. ==> PWD ... done.
==> TYPE I ... done. ==> CWD /pub/postgresql/v7.4 ... done.
==> PORT ... done. ==> RETR postgresql-7.4.tar.gz ...
Error in server response, closing control connection.
Retrying.
**********************************************************************
Thanks for your time.
Dan
-----Original Message-----
From: Robert Treat [mailto:xzilla@users.sourceforge.net]
Sent: Tuesday, December 23, 2003 12:18 PM
To: Dan Vande More
Cc: pgsql-general@postgresql.org; webmaster@postgresql.org; Marc G.
Fournier
Subject: Re: [GENERAL] Mirrors that don't suck.
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,
orone 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/ftp
site/, 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
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
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
>>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.
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
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
>>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
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
Use the torrent.... it's quite quick!
T.
Marc G. Fournier wrote:
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
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
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
> 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
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 > > > >
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, orone 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 > >
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. > >
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.