Mirrors that don't suck.

[Dan Vande More]

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 onelikes to browse with the browser of their choice, it totally blows becauseit'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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Marc G. Fournier]

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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Joshua D. Drake]

I can second this.
Any idea of how fast your mirror is running at right now?

I just tried :

ftp6.us.postgre sql.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: sc*****@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.
[phone] - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Marc G. Fournier]

On Tue, 23 Dec 2003, Joshua D. Drake wrote:

I just tried :

ftp6.us.postgre sql.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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tony]

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.postgre sql.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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Oliver Elphick]

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 Ol************@ 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Marc G. Fournier]

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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[bpalmer]

> 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.postgr esql.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, bp*****@crimela bs.net pgp:crimelabs.n et/bpalmer.pgp5

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Mark Kirkwood]

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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Gavin M. Roy]

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
we*******@post gresql.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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Brian Hirt]

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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match