ports/67645: Mk/bsd.sites.mk MASTER_SITE_PGSQL fix

[Roman Neuhauser]

>Number:         67645
>Category:       ports
>Synopsis:       Mk/bsd.sites.mk MASTER_SITE_PGSQL fix
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Sun Jun 06 17:20:14 PDT 2004
>Closed-Date:
>Last-Modified:
>Originator:     Roman Neuhauser
>Release:        FreeBSD 4.9-RELEASE-p2 i386
>Organization:
>Environment:
System: FreeBSD isis.wad.cz 4.9-RELEASE-p2 FreeBSD 4.9-RELEASE-p2 #3: Sun Mar 7 02:11:16 CET 2004 root at isis.wad.cz:/usr/obj/usr/src/sys/FREEPUPPY2_6 i386


	
>Description:
ftp5.us.postgresql.org: times out
ftp8.us.postgresql.org: different structure
ftp15.us.postgresql.org: doesn't exist
ftp.cl.postgresql.org: doesn't exist
ftp5.fr.postgresql.org: refuses connections
ftp.hk.postgresql.org: refuses connections
ftp2.ie.postgresql.org: doesn't exist
ftp3.it.postgresql.org: doesn't exist
ftp.nl.postgresql.org: times out
ftp2.pl.postgresql.org: doesn't exist
ftp.pt.postgresql.org: 2 connections / IP limit, slow
ftp.za.postgresql.org: doesn't exist
ftp2.ch.postgresql.org: different structure

I'm not compensating with other sites from the mirror list
as it looks like the mirrors come and go, and it's better
to have a smaller list of stable servers.

maintainer of databases/postgresql7 cc'd
>How-To-Repeat:
	
>Fix:

	

--- Mk::bsd.sites.mk.MASTER_SITE_PGSQL.patch begins here ---
Index: Mk/bsd.sites.mk
===================================================================
RCS file: /home/ncvs/ports/Mk/bsd.sites.mk,v
retrieving revision 1.247
diff -u -u -r1.247 bsd.sites.mk
--- Mk/bsd.sites.mk	31 May 2004 20:03:45 -0000	1.247
+++ Mk/bsd.sites.mk	7 Jun 2004 00:05:20 -0000
@@ -579,12 +579,10 @@
 #
 MASTER_SITE_PGSQL+= \
 	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
-	ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
-	ftp://ftp8.us.postgresql.org/pub/pgsql/%SUBDIR%/ \
+	ftp://ftp8.us.postgresql.org/postgresql/%SUBDIR%/ \
 	ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/%SUBDIR%/ \
 	ftp://ftp10.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp13.us.postgresql.org/mirror/postgresql/%SUBDIR%/ \
-	ftp://ftp15.us.postgresql.org/%SUBDIR%/ \
 	${MASTER_SITE_RINGSERVER:S,%SUBDIR%,misc/db/postgresql/&,} \
 	ftp://ftp.au.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/%SUBDIR%/ \
@@ -592,14 +590,12 @@
 	ftp://ftp.ba.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.br.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
 	ftp://ftp3.ca.postgresql.org/pub/%SUBDIR%/ \
-	ftp://ftp.cl.postgresql.org/pub/GNU/pgsql/%SUBDIR%/ \
 	ftp://ftp2.cr.postgresql.org/pub/Unix/postgres/%SUBDIR%/ \
 	ftp://ftp.cz.postgresql.org/pub/ftp.postgresql.org/%SUBDIR%/ \
 	ftp://ftp2.cz.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.ee.postgresql.org/mirrors/postgresql/%SUBDIR%/ \
 	ftp://ftp.fr.postgresql.org/%SUBDIR%/ \
 	ftp://ftp2.fr.postgresql.org/postgresql/%SUBDIR%/ \
-	ftp://ftp5.fr.postgresql.org/mirrors/postgresql/%SUBDIR%/ \
 	ftp://ftp.de.postgresql.org/mirror/postgresql/%SUBDIR%/ \
 	ftp://ftp2.de.postgresql.org/pub/comp/os/unix/database/postgresql/%SUBDIR%/ \
 	ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/%SUBDIR%/ \
@@ -608,17 +604,13 @@
 	ftp://ftp.hk.postgresql.org/postgresql/%SUBDIR%/ \
 	ftp://ftp2.is.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/%SUBDIR%/ \
-	ftp://ftp2.ie.postgresql.org/mirrors/ftp.postgresql.org/%SUBDIR%/ \
 	ftp://ftp2.it.postgresql.org/mirrors/postgres/%SUBDIR%/ \
-	ftp://ftp3.it.postgresql.org/postgresql/%SUBDIR%/ \
 	ftp://ftp.kr.postgresql.org/mirror/database/postgresql/%SUBDIR%/ \
 	ftp://ftp.lv.postgresql.org/pub/software/postgresql/%SUBDIR%/ \
-	ftp://ftp.nl.postgresql.org/pub/mirror/postgresql/%SUBDIR%/ \
 	ftp://ftp.eu.postgresql.org/pub/unix/db/postgresql/%SUBDIR%/ \
 	ftp://ftp2.nl.postgresql.org/mirror/postgresql/%SUBDIR%/ \
 	ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl/%SUBDIR%/ \
 	ftp://ftp.no.postgresql.org/pub/databases/postgresql/%SUBDIR%/ \
-	ftp://ftp2.pl.postgresql.org/mirrors/ftp.postgresql.org/%SUBDIR%/ \
 	ftp://ftp6.pl.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/%SUBDIR%/ \
 	ftp://ftp.pt.postgresql.org/postgresql/%SUBDIR%/ \
@@ -626,10 +618,9 @@
 	ftp://ftp.ru.postgresql.org/pub/unix/database/pgsql/%SUBDIR%/ \
 	ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/%SUBDIR%/ \
 	ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/%SUBDIR%/ \
-	ftp://ftp.za.postgresql.org/%SUBDIR%/ \
 	ftp://ftp5.es.postgresql.org/mirror/postgresql/%SUBDIR%/ \
 	ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/%SUBDIR%/ \
-	ftp://ftp2.ch.postgresql.org/mirror/postgresql/%SUBDIR%/ \
+	ftp://ftp2.ch.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.tw.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp3.tw.postgresql.org/pub/postgresql/%SUBDIR%/ \
 	ftp://ftp.tr.postgresql.org/pub/SQL/postgresql/%SUBDIR%/ \
--- Mk::bsd.sites.mk.MASTER_SITE_PGSQL.patch ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted: