PGSQL INTERFACES PGADMIN HACKERS 12 CVS COMMIT BY DPAGE TEMPORARY FIX TO ALLOW FOR THE FACT THAT THE
From: cvs@no-spam
Subject: CVS Commit by dpage: Temporary fix to allow for the fact that the
Date: Fri, 10 Dec 2004 08:53:00 GMT


Log Message:
-----------
Temporary fix to allow for the fact that the mirrors aren't updating whilst hub.org is down.


Modified Files:
--------------
www/pgadmin3/cnt:
cnt_mirrors.php (r1.12 -> r1.13)

Index: cnt_mirrors.php ===================================================================
RCS file: /projects/www/pgadmin3/cnt/cnt_mirrors.php,v retrieving revision 1.12
retrieving revision 1.13
diff -Lpgadmin3/cnt/cnt_mirrors.php -Lpgadmin3/cnt/cnt_mirrors.php -u -w -r1.12 -r1.13

--- pgadmin3/cnt/cnt_mirrors.php +++ pgadmin3/cnt/cnt_mirrors.php @@no-spam -20,7 +20,9 @@no-spam if (!$_error) {
$prompt = _('Please select a download mirror:');
- $query = "SELECT 'ftp' || CASE WHEN mirror_index = 0 THEN ''::text ELSE mirror_index::text END || '.' || country_code || '.postgresql.org' AS hostname, host_port AS port, host_path AS path, country_name AS country FROM mirrors WHERE mirror_type = 'ftp' AND mirror_active = TRUE AND mirror_private = FALSE AND mirror_dns = TRUE AND mirror_last_rsync > (now() - '48 hrs'::interval) ORDER BY country_name, mirror_index;";

+// Temporary fix to allow for the fact that the mirrors aren't updating whilst hub.org is down.

+// $query = "SELECT 'ftp' || CASE WHEN mirror_index = 0 THEN ''::text ELSE mirror_index::text END || '.' || country_code || '.postgresql.org' AS hostname, host_port AS port, host_path AS path, country_name AS country FROM mirrors WHERE mirror_type = 'ftp' AND mirror_active = TRUE AND mirror_private = FALSE AND mirror_dns = TRUE AND mirror_last_rsync > (now() - '48 hrs'::interval) ORDER BY country_name, mirror_index;";

+ $query = "SELECT 'ftp' || CASE WHEN mirror_index = 0 THEN ''::text ELSE mirror_index::text END || '.' || country_code || '.postgresql.org' AS hostname, host_port AS port, host_path AS path, country_name AS country FROM mirrors WHERE mirror_type = 'ftp' AND mirror_active = TRUE AND mirror_private = FALSE AND mirror_dns = TRUE ORDER BY country_name, mirror_index;";

$res = pg_query($conn,$query);
[plaintext cvs-200412108530-diff.txt]

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org