X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f07d620ee8f70a91f6375fa376266242995e75dd..0fcab79486d68bcf9d24b5580ce605b82253502d:/utils/setup.php diff --git a/utils/setup.php b/utils/setup.php index 166dfee9..5ae604d4 100755 --- a/utils/setup.php +++ b/utils/setup.php @@ -396,30 +396,30 @@ echo "Load Data\n"; $aDBInstances = array(); - for($i = 0; $i < $iInstances; $i++) + $iLoadThreads = max(1, $iInstances - 1); + for($i = 0; $i < $iLoadThreads; $i++) { $aDBInstances[$i] =& getDB(true); - if( $i < $iInstances-1 ) - { - $sSQL = 'insert into placex (osm_type, osm_id, class, type, name, admin_level, '; - $sSQL .= 'housenumber, street, addr_place, isin, postcode, country_code, extratags, '; - $sSQL .= 'geometry) select * from place where osm_id % '.$iInstances-1.' = '.$i; - } - else - { - // last thread for interpolation lines - $sSQL = 'select insert_osmline (osm_id, housenumber, street, addr_place, postcode, country_code, '; - $sSQL .= 'geometry) from place where '; - $sSQL .= 'class=\'place\' and type=\'houses\' and osm_type=\'W\' and ST_GeometryType(geometry) = \'ST_LineString\''; - } + $sSQL = 'insert into placex (osm_type, osm_id, class, type, name, admin_level, '; + $sSQL .= 'housenumber, street, addr_place, isin, postcode, country_code, extratags, '; + $sSQL .= 'geometry) select * from place where osm_id % '.$iLoadThreads.' = '.$i; + $sSQL .= " and not (class='place' and type='houses' and osm_type='W' and ST_GeometryType(geometry) = 'ST_LineString')"; if ($aCMDResult['verbose']) echo "$sSQL\n"; if (!pg_send_query($aDBInstances[$i]->connection, $sSQL)) fail(pg_last_error($oDB->connection)); } + // last thread for interpolation lines + $aDBInstances[$iLoadThreads] =& getDB(true); + $sSQL = 'select insert_osmline (osm_id, housenumber, street, addr_place, postcode, country_code, '; + $sSQL .= 'geometry) from place where '; + $sSQL .= "class='place' and type='houses' and osm_type='W' and ST_GeometryType(geometry) = 'ST_LineString'"; + if ($aCMDResult['verbose']) echo "$sSQL\n"; + if (!pg_send_query($aDBInstances[$i]->connection, $sSQL)) fail(pg_last_error($oDB->connection)); + $bAnyBusy = true; while($bAnyBusy) { $bAnyBusy = false; - for($i = 0; $i < $iInstances; $i++) + for($i = 0; $i <= $iLoadThreads; $i++) { if (pg_connection_busy($aDBInstances[$i]->connection)) $bAnyBusy = true; } @@ -668,7 +668,7 @@ @symlink(CONST_BasePath.'/website/css', $sTargetDir.'/css'); echo "Symlinks created\n"; - $sTestFile = @file_get_contents(CONST_Website_BaseURL.'js/tiles.js'); + $sTestFile = @file_get_contents(CONST_Website_BaseURL.'js/nominatim-ui.js'); if (!$sTestFile) { echo "\nWARNING: Unable to access the website at ".CONST_Website_BaseURL."\n";