1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pvernier <admin@datamadre.com>, 2013 5# David Martinez Morata, 2013 6# David Martinez Morata, 2013 7# Manuel Retamozo <manuel@retamozo.com.ar>, 2018 8# nramire1 nramire1, 2017 9# pvernier <admin@datamadre.com>, 2013 10msgid "" 11msgstr "" 12"Project-Id-Version: PostGIS\n" 13"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 14"POT-Creation-Date: 2019-10-18 14:11+0000\n" 15"PO-Revision-Date: 2018-10-18 13:20+0000\n" 16"Last-Translator: Manuel Retamozo <manuel@retamozo.com.ar>\n" 17"Language-Team: Spanish (http://www.transifex.com/postgis/postgis/language/" 18"es/)\n" 19"Language: es\n" 20"MIME-Version: 1.0\n" 21"Content-Type: text/plain; charset=UTF-8\n" 22"Content-Transfer-Encoding: 8bit\n" 23"Plural-Forms: nplurals=2; plural=(n != 1);\n" 24 25#. Tag: title 26#: installation.xml:3 27#, no-c-format 28msgid "PostGIS Installation" 29msgstr "Instalación de PostGIS" 30 31#. Tag: para 32#: installation.xml:5 33#, no-c-format 34msgid "This chapter details the steps required to install PostGIS." 35msgstr "" 36"En este capítulo se detallan los pasos necesarios para instalar PostGIS ." 37 38#. Tag: title 39#: installation.xml:10 40#, no-c-format 41msgid "Short Version" 42msgstr "Versión corta" 43 44#. Tag: para 45#: installation.xml:11 46#, no-c-format 47msgid "To compile assuming you have all the dependencies in your search path:" 48msgstr "" 49"Para compilar asumiendo que tiene todas las dependencias en su ruta de " 50"búsqueda:" 51 52#. Tag: programlisting 53#: installation.xml:12 54#, no-c-format 55msgid "" 56"tar xvfz postgis-&last_release_version;.tar.gz\n" 57"cd postgis-&last_release_version;\n" 58"./configure\n" 59"make\n" 60"make install" 61msgstr "" 62"tar xvfz postgis-&last_release_version;.tar.gz\n" 63"cd postgis-&last_release_version;\n" 64"./configure\n" 65"make\n" 66"make install" 67 68#. Tag: para 69#: installation.xml:13 70#, no-c-format 71msgid "" 72"Once postgis is installed, it needs to be enabled in each individual " 73"database you want to use it in." 74msgstr "" 75"Una vez que se instala postgis, es necesario habilitarlo en cada base de " 76"datos en la que desee utilizarlo." 77 78#. Tag: para 79#: installation.xml:14 80#, no-c-format 81msgid "" 82"Using the extension enable process is preferred and more user-friendly. To " 83"spatially enable your database:" 84msgstr "" 85 86#. Tag: programlisting 87#: installation.xml:15 88#, no-c-format 89msgid "" 90"psql -d yourdatabase -c \"CREATE EXTENSION postgis;\"\n" 91"\n" 92"-- if you built with raster support and want to install it --\n" 93"psql -d yourdatabase -c \"CREATE EXTENSION postgis_raster;\"\n" 94"\n" 95"-- if you want to install topology support --\n" 96"psql -d yourdatabase -c \"CREATE EXTENSION postgis_topology;\"\n" 97"\n" 98"-- if you built with sfcgal support and want to install it --\n" 99"psql -d yourdatabase -c \"CREATE EXTENSION postgis_sfcgal;\"\n" 100"\n" 101"-- if you want to install tiger geocoder --\n" 102"psql -d yourdatabase -c \"CREATE EXTENSION fuzzystrmatch\"\n" 103"psql -d yourdatabase -c \"CREATE EXTENSION postgis_tiger_geocoder;\"\n" 104"\n" 105"-- if you installed with pcre\n" 106"-- you should have address standardizer extension as well\n" 107"psql -d yourdatabase -c \"CREATE EXTENSION address_standardizer;\"" 108msgstr "" 109 110#. Tag: para 111#: installation.xml:18 112#, no-c-format 113msgid "" 114"Please refer to <xref linkend=\"make_install_postgis_extensions\"/> for more " 115"details about querying installed/available extensions and upgrading " 116"extensions, or switching from a non-extension install to an extension " 117"install." 118msgstr "" 119 120#. Tag: para 121#: installation.xml:20 122#, no-c-format 123msgid "" 124"For those who decided for some reason to use a non-extension based install, " 125"here are longer more painful instructions for you:" 126msgstr "" 127 128#. Tag: para 129#: installation.xml:22 130#, no-c-format 131msgid "" 132"All the .sql files once installed will be installed in share/contrib/postgis-" 133"&last_minor_version; folder of your PostgreSQL install" 134msgstr "" 135 136#. Tag: programlisting 137#: installation.xml:25 138#, no-c-format 139msgid "" 140"createdb yourdatabase\n" 141"createlang plpgsql yourdatabase\n" 142"psql -d yourdatabase -f postgis.sql\n" 143"psql -d yourdatabase -f postgis_comments.sql\n" 144"psql -d yourdatabase -f spatial_ref_sys.sql\n" 145"\n" 146"-- if you want to enable topology\n" 147"psql -d yourdatabase -f topology.sql\n" 148"psql -d yourdatabase -f topology_comments.sql\n" 149"\n" 150"-- if you want to enable raster\n" 151"-- and only if you compiled with raster (GDAL)\n" 152"psql -d yourdatabase -f rtpostgis.sql\n" 153"psql -d yourdatabase -f raster_comments.sql\n" 154"\n" 155"-- if you want to enable sfcgal backend\n" 156"-- and only if you built with sfcgal support --\n" 157"psql -d yourdatabase -f sfcgal.sql\n" 158"psql -d yourdatabase -f sfcgal_comments.sql" 159msgstr "" 160 161#. Tag: title 162#: installation.xml:31 163#, no-c-format 164msgid "Configuring raster" 165msgstr "" 166 167#. Tag: para 168#: installation.xml:33 169#, no-c-format 170msgid "" 171"If you enabled raster support you may want to read below how to properly " 172"configure it." 173msgstr "" 174 175#. Tag: para 176#: installation.xml:38 177#, no-c-format 178msgid "" 179"As of PostGIS 2.1.3, out-of-db rasters and all raster drivers are disabled " 180"by default. In order to re-enable these, you need to set the following " 181"environment variables <varname>POSTGIS_GDAL_ENABLED_DRIVERS</varname> and " 182"<varname>POSTGIS_ENABLE_OUTDB_RASTERS</varname> in the server environment. " 183"For PostGIS 2.2, you can use the more cross-platform approach of setting the " 184"corresponding <xref linkend=\"PostGIS_GUC\"/>." 185msgstr "" 186 187#. Tag: para 188#: installation.xml:41 189#, no-c-format 190msgid "If you want to enable offline raster:" 191msgstr "" 192 193#. Tag: programlisting 194#: installation.xml:42 195#, no-c-format 196msgid "POSTGIS_ENABLE_OUTDB_RASTERS=1" 197msgstr "POSTGIS_ENABLE_OUTDB_RASTERS=1" 198 199#. Tag: para 200#: installation.xml:43 201#, no-c-format 202msgid "Any other setting or no setting at all will disable out of db rasters." 203msgstr "" 204 205#. Tag: para 206#: installation.xml:44 207#, no-c-format 208msgid "" 209"In order to enable all GDAL drivers available in your GDAL install, set this " 210"environment variable as follows" 211msgstr "" 212 213#. Tag: programlisting 214#: installation.xml:45 215#, no-c-format 216msgid "POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL" 217msgstr "POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL" 218 219#. Tag: para 220#: installation.xml:46 221#, no-c-format 222msgid "" 223"If you want to only enable specific drivers, set your environment variable " 224"as follows:" 225msgstr "" 226 227#. Tag: programlisting 228#: installation.xml:47 229#, no-c-format 230msgid "POSTGIS_GDAL_ENABLED_DRIVERS=\"GTiff PNG JPEG GIF XYZ\"" 231msgstr "POSTGIS_GDAL_ENABLED_DRIVERS=\"GTiff PNG JPEG GIF XYZ\"" 232 233#. Tag: para 234#: installation.xml:49 235#, no-c-format 236msgid "If you are on windows, do not quote the driver list" 237msgstr "" 238 239#. Tag: para 240#: installation.xml:51 241#, no-c-format 242msgid "" 243"Setting environment variables varies depending on OS. For PostgreSQL " 244"installed on Ubuntu or Debian via apt-postgresql, the preferred way is to " 245"edit <filename>/etc/postgresql/<replaceable>10</replaceable>/" 246"<replaceable>main</replaceable>/environment</filename> where 10 refers to " 247"version of PostgreSQL and main refers to the cluster." 248msgstr "" 249 250#. Tag: para 251#: installation.xml:54 252#, no-c-format 253msgid "" 254"On windows, if you are running as a service, you can set via System " 255"variables which for Windows 7 you can get to by right-clicking on Computer-" 256">Properties Advanced System Settings or in explorer navigating to " 257"<varname>Control Panel\\All Control Panel Items\\System</varname>. Then " 258"clicking <emphasis>Advanced System Settings ->Advanced->Environment " 259"Variables</emphasis> and adding new system variables." 260msgstr "" 261 262#. Tag: para 263#: installation.xml:56 264#, no-c-format 265msgid "" 266"After you set the environment variables, you'll need to restart your " 267"PostgreSQL service for the changes to take effect." 268msgstr "" 269 270#. Tag: title 271#: installation.xml:61 272#, no-c-format 273msgid "Install Requirements" 274msgstr "" 275 276#. Tag: para 277#: installation.xml:63 278#, no-c-format 279msgid "PostGIS has the following requirements for building and usage:" 280msgstr "PostGIS tiene los siguientes requisitos para compilarlo y usarlo:" 281 282#. Tag: emphasis 283#: installation.xml:68 284#, no-c-format 285msgid "Required" 286msgstr "Requerido" 287 288#. Tag: para 289#: installation.xml:73 290#, no-c-format 291msgid "" 292"PostgreSQL &min_postgres_version; or higher. A complete installation of " 293"PostgreSQL (including server headers) is required. PostgreSQL is available " 294"from <ulink url=\"http://www.postgresql.org\"> http://www.postgresql.org </" 295"ulink> ." 296msgstr "" 297"PostgreSQL &min_postgres_version; o superior. Una instalación completa de " 298"PostgreSQL (incluyendo las cabeceras del servidor) es necesaria. PostgreSQL " 299"esta disponible en <ulink url=\"http://www.postgresql.org\"> http://www." 300"postgresql.org </ulink> ." 301 302#. Tag: para 303#: installation.xml:82 304#, no-c-format 305msgid "" 306"For a full PostgreSQL / PostGIS support matrix and PostGIS/GEOS support " 307"matrix refer to <ulink url=\"http://trac.osgeo.org/postgis/wiki/" 308"UsersWikiPostgreSQLPostGIS\">http://trac.osgeo.org/postgis/wiki/" 309"UsersWikiPostgreSQLPostGIS</ulink>" 310msgstr "" 311"Para conocer las compatibilidades entre versiones de PostgreSQL/PostGIS y " 312"PostGIS/GEOS puede ver una matriz de compatibilidades en <ulink url=\"http://" 313"trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS\">http://trac.osgeo." 314"org/postgis/wiki/UsersWikiPostgreSQLPostGIS</ulink>" 315 316#. Tag: para 317#: installation.xml:88 318#, no-c-format 319msgid "" 320"GNU C compiler (<filename>gcc</filename>). Some other ANSI C compilers can " 321"be used to compile PostGIS, but we find far fewer problems when compiling " 322"with <filename>gcc</filename>." 323msgstr "" 324"compilador GNU C (<filename>gcc</filename>). Otros compiladores ANSI C " 325"pueden utilizarse para compilar PostGIS, pero encontraremos menos problemas " 326"al compilar con <filename>gcc</filename>." 327 328#. Tag: para 329#: installation.xml:96 330#, no-c-format 331msgid "" 332"GNU Make (<filename>gmake</filename> or <filename>make</filename>). For many " 333"systems, GNU <filename>make</filename> is the default version of make. Check " 334"the version by invoking <filename>make -v</filename>. Other versions of " 335"<filename>make</filename> may not process the PostGIS <filename>Makefile</" 336"filename> properly." 337msgstr "" 338"GNU Make (<filename>gmake</filename> or <filename>make</filename>). Para " 339"muchos sistemas , GNU <filename>make</filename> es la versión por defecto de " 340"make. Para verificar la versión de make podemos ejecutar el siguiente " 341"comando <filename>make -v</filename>. Otras versiones de <filename>make</" 342"filename> pueden no procesar el fichero PostGIS <filename>Makefile</" 343"filename> de forma correcta." 344 345#. Tag: para 346#: installation.xml:106 347#, no-c-format 348msgid "" 349"Proj4 reprojection library, version 4.6.0 or greater. Proj4 4.9 or above is " 350"needed to take advantage of improved geodetic. The Proj4 library is used to " 351"provide coordinate reprojection support within PostGIS. Proj4 is available " 352"for download from <ulink url=\"http://trac.osgeo.org/proj/\"> http://trac." 353"osgeo.org/proj/ </ulink> ." 354msgstr "" 355 356#. Tag: para 357#: installation.xml:118 358#, no-c-format 359msgid "" 360"GEOS geometry library, version 3.6 or greater, but GEOS 3.7+ is recommended " 361"to take full advantage of all the new functions and features. GEOS is " 362"available for download from <ulink url=\"http://trac.osgeo.org/geos/\"> " 363"http://trac.osgeo.org/geos/ </ulink>." 364msgstr "" 365 366#. Tag: para 367#: installation.xml:126 368#, no-c-format 369msgid "" 370"LibXML2, version 2.5.x or higher. LibXML2 is currently used in some imports " 371"functions (ST_GeomFromGML and ST_GeomFromKML). LibXML2 is available for " 372"download from <ulink url=\"http://xmlsoft.org/downloads.html\">http://" 373"xmlsoft.org/downloads.html</ulink>." 374msgstr "" 375"LibXML2, versión 2.5.x o superior. LibXML2 se usa actualmente en alguna " 376"funciones para importar (ST_GeomFromGML y ST_GeomFromKML). LibXML2 esta " 377"disponible para su descarga en <ulink url=\"http://xmlsoft.org/downloads.html" 378"\">http://xmlsoft.org/downloads.html</ulink>." 379 380#. Tag: para 381#: installation.xml:133 382#, no-c-format 383msgid "" 384"JSON-C, version 0.9 or higher. JSON-C is currently used to import GeoJSON " 385"via the function ST_GeomFromGeoJson. JSON-C is available for download from " 386"<ulink url=\"https://github.com/json-c/json-c/releases\">https://github.com/" 387"json-c/json-c/releases/</ulink>." 388msgstr "" 389 390#. Tag: para 391#: installation.xml:141 392#, no-c-format 393msgid "" 394"GDAL, version 1.8 or higher (1.9 or higher is strongly recommended since " 395"some things will not work well or behavior differently with lower versions). " 396"This is required for raster support. <ulink url=\"http://trac.osgeo.org/gdal/" 397"wiki/DownloadSource\">http://trac.osgeo.org/gdal/wiki/DownloadSource</ulink>." 398msgstr "" 399"GDAL, version 1.8 o superior (1.9 o superior es fuertemente recomendada ya " 400"que algunas cosas no funcionaran bien o pueden tener un comportamiento " 401"diferente entre versiones). Esta librería es necesaria para dar soporte a " 402"las funciones raster. <ulink url=\"http://trac.osgeo.org/gdal/wiki/" 403"DownloadSource\">http://trac.osgeo.org/gdal/wiki/DownloadSource</ulink>." 404 405#. Tag: para 406#: installation.xml:151 407#, no-c-format 408msgid "" 409"If compiling with PostgreSQL+JIT, LLVM version >=6 is required <ulink url=" 410"\"https://trac.osgeo.org/postgis/ticket/4125\">https://trac.osgeo.org/" 411"postgis/ticket/4125</ulink>." 412msgstr "" 413 414#. Tag: emphasis 415#: installation.xml:160 416#, no-c-format 417msgid "Optional" 418msgstr "Opcional" 419 420#. Tag: para 421#: installation.xml:165 422#, no-c-format 423msgid "" 424"GDAL (pseudo optional) only if you don't want raster you can leave it out. " 425"Also make sure to enable the drivers you want to use as described in <xref " 426"linkend=\"raster_configuration\"/>." 427msgstr "" 428 429#. Tag: para 430#: installation.xml:173 431#, no-c-format 432msgid "" 433"GTK (requires GTK+2.0, 2.8+) to compile the shp2pgsql-gui shape file loader. " 434"<ulink url=\"http://www.gtk.org/\"> http://www.gtk.org/ </ulink> ." 435msgstr "" 436"GTK (GTK+2.0, 2.8+ requerida) para compilar el cargador de shapefiles " 437"shp2pgsql-gui. <ulink url=\"http://www.gtk.org/\"> http://www.gtk.org/ </" 438"ulink> ." 439 440#. Tag: para 441#: installation.xml:183 442#, no-c-format 443msgid "" 444"SFCGAL, version 1.1 (or higher) could be used to provide additional 2D and " 445"3D advanced analysis functions to PostGIS cf <xref linkend=\"reference_sfcgal" 446"\"/>. And also allow to use SFCGAL rather than GEOS for some 2D functions " 447"provided by both backends (like ST_Intersection or ST_Area, for instance). A " 448"PostgreSQL configuration variable <code>postgis.backend</code> allow end " 449"user to control which backend he want to use if SFCGAL is installed (GEOS by " 450"default). Nota: SFCGAL 1.2 require at least CGAL 4.3 and Boost 1.54 (cf: " 451"<ulink url=\"http://oslandia.github.io/SFCGAL/installation.html\">http://" 452"oslandia.github.io/SFCGAL/installation.html</ulink>) <ulink url=\"https://" 453"github.com/Oslandia/SFCGAL\">https://github.com/Oslandia/SFCGAL</ulink>." 454msgstr "" 455 456#. Tag: para 457#: installation.xml:191 458#, no-c-format 459msgid "" 460"In order to build the <xref linkend=\"Address_Standardizer\"/> you will also " 461"need PCRE <ulink url=\"http://www.pcre.org\">http://www.pcre.org</ulink> " 462"(which generally is already installed on nix systems). <code>Regex::" 463"Assemble</code> perl CPAN package is only needed if you want to rebuild the " 464"data encoded in <filename>parseaddress-stcities.h</filename>. <xref linkend=" 465"\"Address_Standardizer\"/> will automatically be built if it detects a PCRE " 466"library, or you pass in a valid <varname>--with-pcre-dir=/path/to/pcre</" 467"varname> during configure." 468msgstr "" 469 470#. Tag: para 471#: installation.xml:198 472#, no-c-format 473msgid "" 474"To enable ST_AsMVT protobuf-c library (for usage) and the protoc-c compiler " 475"(for building) are required. Also, pkg-config is required to verify the " 476"correct minimum version of protobuf-c. See <ulink url=\"https://github.com/" 477"protobuf-c/protobuf-c\">protobuf-c</ulink>. By default, Postgis will use " 478"Wagyu to validate MVT polygons faster which requires a c++11 compiler. It " 479"will use CXXFLAGS and the same compiler as the PostgreSQL installation. To " 480"disable this and use GEOS instead use the <varname>--without-wagyu</varname> " 481"during the configure step." 482msgstr "" 483 484#. Tag: para 485#: installation.xml:207 486#, no-c-format 487msgid "" 488"CUnit (<filename>CUnit</filename>). This is needed for regression testing. " 489"<ulink url=\"http://cunit.sourceforge.net/\">http://cunit.sourceforge.net/</" 490"ulink>" 491msgstr "" 492"CUnit (<filename>CUnit</filename>). Se necesita para hacer test de " 493"regresión. <ulink url=\"http://cunit.sourceforge.net/\">http://cunit." 494"sourceforge.net/</ulink>" 495 496#. Tag: para 497#: installation.xml:213 498#, no-c-format 499msgid "" 500"DocBook (<filename>xsltproc</filename>) is required for building the " 501"documentation. Docbook is available from <ulink url=\"http://www.docbook.org/" 502"\"> http://www.docbook.org/ </ulink> ." 503msgstr "" 504"DocBook (<filename>xsltproc</filename>) es necesario para compilar la " 505"documentación. Docbook esta disponible en <ulink url=\"http://www.docbook." 506"org/\"> http://www.docbook.org/ </ulink> ." 507 508#. Tag: para 509#: installation.xml:224 510#, no-c-format 511msgid "" 512"DBLatex (<filename>dblatex</filename>) is required for building the " 513"documentation in PDF format. DBLatex is available from <ulink url=\"http://" 514"dblatex.sourceforge.net/\"> http://dblatex.sourceforge.net/ </ulink> ." 515msgstr "" 516"DBLatex (<filename>dblatex</filename>) necesario para construir la " 517"documentación en formato PDF. DBLatex esta disponible en <ulink url=\"http://" 518"dblatex.sourceforge.net/\"> http://dblatex.sourceforge.net/ </ulink> ." 519 520#. Tag: para 521#: installation.xml:235 522#, no-c-format 523msgid "" 524"ImageMagick (<filename>convert</filename>) is required to generate the " 525"images used in the documentation. ImageMagick is available from <ulink url=" 526"\"http://www.imagemagick.org/\"> http://www.imagemagick.org/ </ulink> ." 527msgstr "" 528"ImageMagick (<filename>convert</filename>) es necesario para generar las " 529"imágenes empleadas en la documentación. ImageMagick esta disponible en<ulink " 530"url=\"http://www.imagemagick.org/\"> http://www.imagemagick.org/ </ulink> ." 531 532#. Tag: title 533#: installation.xml:248 534#, no-c-format 535msgid "Getting the Source" 536msgstr "Obteniendo el código fuente" 537 538#. Tag: para 539#: installation.xml:250 540#, no-c-format 541msgid "" 542"Retrieve the PostGIS source archive from the downloads website <ulink url=" 543"\"&postgis_download_url;\"> &postgis_download_url; </ulink>" 544msgstr "" 545 546#. Tag: programlisting 547#: installation.xml:257 548#, no-c-format 549msgid "" 550"wget &postgis_download_url;\n" 551"tar -xvzf postgis-&last_release_version;.tar.gz" 552msgstr "" 553 554#. Tag: para 555#: installation.xml:259 556#, no-c-format 557msgid "" 558"This will create a directory called <varname>postgis-&last_release_version;</" 559"varname> in the current working directory." 560msgstr "" 561"Esto creara un directorio llamado <varname>postgis-&last_release_version;</" 562"varname> en el directorio de trabajo actual." 563 564#. Tag: para 565#: installation.xml:265 566#, fuzzy, no-c-format 567msgid "" 568"Alternatively, checkout the source from the <ulink url=\"http://subversion." 569"apache.org/\"> svn </ulink> repository <ulink url=\"https://svn.osgeo.org/" 570"postgis/trunk/\"> https://svn.osgeo.org/postgis/trunk/ </ulink> ." 571msgstr "" 572"De forma alternativa se puede obtener el código fuente del repositorio " 573"<ulink url=\"http://subversion.apache.org/\"> svn </ulink> <ulink url=" 574"\"http://svn.osgeo.org/postgis/trunk/\"> http://svn.osgeo.org/postgis/trunk/ " 575"</ulink> ." 576 577#. Tag: programlisting 578#: installation.xml:277 579#, fuzzy, no-c-format 580msgid "" 581"svn checkout https://svn.osgeo.org/postgis/trunk/ postgis-" 582"&last_release_version;" 583msgstr "" 584"svn checkout http://svn.osgeo.org/postgis/trunk/ postgis-" 585"&last_release_version;" 586 587#. Tag: para 588#: installation.xml:279 589#, no-c-format 590msgid "" 591"Change into the newly created <varname>postgis-&last_release_version;</" 592"varname> directory to continue the installation." 593msgstr "" 594"Vaya al nuevo directorio <varname>postgis-&last_release_version;</varname> " 595"creado para continuar con la instalación." 596 597#. Tag: title 598#: installation.xml:287 599#, no-c-format 600msgid "Compiling and Install from Source: Detailed" 601msgstr "" 602 603#. Tag: para 604#: installation.xml:290 605#, no-c-format 606msgid "" 607"Many OS systems now include pre-built packages for PostgreSQL/PostGIS. In " 608"many cases compilation is only necessary if you want the most bleeding edge " 609"versions or you are a package maintainer." 610msgstr "" 611"Muchos Sistemas Operativos incluyen ya paquetes precompilados PostgreSQL/" 612"PostGIS. En la mayoría de casos no es necesario compilar salvo si quieres " 613"las ultimas versiones o eres alguien que hace mantenimiento de paquetes." 614 615#. Tag: para 616#: installation.xml:295 617#, no-c-format 618msgid "" 619"This section includes general compilation instructions, if you are compiling " 620"for Windows etc or another OS, you may find additional more detailed help at " 621"<ulink url=\"http://trac.osgeo.org/postgis/wiki/UsersWikiInstall\">PostGIS " 622"User contributed compile guides</ulink> and <ulink url=\"http://trac.osgeo." 623"org/postgis/wiki/DevWikiMain\">PostGIS Dev Wiki</ulink>." 624msgstr "" 625"Esta sección incluye las instrucciones generales de compilado, si estas " 626"compilando en Windows o otro Sistema Operativo, puedes encontrar información " 627"adicional detallada en <ulink url=\"http://trac.osgeo.org/postgis/wiki/" 628"UsersWikiInstall\">PostGIS User contributed compile guides</ulink> y <ulink " 629"url=\"http://trac.osgeo.org/postgis/wiki/DevWikiMain\">PostGIS Dev Wiki</" 630"ulink>." 631 632#. Tag: para 633#: installation.xml:297 634#, no-c-format 635msgid "" 636"Pre-Built Packages for various OS are listed in <ulink url=\"http://trac." 637"osgeo.org/postgis/wiki/UsersWikiPackages\">PostGIS Pre-built Packages</ulink>" 638msgstr "" 639"Algunos paquetes precompilados para varios Sistemas Operativos están en " 640"<ulink url=\"http://trac.osgeo.org/postgis/wiki/UsersWikiPackages\">PostGIS " 641"Pre-built Packages</ulink>" 642 643#. Tag: para 644#: installation.xml:298 645#, fuzzy, no-c-format 646msgid "" 647"If you are a windows user, you can get stable builds via Stackbuilder or " 648"<ulink url=\"https://postgis.net/windows_downloads\">PostGIS Windows " 649"download site</ulink> We also have <ulink url=\"https://postgis.net/" 650"windows_downloads\">very bleeding-edge windows experimental builds</ulink> " 651"that are built usually once or twice a week or whenever anything exciting " 652"happens. You can use these to experiment with the in progress releases of " 653"PostGIS" 654msgstr "" 655"Si eres usuario de Windows, puedes obtener versiones estables compiladas via " 656"Stackbuilder o <ulink url=\"http://www.postgis.org/download/windows/\"> " 657"sitio de descragas de PostGIS para Windows</ulink> También tenemos <ulink " 658"url=\"http://www.postgis.org/download/windows/experimental.php\">versiones " 659"experimentales para Windows </ulink> que son publicadas normalmente una o " 660"dos veces por semana o cuando algo interesante ocurre. Puedes utilizar estas " 661"para experimentar con las versiones de desarrollo de PostGIS" 662 663#. Tag: para 664#: installation.xml:303 665#, no-c-format 666msgid "" 667"The PostGIS module is an extension to the PostgreSQL backend server. As " 668"such, PostGIS &last_release_version; <emphasis>requires</emphasis> full " 669"PostgreSQL server headers access in order to compile. It can be built " 670"against PostgreSQL versions &min_postgres_version; or higher. Earlier " 671"versions of PostgreSQL are <emphasis>not</emphasis> supported." 672msgstr "" 673"El modulo PostGIS es una extensión del servidor PostgreSQL. Como tal, " 674"PostGIS &last_release_version; <emphasis>requiere</emphasis> PostgreSQL con " 675"acceso completo cabeceras del servidor con el fin de compilar. Puede ser " 676"compilado en PostgreSQL versiones &min_postgres_version;, o superior. Las " 677"versiones anteriores de PostgreSQL <emphasis>no</emphasis> son compatibles." 678 679#. Tag: para 680#: installation.xml:311 681#, no-c-format 682msgid "" 683"Refer to the PostgreSQL installation guides if you haven't already installed " 684"PostgreSQL. <ulink url=\"http://www.postgresql.org\"> http://www.postgresql." 685"org </ulink> ." 686msgstr "" 687"Si todavía no tienes instalado PostgreSQL puedes ir a la guía de instalación " 688"de PostgreSQL en <ulink url=\"http://www.postgresql.org\"> http://www." 689"postgresql.org </ulink> ." 690 691#. Tag: para 692#: installation.xml:321 693#, no-c-format 694msgid "" 695"For GEOS functionality, when you install PostgresSQL you may need to " 696"explicitly link PostgreSQL against the standard C++ library:" 697msgstr "" 698"Para tener compatibilidad con las funcionalidades GEOS, cuando instales " 699"PostgreSQL necesitar hacer un enlace explícito de PostgreSQL con la librería " 700"estándar C++:" 701 702#. Tag: programlisting 703#: installation.xml:326 704#, no-c-format 705msgid "LDFLAGS=-lstdc++ ./configure [YOUR OPTIONS HERE]" 706msgstr "LDFLAGS=-lstdc++ ./configure [PON TUS OPCIONES AQUI]" 707 708#. Tag: para 709#: installation.xml:328 710#, no-c-format 711msgid "" 712"This is a workaround for bogus C++ exceptions interaction with older " 713"development tools. If you experience weird problems (backend unexpectedly " 714"closed or similar things) try this trick. This will require recompiling your " 715"PostgreSQL from scratch, of course." 716msgstr "" 717"Esta es una falsa solución para excepciones de interacción de C++ con " 718"herramientas de desarrollo antiguas. Si experimentas problemas extraños " 719"(backend cerrado inesperadamente o cosas similares) prueba este truco. Para " 720"ello será necesario volver a compilar PostgreSQL desde cero, por supuesto." 721 722#. Tag: para 723#: installation.xml:336 724#, no-c-format 725msgid "" 726"The following steps outline the configuration and compilation of the PostGIS " 727"source. They are written for Linux users and will not work on Windows or Mac." 728msgstr "" 729"Los siguientes pasos describen la configuración y compilación del código " 730"fuente de PostGIS. Están escritas para usuarios Linux y no funcionaran con " 731"Windows o Mac." 732 733#. Tag: title 734#: installation.xml:343 735#, no-c-format 736msgid "Configuration" 737msgstr "Configuración" 738 739#. Tag: para 740#: installation.xml:345 741#, no-c-format 742msgid "" 743"As with most linux installations, the first step is to generate the Makefile " 744"that will be used to build the source code. This is done by running the " 745"shell script" 746msgstr "" 747"Como en la gran mayoría de instalaciones Linux, el primer paso es generar el " 748"Makefile que se utilizara para compilar el código fuente. Esto se hace " 749"ejecutando el script de shell." 750 751#. Tag: para 752#: installation.xml:355 753#, no-c-format 754msgid "" 755"With no additional parameters, this command will attempt to automatically " 756"locate the required components and libraries needed to build the PostGIS " 757"source code on your system. Although this is the most common usage of " 758"<command>./configure</command>, the script accepts several parameters for " 759"those who have the required libraries and programs in non-standard locations." 760msgstr "" 761"Sin parámetros adicionales, este comando intentara localizar los componentes " 762"y librerías necesarios para construir el código fuente PostGIS de forma " 763"automática en tu sistema. Aunque este es el uso mas común de <command>./" 764"configure</command>, el script acepta varios parámetros para aquellos que " 765"han instalado las librerías y programas en lugares no standard." 766 767#. Tag: para 768#: installation.xml:363 769#, no-c-format 770msgid "" 771"The following list shows only the most commonly used parameters. For a " 772"complete list, use the <command>--help</command> or <command>--help=short</" 773"command> parameters." 774msgstr "" 775"La siguiente lista muestra los parámetros utilizados mas comunes. Para " 776"obtener una lista completa, puedes utilizar los parámetros <command>--help</" 777"command> o <command>--help=short</command>." 778 779#. Tag: para 780#: installation.xml:373 781#, no-c-format 782msgid "" 783"Starting with PostGIS 3.0, the library files generated by default will no " 784"longer have the minor version as part of the file name. This means all " 785"PostGIS 3 libs will end in <code>postgis-3</code>. This was done to make " 786"pg_upgrade easier, with downside that you can only install one version " 787"PostGIS 3 series in your server. To get the old behavior of file including " 788"the minor version: e.g. <code>postgis-3.0</code> add this switch to your " 789"configure statement." 790msgstr "" 791 792#. Tag: para 793#: installation.xml:388 794#, fuzzy, no-c-format 795msgid "" 796"This is the location the PostGIS loader executables and shared libs will be " 797"installed. By default, this location is the same as the detected PostgreSQL " 798"installation." 799msgstr "" 800"Esta es la localización donde se instalaran las librerías PostGIS y los " 801"scripts SQL. Por defecto, esta localización es la misma que la detectada " 802"para la instalación PostgreSQL." 803 804#. Tag: para 805#: installation.xml:395 806#, no-c-format 807msgid "" 808"This parameter is currently broken, as the package will only install into " 809"the PostgreSQL installation directory. Visit <ulink url=\"http://trac.osgeo." 810"org/postgis/ticket/635\"> http://trac.osgeo.org/postgis/ticket/635 </ulink> " 811"to track this bug." 812msgstr "" 813"Este parámetro está roto actualmente, ya que el paquete sólo se instalará en " 814"el directorio de instalación de PostgreSQL. Para seguir avence de este bug " 815"visita <ulink url=\"http://trac.osgeo.org/postgis/ticket/635\"> http://trac." 816"osgeo.org/postgis/ticket/635 </ulink>" 817 818#. Tag: para 819#: installation.xml:410 820#, no-c-format 821msgid "" 822"PostgreSQL provides a utility called <command>pg_config</command> to enable " 823"extensions like PostGIS to locate the PostgreSQL installation directory. Use " 824"this parameter (<command>--with-pgconfig=/path/to/pg_config</command>) to " 825"manually specify a particular PostgreSQL installation that PostGIS will " 826"build against." 827msgstr "" 828"PostgreSQL tiene una herramienta llamada <command>pg_config</command> para " 829"activar extensiones como PostGIS o para localizar el directorio de " 830"instalación de PostgreSQL. Utiliza este parámetro (<command>--with-pgconfig=/" 831"path/to/pg_config</command>) para especificar una instalación personalizada " 832"de PostgreSQL de forma manual que PostGIS utilizara para compilar. " 833 834#. Tag: para 835#: installation.xml:424 836#, no-c-format 837msgid "" 838"GDAL, a required library, provides functionality needed for raster support " 839"<command>gdal-config</command> to enable software installations to locate " 840"the GDAL installation directory. Use this parameter (<command>--with-" 841"gdalconfig=/path/to/gdal-config</command>) to manually specify a particular " 842"GDAL installation that PostGIS will build against." 843msgstr "" 844"GDAL, una biblioteca necesaria, proporciona la funcionalidad necesaria para " 845"el soporte de raster <command> gdal-config </command> para activar la " 846"instalación de software para localizar el directorio de instalación de GDAL. " 847"Utilice este parámetro (<command> - with-gdalconfig = / ruta /a/ gdal config-" 848"</command>) para especificar manualmente una instalación de GDAL " 849"personalizada que PostGIS utilizara para compilar." 850 851#. Tag: para 852#: installation.xml:438 853#, no-c-format 854msgid "" 855"GEOS, a required geometry library, provides a utility called <command>geos-" 856"config</command> to enable software installations to locate the GEOS " 857"installation directory. Use this parameter (<command>--with-geosconfig=/path/" 858"to/geos-config</command>) to manually specify a particular GEOS installation " 859"that PostGIS will build against." 860msgstr "" 861"GEOS, libreria de geometrías requerida, tiene una utilidad llamada " 862"<command>geos-config</command> para activar la localización del directorio " 863"de instalación del software GEOS. Utiliza este parametro (<command>--with-" 864"geosconfig=/path/to/geos-config</command>) para especificar de forma manual " 865"una instalación personalizada de GEOS que PostGIS puede utilizar para " 866"compilar." 867 868#. Tag: para 869#: installation.xml:452 870#, no-c-format 871msgid "" 872"LibXML is the library required for doing GeomFromKML/GML processes. It " 873"normally is found if you have libxml installed, but if not or you want a " 874"specific version used, you'll need to point PostGIS at a specific " 875"<filename>xml2-config</filename> confi file to enable software installations " 876"to locate the LibXML installation directory. Use this parameter (<command>>--" 877"with-xml2config=/path/to/xml2-config</command>) to manually specify a " 878"particular LibXML installation that PostGIS will build against." 879msgstr "" 880"LibXML es una libreria necesaria para procesar GeomFromKML/GML. Normalmente " 881"encontrara si tienes instalada la libreria libxml, pero si no esta " 882"instalada, o quieres usar una versión especifica, necesitaras que PostGIS " 883"apunte a un fichero de configuración particular <filename>xml2-config</" 884"filename> para localizar un directorio de instalación LibXML para activar la " 885"instalación del Software. Utiliza el siguiente parámetro (<command>>--with-" 886"xml2config=/path/to/xml2-config</command>) para especificar de forma manual " 887"una instalación personalizada de LibXML con la que compilar PostGIS." 888 889#. Tag: para 890#: installation.xml:470 891#, no-c-format 892msgid "" 893"Proj4 is a reprojection library required by PostGIS. Use this parameter " 894"(<command>--with-projdir=/path/to/projdir</command>) to manually specify a " 895"particular Proj4 installation directory that PostGIS will build against." 896msgstr "" 897"Proj4 es una libreria de reproyecciones necesaria de PostGIS. Utiliza el " 898"siguiente parametro (<command>--with-projdir=/path/to/projdir</command>) " 899"para definir manualmente una instalación personalizada de Proj4 para " 900"compilar PostGIS." 901 902#. Tag: para 903#: installation.xml:482 904#, no-c-format 905msgid "Directory where iconv is installed." 906msgstr "Directorio donde iconv esta instalado." 907 908#. Tag: para 909#: installation.xml:491 910#, no-c-format 911msgid "" 912"<ulink url=\"http://oss.metaparadigm.com/json-c/\">JSON-C</ulink> is an MIT-" 913"licensed JSON library required by PostGIS ST_GeomFromJSON support. Use this " 914"parameter (<command>--with-jsondir=/path/to/jsondir</command>) to manually " 915"specify a particular JSON-C installation directory that PostGIS will build " 916"against." 917msgstr "" 918"<ulink url=\"http://oss.metaparadigm.com/json-c/\">JSON-C</ulink>es una " 919"libreria con licencia MIT-licensed JSON necesaria para dar soporte a PostGIS " 920"ST_GeomFromJSON. Utiliza este parametro (<command>--with-jsondir=/path/to/" 921"jsondir</command>) para especificar de forma manual el directorio de " 922"instalación personalizado de instalación de JSON-C que PostGIS utilizara " 923"para compilar." 924 925#. Tag: para 926#: installation.xml:503 927#, no-c-format 928msgid "" 929"<ulink url=\"http://www.pcre.org/\">PCRE</ulink> is an BSD-licensed Perl " 930"Compatible Regular Expression library required by address_standardizer " 931"extension. Use this parameter (<command>--with-pcredir=/path/to/pcredir</" 932"command>) to manually specify a particular PCRE installation directory that " 933"PostGIS will build against." 934msgstr "" 935 936#. Tag: para 937#: installation.xml:515 938#, no-c-format 939msgid "" 940"Compile the data import GUI (requires GTK+2.0). This will create shp2pgsql-" 941"gui graphical interface to shp2pgsql." 942msgstr "" 943"Compilar la GUI de importar datos (necesita GTK+2.0). Esto creara una " 944"interfaz gráfica shp2pgsql-gui para el comando shp2pgsql." 945 946#. Tag: para 947#: installation.xml:524 948#, no-c-format 949msgid "Compile without raster support." 950msgstr "" 951 952#. Tag: para 953#: installation.xml:532 954#, no-c-format 955msgid "" 956"Disable topology support. There is no corresponding library as all logic " 957"needed for topology is in postgis-&last_release_version; library." 958msgstr "" 959 960#. Tag: para 961#: installation.xml:541 962#, no-c-format 963msgid "" 964"By default PostGIS will try to detect gettext support and compile with it, " 965"however if you run into incompatibility issues that cause breakage of " 966"loader, you can disable it entirely with this command. Refer to ticket " 967"<ulink url=\"http://trac.osgeo.org/postgis/ticket/748\">http://trac.osgeo." 968"org/postgis/ticket/748</ulink> for an example issue solved by configuring " 969"with this. NOTE: that you aren't missing much by turning this off. This is " 970"used for international help/label support for the GUI loader which is not " 971"yet documented and still experimental." 972msgstr "" 973"PostGIS intentara detectar soporte gettext y compilar con el por defecto, de " 974"todas formas si existen incompatibilidades que causan errores de carga, se " 975"puede desactivar por completo con este comando. Para ver un ejemplo de " 976"resolución de problemas configurando en gettext puedes ver el siguiente " 977"enlace <ulink url=\"http://trac.osgeo.org/postgis/ticket/748\">http://trac." 978"osgeo.org/postgis/ticket/748</ulink>. NOTA: No te pierdes mucho si " 979"desactivas esta opción. Se utiliza principalmente para soporte de ayuda/" 980"etiquetas internacionales en la GUI de carga, que actualmente no esta " 981"documentada y sigue siendo experimental." 982 983#. Tag: para 984#: installation.xml:552 985#, no-c-format 986msgid "" 987"By default PostGIS will not install with sfcgal support without this switch. " 988"<varname>PATH</varname> is an optional argument that allows to specify an " 989"alternate PATH to sfcgal-config." 990msgstr "" 991 992#. Tag: para 993#: installation.xml:561 994#, no-c-format 995msgid "" 996"When building with MVT support, Postgis will use <ulink url=\"https://github." 997"com/mapbox/wagyu/\">Wagyu</ulink> to clip and validate MVT polygons. Wagyu " 998"is the fastest alternative and guarantees producing correct values for this " 999"specific case, but it requires a C++-11 compiler. With this optional " 1000"argument you can disable using this library; GEOS will be used instead." 1001msgstr "" 1002 1003#. Tag: para 1004#: installation.xml:568 1005#, no-c-format 1006msgid "" 1007"If you obtained PostGIS from the <ulink url=\"https://trac.osgeo.org/postgis/" 1008"wiki/CodeRepository\"> code repository </ulink> , the first step is really " 1009"to run the script" 1010msgstr "" 1011 1012#. Tag: para 1013#: installation.xml:580 1014#, no-c-format 1015msgid "" 1016"This script will generate the <command>configure</command> script that in " 1017"turn is used to customize the installation of PostGIS." 1018msgstr "" 1019"Este Script generara el script <command>configure</command> que a su vez se " 1020"utiliza para personalizar la instalación de PostGIS." 1021 1022#. Tag: para 1023#: installation.xml:585 1024#, no-c-format 1025msgid "" 1026"If you instead obtained PostGIS as a tarball, running <command>./autogen.sh</" 1027"command> is not necessary as <command>configure</command> has already been " 1028"generated." 1029msgstr "" 1030"Si, por el contrario, as obtenido PostGIS como tarball, ejecutar <command>./" 1031"autogen.sh</command> no es necesario ya que ya se ha generado " 1032"<command>configure</command>." 1033 1034#. Tag: title 1035#: installation.xml:594 1036#, no-c-format 1037msgid "Building" 1038msgstr "Compilando" 1039 1040#. Tag: para 1041#: installation.xml:596 1042#, no-c-format 1043msgid "" 1044"Once the Makefile has been generated, building PostGIS is as simple as " 1045"running" 1046msgstr "" 1047"Una vez generado el Makefile, compilar PostGIS es tan simple como ejecutar" 1048 1049#. Tag: para 1050#: installation.xml:605 1051#, no-c-format 1052msgid "" 1053"The last line of the output should be \"<code>PostGIS was built " 1054"successfully. Ready to install.</code>\"" 1055msgstr "" 1056"La ultima linea de salida del terminal debe ser \"<code>PostGIS copilado con " 1057"éxito. Listo para instalar.</code>\"" 1058 1059#. Tag: para 1060#: installation.xml:610 1061#, no-c-format 1062msgid "" 1063"As of PostGIS v1.4.0, all the functions have comments generated from the " 1064"documentation. If you wish to install these comments into your spatial " 1065"databases later, run the command which requires docbook. The " 1066"postgis_comments.sql and other package comments files raster_comments.sql, " 1067"topology_comments.sql are also packaged in the tar.gz distribution in the " 1068"doc folder so no need to make comments if installing from the tar ball. " 1069"Comments are also included as part of the CREATE EXTENSION install." 1070msgstr "" 1071 1072#. Tag: command 1073#: installation.xml:620 installation.xml:644 1074#, no-c-format 1075msgid "make comments" 1076msgstr "make comments" 1077 1078#. Tag: para 1079#: installation.xml:623 1080#, no-c-format 1081msgid "" 1082"Introduced in PostGIS 2.0. This generates html cheat sheets suitable for " 1083"quick reference or for student handouts. This requires xsltproc to build and " 1084"will generate 4 files in doc folder <filename>topology_cheatsheet.html</" 1085"filename>, <filename>tiger_geocoder_cheatsheet.html</filename>, " 1086"<filename>raster_cheatsheet.html</filename>, <filename>postgis_cheatsheet." 1087"html</filename>" 1088msgstr "" 1089"Introducido en la version PostGIS 2.0. Esto genera hojas de referencia html " 1090"para una referencia rápida o para los folletos. Esto requiere xsltproc para " 1091"compilar y generará 4 ficheros en la carpeta doc " 1092"<filename>topology_cheatsheet.html</filename>, " 1093"<filename>tiger_geocoder_cheatsheet.html</filename>, " 1094"<filename>raster_cheatsheet.html</filename>, <filename>postgis_cheatsheet." 1095"html</filename>" 1096 1097#. Tag: para 1098#: installation.xml:628 1099#, no-c-format 1100msgid "" 1101"You can download some pre-built ones available in html and pdf from <ulink " 1102"url=\"http://www.postgis.us/study_guides\">PostGIS / PostgreSQL Study " 1103"Guides</ulink>" 1104msgstr "" 1105"Puedes descargar algunos ya compilados en formato html o pdf en <ulink url=" 1106"\"http://www.postgis.us/study_guides\"> Guias de Estudio PostGIS / " 1107"PostgreSQL</ulink>" 1108 1109#. Tag: command 1110#: installation.xml:631 1111#, no-c-format 1112msgid "make cheatsheets" 1113msgstr "make cheatsheets" 1114 1115#. Tag: title 1116#: installation.xml:636 1117#, no-c-format 1118msgid "Building PostGIS Extensions and Deploying them" 1119msgstr "Compilando e Instalando Extensiones de PostGIS" 1120 1121#. Tag: para 1122#: installation.xml:638 1123#, no-c-format 1124msgid "" 1125"The PostGIS extensions are built and installed automatically if you are " 1126"using PostgreSQL 9.1+." 1127msgstr "" 1128"Las extensiones de PosGIS son compiladas e instaladas de forma automatica si " 1129"estas utilizando la version 9.1+ de PostgreSQL" 1130 1131#. Tag: para 1132#: installation.xml:641 1133#, no-c-format 1134msgid "" 1135"If you are building from source repository, you need to build the function " 1136"descriptions first. These get built if you have docbook installed. You can " 1137"also manually build with the statement:" 1138msgstr "" 1139"Si estas compilando desde el repositorio de código fuente, necesitas " 1140"compilar primero la función descriptions. Si tienes instaldo docbook ya esta " 1141"compilado. También puedes compilarla manualmente con la sentencia:" 1142 1143#. Tag: para 1144#: installation.xml:646 1145#, no-c-format 1146msgid "" 1147"Building the comments is not necessary if you are building from a release " 1148"tar ball since these are packaged pre-built with the tar ball already." 1149msgstr "" 1150"Compilar los comentarios no es necesario si estas compilando desde un tar ya " 1151"que están en el paquete pre-compilados con el tar." 1152 1153#. Tag: para 1154#: installation.xml:647 1155#, fuzzy, no-c-format 1156msgid "" 1157"The extensions should automatically build as part of the make install " 1158"process. You can if needed build from the extensions folders or copy files " 1159"if you need them on a different server." 1160msgstr "" 1161"Si estas compilando para PostgreSQL 9.1, la extension debería compilarse de " 1162"forma automática como parte del proceso del comando make install. Si lo " 1163"necesitas, puedes compilar la extensión desde las carpetas de la extensión o " 1164"copiar los ficheros en un servidor diferente." 1165 1166#. Tag: programlisting 1167#: installation.xml:649 1168#, no-c-format 1169msgid "" 1170"cd extensions\n" 1171"cd postgis\n" 1172"make clean\n" 1173"make\n" 1174"export PGUSER=postgres #overwrite psql variables\n" 1175"make check #to test before install\n" 1176"make install\n" 1177"# to test extensions\n" 1178"make check RUNTESTFLAGS=--extension" 1179msgstr "" 1180 1181#. Tag: para 1182#: installation.xml:650 1183#, no-c-format 1184msgid "" 1185"<code>make check</code> uses psql to run tests and as such can use psql " 1186"environment variables. Common ones useful to override are <varname>PGUSER</" 1187"varname>,<varname>PGPORT</varname>, and <varname>PGHOST</varname>. Refer to " 1188"<ulink url=\"https://www.postgresql.org/docs/current/libpq-envars.html" 1189"\">psql environment variables</ulink>" 1190msgstr "" 1191 1192#. Tag: para 1193#: installation.xml:652 1194#, fuzzy, no-c-format 1195msgid "" 1196"The extension files will always be the same for the same version of PostGIS " 1197"and PostgreSQL regardless of OS, so it is fine to copy over the extension " 1198"files from one OS to another as long as you have the PostGIS binaries " 1199"already installed on your servers." 1200msgstr "" 1201"Los ficheros de la extension serán siempre los mismos para la misma versión " 1202"de PostgreSQL independientemente del Sistema Operativo, así que se pueden " 1203"copiar los ficheros de la extensión de un Sistema Operativo a otro si ya " 1204"tienes los binarios de PostGIS ya instalados en tus servidores." 1205 1206#. Tag: para 1207#: installation.xml:654 1208#, no-c-format 1209msgid "" 1210"If you want to install the extensions manually on a separate server " 1211"different from your development, You need to copy the following files from " 1212"the extensions folder into the <filename>PostgreSQL / share / extension</" 1213"filename> folder of your PostgreSQL install as well as the needed binaries " 1214"for regular PostGIS if you don't have them already on the server." 1215msgstr "" 1216"Si quieres instalar la extensión de forma manual en un servidor separado de " 1217"tu servidor de desarrollo, necesitas copiar los siguientes archivos de la " 1218"carpeta de la extensión en la carpeta <filename>PostgreSQL / share / " 1219"extension</filename> de la instalación de PostgreSQL y los binarios normales " 1220"para PostGIS si no los tienes instalados en el servidor." 1221 1222#. Tag: para 1223#: installation.xml:661 1224#, no-c-format 1225msgid "" 1226"These are the control files that denote information such as the version of " 1227"the extension to install if not specified. <filename>postgis.control, " 1228"postgis_topology.control</filename>." 1229msgstr "" 1230"Estos son los ficheros de control que contienen información como la versión " 1231"de la extensión a instalar si no lo has especificado. <filename>postgis." 1232"control, postgis_topology.control</filename>." 1233 1234#. Tag: para 1235#: installation.xml:667 1236#, no-c-format 1237msgid "" 1238"All the files in the /sql folder of each extension. Note that these need to " 1239"be copied to the root of the PostgreSQL share/extension folder " 1240"<filename>extensions/postgis/sql/*.sql</filename>, <filename>extensions/" 1241"postgis_topology/sql/*.sql</filename>" 1242msgstr "" 1243"Todos los ficheros en la carpeta /sql de la extension. Estos ficheros deben " 1244"ser copiados en la raiz de PostgreSQL en la carpeta share/extension " 1245"<filename>extensions/postgis/sql/*.sql</filename>, <filename>extensions/" 1246"postgis_topology/sql/*.sql</filename>" 1247 1248#. Tag: para 1249#: installation.xml:673 1250#, no-c-format 1251msgid "" 1252"Once you do that, you should see <varname>postgis</varname>, " 1253"<varname>postgis_topology</varname> as available extensions in PgAdmin -> " 1254"extensions." 1255msgstr "" 1256"Una vez hecho esto deberías ver <varname>postgis</varname>, " 1257"<varname>postgis_topology</varname> como extensiones disponibles en PgAdmin -" 1258"> extensiones." 1259 1260#. Tag: para 1261#: installation.xml:674 1262#, no-c-format 1263msgid "" 1264"If you are using psql, you can verify that the extensions are installed by " 1265"running this query:" 1266msgstr "" 1267"Si estas utilizando psql, puedes verificar que las extensiones están " 1268"instaladas ejecutando la siguiente sentencia:" 1269 1270#. Tag: programlisting 1271#: installation.xml:675 1272#, fuzzy, no-c-format 1273msgid "" 1274"SELECT name, default_version,installed_version\n" 1275"FROM pg_available_extensions WHERE name LIKE 'postgis%' or name LIKE 'address" 1276"%';\n" 1277"\n" 1278" name | default_version | installed_version\n" 1279"------------------------------+-----------------+-------------------\n" 1280" address_standardizer | &last_release_version; | " 1281"&last_release_version;\n" 1282" address_standardizer_data_us | &last_release_version; | " 1283"&last_release_version;\n" 1284" postgis | &last_release_version; | " 1285"&last_release_version;\n" 1286" postgis_raster | &last_release_version; | " 1287"&last_release_version;\n" 1288" postgis_sfcgal | &last_release_version; |\n" 1289" postgis_tiger_geocoder | &last_release_version; | " 1290"&last_release_version;\n" 1291" postgis_topology | &last_release_version; |\n" 1292"(6 rows)" 1293msgstr "" 1294"SELECT name, default_version,installed_version\n" 1295"FROM pg_available_extensions WHERE name LIKE 'postgis%' or name LIKE 'address" 1296"%';\n" 1297"\n" 1298" name | default_version | installed_version\n" 1299"------------------------------+-----------------+-------------------\n" 1300" address_standardizer | &last_release_version; | " 1301"&last_release_version;\n" 1302" address_standardizer_data_us | &last_release_version; | " 1303"&last_release_version;\n" 1304" postgis | &last_release_version; | " 1305"&last_release_version;\n" 1306" postgis_sfcgal | &last_release_version; |\n" 1307" postgis_tiger_geocoder | &last_release_version; | " 1308"&last_release_version;\n" 1309" postgis_topology | &last_release_version; |\n" 1310"(6 rows)" 1311 1312#. Tag: para 1313#: installation.xml:677 1314#, no-c-format 1315msgid "" 1316"If you have the extension installed in the database you are querying, you'll " 1317"see mention in the <varname>installed_version</varname> column. If you get " 1318"no records back, it means you don't have postgis extensions installed on the " 1319"server at all. PgAdmin III 1.14+ will also provide this information in the " 1320"<varname>extensions</varname> section of the database browser tree and will " 1321"even allow upgrade or uninstall by right-clicking." 1322msgstr "" 1323"Si tienes instalada una extension en la base de datos que estas consultando, " 1324"deberías verla mencionada la columna <varname>installed_version</varname>. " 1325"Si la consulta no devuelve ningún registro, significa que no tienes la " 1326"extension PostGIS instalada en el servidor. PgAdmin III 1.14+ muestra esta " 1327"información en la sección <varname>extensiones</varname> en el navegador de " 1328"bases de datos y permite actualizar o instalar haciendo click derecho." 1329 1330#. Tag: para 1331#: installation.xml:681 1332#, no-c-format 1333msgid "" 1334"If you have the extensions available, you can install postgis extension in " 1335"your database of choice by either using pgAdmin extension interface or " 1336"running these sql commands:" 1337msgstr "" 1338"Si la extension esta disponible, puedes instalar la extension postgis en la " 1339"base de datos de tu elección utilizando la interfaz de extensiones de " 1340"pgAdmin o ejecutando la siguiente sentencia:" 1341 1342#. Tag: programlisting 1343#: installation.xml:682 1344#, fuzzy, no-c-format 1345msgid "" 1346"CREATE EXTENSION postgis;\n" 1347"CREATE EXTENSION postgis_raster;\n" 1348"CREATE EXTENSION postgis_sfcgal;\n" 1349"CREATE EXTENSION fuzzystrmatch; --needed for postgis_tiger_geocoder\n" 1350"--optional used by postgis_tiger_geocoder, or can be used standalone\n" 1351"CREATE EXTENSION address_standardizer;\n" 1352"CREATE EXTENSION address_standardizer_data_us;\n" 1353"CREATE EXTENSION postgis_tiger_geocoder;\n" 1354"CREATE EXTENSION postgis_topology;" 1355msgstr "" 1356"CREATE EXTENSION postgis;\n" 1357"CREATE EXTENSION postgis_sfcgal;\n" 1358"CREATE EXTENSION fuzzystrmatch; --needed for postgis_tiger_geocoder\n" 1359"--optional used by postgis_tiger_geocoder, or can be used standalone\n" 1360"CREATE EXTENSION address_standardizer;\n" 1361"CREATE EXTENSION address_standardizer_data_us;\n" 1362"CREATE EXTENSION postgis_tiger_geocoder;\n" 1363"CREATE EXTENSION postgis_topology;" 1364 1365#. Tag: para 1366#: installation.xml:684 1367#, no-c-format 1368msgid "" 1369"In psql you can use to see what versions you have installed and also what " 1370"schema they are installed." 1371msgstr "" 1372 1373#. Tag: programlisting 1374#: installation.xml:685 1375#, no-c-format 1376msgid "" 1377"\\connect mygisdb\n" 1378"\\x\n" 1379"\\dx postgis*" 1380msgstr "" 1381"\\connect mygisdb\n" 1382"\\x\n" 1383"\\dx postgis*" 1384 1385#. Tag: screen 1386#: installation.xml:687 1387#, no-c-format 1388msgid "" 1389"List of installed extensions\n" 1390"-[ RECORD 1 ]-------------------------------------------------\n" 1391"Name | postgis\n" 1392"Version | &last_release_version;\n" 1393"Schema | public\n" 1394"Description | PostGIS geometry, geography, and raster spat..\n" 1395"-[ RECORD 2 ]-------------------------------------------------\n" 1396"Name | postgis_raster\n" 1397"Version | 3.0.0dev\n" 1398"Schema | public\n" 1399"Description | PostGIS raster types and functions\n" 1400"-[ RECORD 3 ]-------------------------------------------------\n" 1401"Name | postgis_tiger_geocoder\n" 1402"Version | &last_release_version;\n" 1403"Schema | tiger\n" 1404"Description | PostGIS tiger geocoder and reverse geocoder\n" 1405"-[ RECORD 4 ]-------------------------------------------------\n" 1406"Name | postgis_topology\n" 1407"Version | &last_release_version;\n" 1408"Schema | topology\n" 1409"Description | PostGIS topology spatial types and functions" 1410msgstr "" 1411 1412#. Tag: para 1413#: installation.xml:689 1414#, no-c-format 1415msgid "" 1416"Extension tables <varname>spatial_ref_sys</varname>, <varname>layer</" 1417"varname>, <varname>topology</varname> can not be explicitly backed up. They " 1418"can only be backed up when the respective <varname>postgis</varname> or " 1419"<varname>postgis_topology</varname> extension is backed up, which only seems " 1420"to happen when you backup the whole database. As of PostGIS 2.0.1, only srid " 1421"records not packaged with PostGIS are backed up when the database is backed " 1422"up so don't go around changing srids we package and expect your changes to " 1423"be there. Put in a ticket if you find an issue. The structures of extension " 1424"tables are never backed up since they are created with <code>CREATE " 1425"EXTENSION</code> and assumed to be the same for a given version of an " 1426"extension. These behaviors are built into the current PostgreSQL extension " 1427"model, so nothing we can do about it." 1428msgstr "" 1429"No se pueden hacer copias de seguridad explicitas de las tablas de las " 1430"extensiones <varname>spatial_ref_sys</varname>, <varname>layer</varname>, " 1431"<varname>topology</varname>. Solo se pueden hacer copias de seguridad " 1432"explicitas cuando cuando se hacen copias de seguridad de sus respectivas " 1433"extensiones <varname>postgis</varname> or <varname>postgis_topology</" 1434"varname>, lo que al parecer ocurre cuando haces una copia de seguridad de la " 1435"base de datos completa. Con PostGIS 2.0.1, solo los srid no incluidos en " 1436"PostGIS son guardados cuando se hace una copia de seguridad de la base de " 1437"datos, así que no esperes que al cambiar alguno de los srid que incluye " 1438"PostGIS este en tu copia de seguridad. Envia un ticket si encuentras algún " 1439"problema. La estructura de las tabals de extensiones no se guardan en copias " 1440"de seguridad si son creadas con <code>CREATE EXTENSION</code> y son la misma " 1441"estructura para una version dada de una extension. Estos comportamientos " 1442"están incorporados en el modelo de extensiones PostgreSQL actual, así que " 1443"nada podemos hacer al respecto." 1444 1445#. Tag: para 1446#: installation.xml:694 1447#, no-c-format 1448msgid "" 1449"If you installed &last_release_version;, without using our wonderful " 1450"extension system, you can change it to be extension based by running the " 1451"below commands to package the functions in their respective extension." 1452msgstr "" 1453 1454#. Tag: programlisting 1455#: installation.xml:698 1456#, no-c-format 1457msgid "" 1458"CREATE EXTENSION postgis FROM unpackaged;\n" 1459"CREATE EXTENSION postgis_raster FROM unpackaged;\n" 1460"CREATE EXTENSION postgis_topology FROM unpackaged;\n" 1461"CREATE EXTENSION postgis_tiger_geocoder FROM unpackaged;" 1462msgstr "" 1463 1464#. Tag: title 1465#: installation.xml:704 1466#, no-c-format 1467msgid "Testing" 1468msgstr "Tests" 1469 1470#. Tag: para 1471#: installation.xml:706 1472#, no-c-format 1473msgid "If you wish to test the PostGIS build, run" 1474msgstr "Si quieres hacer un test en la compilación de PostGIS, ejecuta" 1475 1476#. Tag: command 1477#: installation.xml:711 1478#, no-c-format 1479msgid "make check" 1480msgstr "make check" 1481 1482#. Tag: para 1483#: installation.xml:714 1484#, no-c-format 1485msgid "" 1486"The above command will run through various checks and regression tests using " 1487"the generated library against an actual PostgreSQL database." 1488msgstr "" 1489"El comando anterior ejecutará varias comprobaciones y tests de regresión " 1490"utilizando la librería generada para la version de base de datos PostgreSQL " 1491"actual." 1492 1493#. Tag: para 1494#: installation.xml:720 1495#, fuzzy, no-c-format 1496msgid "" 1497"If you configured PostGIS using non-standard PostgreSQL, GEOS, or Proj4 " 1498"locations, you may need to add their library locations to the " 1499"<varname>LD_LIBRARY_PATH</varname> environment variable." 1500msgstr "" 1501"Si has configurado PostGIS con instalaciones de PostgreSQL, GEOS, o Proj4 en " 1502"directorios personalizados, necesitaras añadir las localizaciones de las " 1503"librerías personalizadas en la variable de entorno LD_LIBRARY_PATH." 1504 1505#. Tag: para 1506#: installation.xml:728 1507#, no-c-format 1508msgid "" 1509"Currently, the <command>make check</command> relies on the <code>PATH</code> " 1510"and <code>PGPORT</code> environment variables when performing the checks - " 1511"it does <emphasis>not</emphasis> use the PostgreSQL version that may have " 1512"been specified using the configuration parameter <command>--with-pgconfig</" 1513"command>. So make sure to modify your PATH to match the detected PostgreSQL " 1514"installation during configuration or be prepared to deal with the impending " 1515"headaches." 1516msgstr "" 1517"Actualmente, el comando <command>make check</command> une las variables de " 1518"entorno <code>PATH</code> y <code>PGPORT</code> cundo ejecuta las " 1519"comprobaciones - <emphasis>no</emphasis> utiliza la version de PostgreSQL " 1520"especificada utilizando el parametro de configuración <command>--with-" 1521"pgconfig</command>. Así que hay que estar seguros de modificar la variable " 1522"de entorno PATH para que apunte a la instalación de PostgreSQL detectada " 1523"durante la configuración o estar preparado para tener algún que otro dolor " 1524"de cabeza." 1525 1526#. Tag: para 1527#: installation.xml:740 1528#, no-c-format 1529msgid "" 1530"If successful, the output of the test should be similar to the following:" 1531msgstr "" 1532"Si todo ha ido bien, la salida del comando de test debería ser similar a la " 1533"siguiente:" 1534 1535#. Tag: programlisting 1536#: installation.xml:745 1537#, fuzzy, no-c-format 1538msgid "" 1539"CUnit - A unit testing framework for C - Version 2.1-3\n" 1540" http://cunit.sourceforge.net/\n" 1541"\n" 1542"\n" 1543"Suite: algorithm\n" 1544" Test: test_lw_segment_side ...passed\n" 1545" Test: test_lw_segment_intersects ...passed\n" 1546" Test: test_lwline_crossing_short_lines ...passed\n" 1547" Test: test_lwline_crossing_long_lines ...passed\n" 1548" Test: test_lwline_crossing_bugs ...passed\n" 1549" Test: test_lwpoint_set_ordinate ...passed\n" 1550" Test: test_lwpoint_get_ordinate ...passed\n" 1551" Test: test_point_interpolate ...passed\n" 1552" Test: test_lwline_interpolate_points ...passed\n" 1553" Test: test_lwline_interpolate_point_3d ...passed\n" 1554" Test: test_lwline_clip ...passed\n" 1555" Test: test_lwpoly_clip ...passed\n" 1556" Test: test_lwtriangle_clip ...passed\n" 1557" Test: test_lwline_clip_big ...passed\n" 1558" Test: test_lwmline_clip ...passed\n" 1559" Test: test_geohash_point ...passed\n" 1560" Test: test_geohash_precision ...passed\n" 1561" Test: test_geohash ...passed\n" 1562" Test: test_geohash_point_as_int ...passed\n" 1563" Test: test_isclosed ...passed\n" 1564" Test: test_lwgeom_simplify ...passed\n" 1565" Test: test_lw_arc_center ...passed\n" 1566" Test: test_point_density ...passed\n" 1567" Test: test_kmeans ...passed\n" 1568" Test: test_median_handles_3d_correctly ...passed\n" 1569" Test: test_median_robustness ...passed\n" 1570" Test: test_lwpoly_construct_circle ...passed\n" 1571" Test: test_trim_bits ...passed\n" 1572" Test: test_lwgeom_remove_repeated_points ...passed\n" 1573"Suite: buildarea\n" 1574" Test: buildarea1 ...passed\n" 1575" Test: buildarea2 ...passed\n" 1576" Test: buildarea3 ...passed\n" 1577" Test: buildarea4 ...passed\n" 1578" Test: buildarea4b ...passed\n" 1579" Test: buildarea5 ...passed\n" 1580" Test: buildarea6 ...passed\n" 1581" Test: buildarea7 ...passed\n" 1582"Suite: geometry_clean\n" 1583" Test: test_lwgeom_make_valid ...passed\n" 1584"Suite: clip_by_rectangle\n" 1585" Test: test_lwgeom_clip_by_rect ...DEBUG1: lwgeom_clip_by_rect: GEOS Error: " 1586"IllegalArgumentException: Invalid number of points in LinearRing found 3 - " 1587"must be 0 or >= 4\n" 1588"passed\n" 1589"Suite: force_sfs\n" 1590" Test: test_sfs_11 ...passed\n" 1591" Test: test_sfs_12 ...passed\n" 1592" Test: test_sqlmm ...passed\n" 1593"Suite: geodetic\n" 1594" Test: test_sphere_direction ...passed\n" 1595" Test: test_sphere_project ...passed\n" 1596" Test: test_lwgeom_area_sphere ...passed\n" 1597" Test: test_gbox_from_spherical_coordinates ...passed\n" 1598" Test: test_gserialized_get_gbox_geocentric ...passed\n" 1599" Test: test_clairaut ...passed\n" 1600" Test: test_edge_intersection ...passed\n" 1601" Test: test_edge_intersects ...passed\n" 1602" Test: test_edge_distance_to_point ...passed\n" 1603" Test: test_edge_distance_to_edge ...passed\n" 1604" Test: test_lwgeom_distance_sphere ...passed\n" 1605" Test: test_lwgeom_check_geodetic ...passed\n" 1606" Test: test_gserialized_from_lwgeom ...passed\n" 1607" Test: test_spheroid_distance ...passed\n" 1608" Test: test_spheroid_area ...passed\n" 1609" Test: test_lwpoly_covers_point2d ...passed\n" 1610" Test: test_gbox_utils ...passed\n" 1611" Test: test_vector_angle ...passed\n" 1612" Test: test_vector_rotate ...passed\n" 1613" Test: test_lwgeom_segmentize_sphere ...passed\n" 1614" Test: test_ptarray_contains_point_sphere ...passed\n" 1615" Test: test_ptarray_contains_point_sphere_iowa ...passed\n" 1616" Test: test_gbox_to_string_truncated ...passed\n" 1617"Suite: geos\n" 1618" Test: test_geos_noop ...passed\n" 1619" Test: test_geos_subdivide ...passed\n" 1620" Test: test_geos_linemerge ...passed\n" 1621" Test: test_geos_offsetcurve ...passed\n" 1622" Test: test_geos_offsetcurve_crash ...passed\n" 1623" Test: test_geos_makevalid ...passed\n" 1624"Suite: clustering\n" 1625" Test: basic_test ...passed\n" 1626" Test: nonsequential_test ...passed\n" 1627" Test: basic_distance_test ...passed\n" 1628" Test: single_input_test ...passed\n" 1629" Test: empty_inputs_test ...passed\n" 1630" Test: multipoint_test ...passed\n" 1631" Test: dbscan_test ...passed\n" 1632" Test: dbscan_test_3612a ...passed\n" 1633" Test: dbscan_test_3612b ...passed\n" 1634" Test: dbscan_test_3612c ...passed\n" 1635"Suite: clustering_unionfind\n" 1636" Test: test_unionfind_create ...passed\n" 1637" Test: test_unionfind_union ...passed\n" 1638" Test: test_unionfind_ordered_by_cluster ...passed\n" 1639" Test: test_unionfind_path_compression ...passed\n" 1640" Test: test_unionfind_collapse_cluster_ids ...passed\n" 1641"Suite: homogenize\n" 1642" Test: test_coll_point ...passed\n" 1643" Test: test_coll_line ...passed\n" 1644" Test: test_coll_poly ...passed\n" 1645" Test: test_coll_coll ...passed\n" 1646" Test: test_geom ...passed\n" 1647" Test: test_coll_curve ...passed\n" 1648"Suite: encoded_polyline_input\n" 1649" Test: in_encoded_polyline_test_geoms ...passed\n" 1650" Test: in_encoded_polyline_test_precision ...passed\n" 1651"Suite: geojson_input\n" 1652" Test: in_geojson_test_srid ...passed\n" 1653" Test: in_geojson_test_bbox ...passed\n" 1654" Test: in_geojson_test_geoms ...passed\n" 1655"Suite: iterator\n" 1656" Test: test_point_count ...passed\n" 1657" Test: test_ordering ...passed\n" 1658" Test: test_modification ...passed\n" 1659" Test: test_mixed_rw_access ...passed\n" 1660" Test: test_cannot_modify_read_only ...passed\n" 1661" Test: test_no_memory_leaked_when_iterator_is_partially_used ...passed\n" 1662"Suite: twkb_input\n" 1663" Test: test_twkb_in_point ...passed\n" 1664" Test: test_twkb_in_linestring ...passed\n" 1665" Test: test_twkb_in_polygon ...passed\n" 1666" Test: test_twkb_in_multipoint ...passed\n" 1667" Test: test_twkb_in_multilinestring ...passed\n" 1668" Test: test_twkb_in_multipolygon ...passed\n" 1669" Test: test_twkb_in_collection ...passed\n" 1670" Test: test_twkb_in_precision ...passed\n" 1671"Suite: serialization/deserialization\n" 1672" Test: test_typmod_macros ...passed\n" 1673" Test: test_flags_macros ...passed\n" 1674" Test: test_serialized_srid ...NOTICE: SRID value -3005 converted to the " 1675"officially unknown SRID value 0\n" 1676"passed\n" 1677" Test: test_gserialized_from_lwgeom_size ...passed\n" 1678" Test: test_gbox_serialized_size ...passed\n" 1679" Test: test_lwgeom_from_gserialized ...passed\n" 1680" Test: test_lwgeom_count_vertices ...passed\n" 1681" Test: test_on_gser_lwgeom_count_vertices ...passed\n" 1682" Test: test_geometry_type_from_string ...passed\n" 1683" Test: test_lwcollection_extract ...passed\n" 1684" Test: test_lwgeom_free ...passed\n" 1685" Test: test_lwgeom_swap_ordinates ...passed\n" 1686" Test: test_f2d ...passed\n" 1687" Test: test_lwgeom_clone ...passed\n" 1688" Test: test_lwgeom_force_clockwise ...passed\n" 1689" Test: test_lwgeom_calculate_gbox ...passed\n" 1690" Test: test_lwgeom_is_empty ...passed\n" 1691" Test: test_lwgeom_same ...passed\n" 1692" Test: test_lwline_from_lwmpoint ...passed\n" 1693" Test: test_lwgeom_as_curve ...passed\n" 1694" Test: test_lwgeom_scale ...passed\n" 1695" Test: test_gserialized_is_empty ...passed\n" 1696" Test: test_gserialized_peek_gbox_p_no_box_when_empty ...passed\n" 1697" Test: test_gserialized_peek_gbox_p_gets_correct_box ...passed\n" 1698" Test: test_gserialized_peek_gbox_p_fails_for_unsupported_cases ...passed\n" 1699" Test: test_gbox_same_2d ...passed\n" 1700" Test: test_signum_macro ...passed\n" 1701"Suite: lwstroke\n" 1702" Test: test_lwcurve_linearize ...passed\n" 1703" Test: test_unstroke ...passed\n" 1704"Suite: measures\n" 1705" Test: test_mindistance2d_tolerance ...passed\n" 1706" Test: test_mindistance3d_tolerance ...NOTICE: One or both of the " 1707"geometries is missing z-value. The unknown z-value will be regarded as \"any " 1708"value\"\n" 1709"NOTICE: One or both of the geometries is missing z-value. The unknown z-" 1710"value will be regarded as \"any value\"\n" 1711"passed\n" 1712" Test: test_rect_tree_contains_point ...passed\n" 1713" Test: test_rect_tree_intersects_tree ...passed\n" 1714" Test: test_lwgeom_segmentize2d ...NOTICE: ptarray.c:448 - " 1715"ptarray_segmentize2d: Too many segments required (1.000000e+101)\n" 1716"NOTICE: liblwgeom code interrupted\n" 1717"NOTICE: liblwgeom code interrupted\n" 1718"NOTICE: liblwgeom code interrupted\n" 1719"NOTICE: liblwgeom code interrupted\n" 1720"passed\n" 1721" Test: test_lwgeom_locate_along ...passed\n" 1722" Test: test_lw_dist2d_pt_arc ...passed\n" 1723" Test: test_lw_dist2d_seg_arc ...passed\n" 1724" Test: test_lw_dist2d_arc_arc ...passed\n" 1725" Test: test_lw_arc_length ...passed\n" 1726" Test: test_lw_dist2d_pt_ptarrayarc ...passed\n" 1727" Test: test_lw_dist2d_ptarray_ptarrayarc ...passed\n" 1728" Test: test_lwgeom_tcpa ...passed\n" 1729" Test: test_lwgeom_is_trajectory ...NOTICE: Geometry is not a LINESTRING\n" 1730"NOTICE: Line does not have M dimension\n" 1731"NOTICE: Measure of vertex 1 (1) not bigger than measure of vertex 0 (1)\n" 1732"NOTICE: Measure of vertex 1 (0) not bigger than measure of vertex 0 (1)\n" 1733"NOTICE: Measure of vertex 2 (2) not bigger than measure of vertex 1 (3)\n" 1734"passed\n" 1735" Test: test_rect_tree_distance_tree ...passed\n" 1736"Suite: effectivearea\n" 1737" Test: do_test_lwgeom_effectivearea_lines ...passed\n" 1738" Test: do_test_lwgeom_effectivearea_polys ...passed\n" 1739"Suite: chaikin\n" 1740" Test: do_test_chaikin_lines ...passed\n" 1741" Test: do_test_chaikin_polygons ...passed\n" 1742"Suite: filterm\n" 1743" Test: do_test_filterm_single_geometries ...passed\n" 1744" Test: do_test_filterm_collections ...passed\n" 1745"Suite: minimum_bounding_circle\n" 1746" Test: basic_test ...passed\n" 1747" Test: test_empty ...passed\n" 1748"Suite: miscellaneous\n" 1749" Test: test_misc_force_2d ...passed\n" 1750" Test: test_misc_simplify ...passed\n" 1751" Test: test_misc_count_vertices ...passed\n" 1752" Test: test_misc_area ...passed\n" 1753" Test: test_misc_wkb ...passed\n" 1754" Test: test_grid ...passed\n" 1755" Test: test_grid_in_place ...passed\n" 1756" Test: test_clone ...passed\n" 1757" Test: test_lwmpoint_from_lwgeom ...passed\n" 1758"Suite: noding\n" 1759" Test: test_lwgeom_node ...passed\n" 1760"Suite: encoded_polyline_output\n" 1761" Test: out_encoded_polyline_test_geoms ...passed\n" 1762" Test: out_encoded_polyline_test_srid ...passed\n" 1763" Test: out_encoded_polyline_test_precision ...passed\n" 1764"Suite: geojson_output\n" 1765" Test: out_geojson_test_precision ...passed\n" 1766" Test: out_geojson_test_dims ...passed\n" 1767" Test: out_geojson_test_srid ...passed\n" 1768" Test: out_geojson_test_bbox ...passed\n" 1769" Test: out_geojson_test_geoms ...passed\n" 1770"Suite: gml_output\n" 1771" Test: out_gml_test_precision ...passed\n" 1772" Test: out_gml_test_srid ...passed\n" 1773" Test: out_gml_test_dims ...passed\n" 1774" Test: out_gml_test_geodetic ...passed\n" 1775" Test: out_gml_test_geoms ...passed\n" 1776" Test: out_gml_test_geoms_prefix ...passed\n" 1777" Test: out_gml_test_geoms_nodims ...passed\n" 1778" Test: out_gml2_extent ...passed\n" 1779" Test: out_gml3_extent ...passed\n" 1780"Suite: kml_output\n" 1781" Test: out_kml_test_precision ...passed\n" 1782" Test: out_kml_test_dims ...passed\n" 1783" Test: out_kml_test_geoms ...passed\n" 1784" Test: out_kml_test_prefix ...passed\n" 1785"Suite: svg_output\n" 1786" Test: out_svg_test_precision ...passed\n" 1787" Test: out_svg_test_dims ...passed\n" 1788" Test: out_svg_test_relative ...passed\n" 1789" Test: out_svg_test_geoms ...passed\n" 1790" Test: out_svg_test_srid ...passed\n" 1791"Suite: x3d_output\n" 1792" Test: out_x3d3_test_precision ...passed\n" 1793" Test: out_x3d3_test_geoms ...passed\n" 1794" Test: out_x3d3_test_option ...passed\n" 1795"Suite: ptarray\n" 1796" Test: test_ptarray_append_point ...passed\n" 1797" Test: test_ptarray_append_ptarray ...passed\n" 1798" Test: test_ptarray_locate_point ...passed\n" 1799" Test: test_ptarray_isccw ...passed\n" 1800" Test: test_ptarray_signed_area ...passed\n" 1801" Test: test_ptarray_insert_point ...passed\n" 1802" Test: test_ptarray_contains_point ...passed\n" 1803" Test: test_ptarrayarc_contains_point ...passed\n" 1804" Test: test_ptarray_scale ...passed\n" 1805"Suite: printing\n" 1806" Test: test_lwprint_default_format ...passed\n" 1807" Test: test_lwprint_format_orders ...passed\n" 1808" Test: test_lwprint_optional_format ...passed\n" 1809" Test: test_lwprint_oddball_formats ...passed\n" 1810" Test: test_lwprint_bad_formats ...passed\n" 1811"Suite: sfcgal\n" 1812" Test: test_sfcgal_noop ...passed\n" 1813"Suite: split\n" 1814" Test: test_lwline_split_by_point_to ...passed\n" 1815" Test: test_lwgeom_split ...passed\n" 1816"Suite: stringbuffer\n" 1817" Test: test_stringbuffer_append ...passed\n" 1818" Test: test_stringbuffer_aprintf ...passed\n" 1819"Suite: surface\n" 1820" Test: triangle_parse ...passed\n" 1821" Test: tin_parse ...passed\n" 1822" Test: polyhedralsurface_parse ...passed\n" 1823" Test: surface_dimension ...passed\n" 1824"Suite: spatial_trees\n" 1825" Test: test_tree_circ_create ...passed\n" 1826" Test: test_tree_circ_pip ...passed\n" 1827" Test: test_tree_circ_pip2 ...passed\n" 1828" Test: test_tree_circ_distance ...passed\n" 1829" Test: test_tree_circ_distance_threshold ...passed\n" 1830"Suite: triangulate\n" 1831" Test: test_lwgeom_delaunay_triangulation ...passed\n" 1832" Test: test_lwgeom_voronoi_diagram ...passed\n" 1833" Test: test_lwgeom_voronoi_diagram_expected_empty ...passed\n" 1834" Test: test_lwgeom_voronoi_diagram_custom_envelope ...passed\n" 1835"Suite: twkb_output\n" 1836" Test: test_twkb_out_point ...passed\n" 1837" Test: test_twkb_out_linestring ...passed\n" 1838" Test: test_twkb_out_polygon ...passed\n" 1839" Test: test_twkb_out_multipoint ...passed\n" 1840" Test: test_twkb_out_multilinestring ...passed\n" 1841" Test: test_twkb_out_multipolygon ...passed\n" 1842" Test: test_twkb_out_collection ...passed\n" 1843" Test: test_twkb_out_idlist ...passed\n" 1844"Suite: varint\n" 1845" Test: test_zigzag ...passed\n" 1846" Test: test_varint ...passed\n" 1847" Test: test_varint_roundtrip ...passed\n" 1848"Suite: wkb_input\n" 1849" Test: test_wkb_in_point ...passed\n" 1850" Test: test_wkb_in_linestring ...passed\n" 1851" Test: test_wkb_in_polygon ...passed\n" 1852" Test: test_wkb_in_multipoint ...passed\n" 1853" Test: test_wkb_in_multilinestring ...passed\n" 1854" Test: test_wkb_in_multipolygon ...passed\n" 1855" Test: test_wkb_in_collection ...passed\n" 1856" Test: test_wkb_in_circularstring ...passed\n" 1857" Test: test_wkb_in_compoundcurve ...passed\n" 1858" Test: test_wkb_in_curvpolygon ...passed\n" 1859" Test: test_wkb_in_multicurve ...passed\n" 1860" Test: test_wkb_in_multisurface ...passed\n" 1861" Test: test_wkb_in_malformed ...passed\n" 1862"Suite: wkb_output\n" 1863" Test: test_wkb_out_point ...passed\n" 1864" Test: test_wkb_out_linestring ...passed\n" 1865" Test: test_wkb_out_polygon ...passed\n" 1866" Test: test_wkb_out_multipoint ...passed\n" 1867" Test: test_wkb_out_multilinestring ...passed\n" 1868" Test: test_wkb_out_multipolygon ...passed\n" 1869" Test: test_wkb_out_collection ...passed\n" 1870" Test: test_wkb_out_circularstring ...passed\n" 1871" Test: test_wkb_out_compoundcurve ...passed\n" 1872" Test: test_wkb_out_curvpolygon ...passed\n" 1873" Test: test_wkb_out_multicurve ...passed\n" 1874" Test: test_wkb_out_multisurface ...passed\n" 1875" Test: test_wkb_out_polyhedralsurface ...passed\n" 1876"Suite: wkt_input\n" 1877" Test: test_wkt_in_point ...passed\n" 1878" Test: test_wkt_in_linestring ...passed\n" 1879" Test: test_wkt_in_polygon ...passed\n" 1880" Test: test_wkt_in_multipoint ...passed\n" 1881" Test: test_wkt_in_multilinestring ...passed\n" 1882" Test: test_wkt_in_multipolygon ...passed\n" 1883" Test: test_wkt_in_collection ...passed\n" 1884" Test: test_wkt_in_circularstring ...passed\n" 1885" Test: test_wkt_in_compoundcurve ...passed\n" 1886" Test: test_wkt_in_curvpolygon ...passed\n" 1887" Test: test_wkt_in_multicurve ...passed\n" 1888" Test: test_wkt_in_multisurface ...passed\n" 1889" Test: test_wkt_in_tin ...passed\n" 1890" Test: test_wkt_in_polyhedralsurface ...passed\n" 1891" Test: test_wkt_in_errlocation ...passed\n" 1892" Test: test_wkt_double ...passed\n" 1893"Suite: wkt_output\n" 1894" Test: test_wkt_out_point ...passed\n" 1895" Test: test_wkt_out_linestring ...passed\n" 1896" Test: test_wkt_out_polygon ...passed\n" 1897" Test: test_wkt_out_multipoint ...passed\n" 1898" Test: test_wkt_out_multilinestring ...passed\n" 1899" Test: test_wkt_out_multipolygon ...passed\n" 1900" Test: test_wkt_out_collection ...passed\n" 1901" Test: test_wkt_out_circularstring ...passed\n" 1902" Test: test_wkt_out_compoundcurve ...passed\n" 1903" Test: test_wkt_out_curvpolygon ...passed\n" 1904" Test: test_wkt_out_multicurve ...passed\n" 1905" Test: test_wkt_out_multisurface ...passed\n" 1906"Suite: wrapx\n" 1907" Test: test_lwgeom_wrapx ...passed\n" 1908"\n" 1909"Run Summary: Type Total Ran Passed Failed Inactive\n" 1910" suites 44 44 n/a 0 0\n" 1911" tests 300 300 300 0 0\n" 1912" asserts 4215 4215 4215 0 n/a\n" 1913"Elapsed time = 0.229 seconds\n" 1914"\n" 1915"PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-posix-" 1916"seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit\n" 1917" Postgis 3.0.0dev - r17081 - 2018-11-28 18:50:02\n" 1918" scripts 3.0.0dev r17081\n" 1919" GEOS: 3.7.0-CAPI-1.11.0 673b9939\n" 1920" PROJ: Rel. 5.2.0, September 15th, 2018\n" 1921"\n" 1922"Running tests\n" 1923"\n" 1924" ../loader/Point .............. ok\n" 1925" ../loader/PointM .............. ok\n" 1926" ../loader/PointZ .............. ok\n" 1927" ../loader/MultiPoint .............. ok\n" 1928" ../loader/MultiPointM .............. ok\n" 1929" ../loader/MultiPointZ .............. ok\n" 1930" ../loader/Arc .............. ok\n" 1931" ../loader/ArcM .............. ok\n" 1932" ../loader/ArcZ .............. ok\n" 1933" ../loader/Polygon .............. ok\n" 1934" ../loader/PolygonM .............. ok\n" 1935" ../loader/PolygonZ .............. ok\n" 1936" ../loader/TSTPolygon ......... ok\n" 1937" ../loader/TSIPolygon ......... ok\n" 1938" ../loader/TSTIPolygon ......... ok\n" 1939" ../loader/PointWithSchema ..... ok\n" 1940" ../loader/NoTransPoint ......... ok\n" 1941" ../loader/NotReallyMultiPoint ......... ok\n" 1942" ../loader/MultiToSinglePoint ......... ok\n" 1943" ../loader/ReprojectPts ........ ok\n" 1944" ../loader/ReprojectPtsGeog ........ ok\n" 1945" ../loader/Latin1 .... ok\n" 1946" ../loader/Latin1-implicit .... ok\n" 1947" ../loader/mfile .... ok\n" 1948" ../dumper/literalsrid ....... ok\n" 1949" ../dumper/realtable ....... ok\n" 1950" affine .. ok\n" 1951" bestsrid .. ok\n" 1952" binary .. ok\n" 1953" boundary .. ok\n" 1954" chaikin .. ok\n" 1955" filterm .. ok\n" 1956" cluster .. ok\n" 1957" concave_hull .. ok\n" 1958" concave_hull_hard .. ok\n" 1959" ctors .. ok\n" 1960" curvetoline .. ok\n" 1961" dump .. ok\n" 1962" dumppoints .. ok\n" 1963" empty .. ok\n" 1964" estimatedextent .. ok\n" 1965" forcecurve .. ok\n" 1966" geography .. ok\n" 1967" geometric_median .. ok\n" 1968" in_geohash .. ok\n" 1969" in_gml .. ok\n" 1970" in_kml .. ok\n" 1971" in_encodedpolyline .. ok\n" 1972" iscollection .. ok\n" 1973" legacy .. ok\n" 1974" long_xact .. ok\n" 1975" lwgeom_regress .. ok\n" 1976" measures .. ok\n" 1977" minimum_bounding_circle .. ok\n" 1978" normalize .. ok\n" 1979" operators .. ok\n" 1980" orientation .. ok\n" 1981" out_geometry .. ok\n" 1982" out_geography .. ok\n" 1983" polygonize .. ok\n" 1984" polyhedralsurface .. ok\n" 1985" postgis_type_name .. ok\n" 1986" quantize_coordinates .. ok\n" 1987" regress .. ok\n" 1988" regress_bdpoly .. ok\n" 1989" regress_gist_index_nd .. ok\n" 1990" regress_index .. ok\n" 1991" regress_index_nulls .. ok\n" 1992" regress_management .. ok\n" 1993" regress_selectivity .. ok\n" 1994" regress_lrs .. ok\n" 1995" regress_ogc .. ok\n" 1996" regress_ogc_cover .. ok\n" 1997" regress_ogc_prep .. ok\n" 1998" regress_proj .. ok\n" 1999" relate .. ok\n" 2000" remove_repeated_points .. ok\n" 2001" removepoint .. ok\n" 2002" reverse .. ok\n" 2003" setpoint .. ok\n" 2004" simplify .. ok\n" 2005" simplifyvw .. ok\n" 2006" size .. ok\n" 2007" snaptogrid .. ok\n" 2008" split .. ok\n" 2009" sql-mm-serialize .. ok\n" 2010" sql-mm-circularstring .. ok\n" 2011" sql-mm-compoundcurve .. ok\n" 2012" sql-mm-curvepoly .. ok\n" 2013" sql-mm-general .. ok\n" 2014" sql-mm-multicurve .. ok\n" 2015" sql-mm-multisurface .. ok\n" 2016" swapordinates .. ok\n" 2017" summary .. ok\n" 2018" temporal .. ok\n" 2019" tickets .. ok\n" 2020" twkb .. ok\n" 2021" typmod .. ok\n" 2022" wkb .. ok\n" 2023" wkt .. ok\n" 2024" wmsservers .. ok\n" 2025" knn_recheck .. ok\n" 2026" temporal_knn .. ok\n" 2027" hausdorff .. ok\n" 2028" regress_buffer_params .. ok\n" 2029" frechet .. ok\n" 2030" offsetcurve .. ok\n" 2031" relatematch .. ok\n" 2032" isvaliddetail .. ok\n" 2033" sharedpaths .. ok\n" 2034" snap .. ok\n" 2035" node .. ok\n" 2036" unaryunion .. ok\n" 2037" clean .. ok\n" 2038" relate_bnr .. ok\n" 2039" delaunaytriangles .. ok\n" 2040" clipbybox2d .. ok\n" 2041" subdivide .. ok\n" 2042" voronoi .. ok\n" 2043" minimum_clearance .. ok\n" 2044" oriented_envelope .. ok\n" 2045" in_geojson .. ok\n" 2046" regress_brin_index .. ok\n" 2047" regress_brin_index_3d .. ok\n" 2048" regress_brin_index_geography .. ok\n" 2049" regress_spgist_index_2d .. ok\n" 2050" regress_spgist_index_3d .. ok\n" 2051" regress_spgist_index_nd .. ok\n" 2052" mvt .. ok\n" 2053" geobuf .. ok\n" 2054" mvt_jsonb .. ok\n" 2055" uninstall .. ok (4643)\n" 2056"\n" 2057"Run tests: 134\n" 2058"Failed: 0\n" 2059"\n" 2060"\n" 2061"-- if you build with SFCGAL\n" 2062"\n" 2063"PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-posix-" 2064"seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit\n" 2065" Postgis 3.0.0dev - r17081 - 2018-11-28 18:50:02\n" 2066" scripts 3.0.0dev r17081\n" 2067" GEOS: 3.7.0-CAPI-1.11.0 673b9939\n" 2068" PROJ: Rel. 5.2.0, September 15th, 2018\n" 2069" SFCGAL: 1.3.2\n" 2070"\n" 2071"Running tests\n" 2072"\n" 2073" regress_sfcgal .. ok\n" 2074" empty .. ok\n" 2075" geography .. ok\n" 2076" legacy .. ok\n" 2077" measures .. ok\n" 2078" regress_ogc_prep .. ok\n" 2079" regress_ogc .. ok\n" 2080" regress .. ok\n" 2081" tickets .. ok\n" 2082" concave_hull .. ok\n" 2083" wmsservers .. ok\n" 2084" approximatemedialaxis .. ok\n" 2085" uninstall .. ok (4643)\n" 2086"\n" 2087"Run tests: 13\n" 2088"Failed: 0\n" 2089"\n" 2090"-- if you built with raster support\n" 2091"\n" 2092"\n" 2093"\n" 2094" CUnit - A unit testing framework for C - Version 2.1-2\n" 2095" http://cunit.sourceforge.net/\n" 2096"\n" 2097"\n" 2098"Suite: pixtype\n" 2099" Test: test_pixtype_size ...passed\n" 2100" Test: test_pixtype_alignment ...passed\n" 2101" Test: test_pixtype_name ...passed\n" 2102" Test: test_pixtype_index_from_name ...passed\n" 2103" Test: test_pixtype_get_min_value ...passed\n" 2104" Test: test_pixtype_compare_clamped_values ...passed\n" 2105"Suite: raster_basics\n" 2106" Test: test_raster_new ...passed\n" 2107" Test: test_raster_empty ...passed\n" 2108" Test: test_raster_metadata ...passed\n" 2109" Test: test_raster_clone ...passed\n" 2110" Test: test_raster_from_band ...passed\n" 2111" Test: test_raster_replace_band ...passed\n" 2112"Suite: band_basics\n" 2113" Test: test_band_metadata ...passed\n" 2114" Test: test_band_pixtype_1BB ...passed\n" 2115" Test: test_band_pixtype_2BUI ...passed\n" 2116" Test: test_band_pixtype_4BUI ...passed\n" 2117" Test: test_band_pixtype_8BUI ...passed\n" 2118" Test: test_band_pixtype_8BSI ...passed\n" 2119" Test: test_band_pixtype_16BUI ...passed\n" 2120" Test: test_band_pixtype_16BSI ...passed\n" 2121" Test: test_band_pixtype_32BUI ...passed\n" 2122" Test: test_band_pixtype_32BSI ...passed\n" 2123" Test: test_band_pixtype_32BF ...passed\n" 2124" Test: test_band_pixtype_64BF ...passed\n" 2125" Test: test_band_get_pixel_line ...WARNING: Limiting returning number " 2126"values to 1\n" 2127"WARNING: Attempting to get pixel values with out of range raster " 2128"coordinates: (5, 5)\n" 2129"passed\n" 2130" Test: test_band_new_offline_from_path ...passed\n" 2131"Suite: raster_wkb\n" 2132" Test: test_raster_wkb ...SRID value -1 converted to the officially unknown " 2133"SRID value 0\n" 2134"SRID value -1 converted to the officially unknown SRID value 0\n" 2135"SRID value -1 converted to the officially unknown SRID value 0\n" 2136"SRID value -1 converted to the officially unknown SRID value 0\n" 2137"SRID value -1 converted to the officially unknown SRID value 0\n" 2138"SRID value -1 converted to the officially unknown SRID value 0\n" 2139"passed\n" 2140"Suite: gdal\n" 2141" Test: test_gdal_configured ...passed\n" 2142" Test: test_gdal_drivers ...passed\n" 2143" Test: test_gdal_rasterize ...passed\n" 2144" Test: test_gdal_polygonize ...passed\n" 2145" Test: test_raster_to_gdal ...Warning 6: PNG driver doesn't support data " 2146"type Float64. Only eight bit (Byte) and sixteen bit (UInt16) bands " 2147"supported. Defaulting to Byte\n" 2148"\n" 2149"passed\n" 2150" Test: test_gdal_to_raster ...passed\n" 2151" Test: test_gdal_warp ...passed\n" 2152"Suite: raster_geometry\n" 2153" Test: test_raster_envelope ...passed\n" 2154" Test: test_raster_envelope_geom ...passed\n" 2155" Test: test_raster_convex_hull ...passed\n" 2156" Test: test_raster_surface ...INFO: Ring Self-intersection at or near point " 2157"2 -2\n" 2158"INFO: Ring Self-intersection at or near point 3 -3\n" 2159"passed\n" 2160" Test: test_raster_perimeter ...passed\n" 2161" Test: test_raster_pixel_as_polygon ...passed\n" 2162"Suite: raster_misc\n" 2163" Test: test_raster_cell_to_geopoint ...passed\n" 2164" Test: test_raster_geopoint_to_cell ...passed\n" 2165" Test: test_raster_from_two_rasters ...passed\n" 2166" Test: test_raster_compute_skewed_raster ...passed\n" 2167"Suite: band_stats\n" 2168" Test: test_band_stats ...passed\n" 2169" Test: test_band_value_count ...passed\n" 2170"Suite: band_misc\n" 2171" Test: test_band_get_nearest_pixel ...passed\n" 2172" Test: test_band_get_pixel_of_value ...passed\n" 2173" Test: test_pixel_set_to_array ...passed\n" 2174"Suite: mapalgebra\n" 2175" Test: test_raster_iterator ...passed\n" 2176" Test: test_band_reclass ...passed\n" 2177" Test: test_raster_colormap ...passed\n" 2178"Suite: spatial_relationship\n" 2179" Test: test_raster_geos_overlaps ...passed\n" 2180" Test: test_raster_geos_touches ...passed\n" 2181" Test: test_raster_geos_contains ...passed\n" 2182" Test: test_raster_geos_contains_properly ...passed\n" 2183" Test: test_raster_geos_covers ...passed\n" 2184" Test: test_raster_geos_covered_by ...passed\n" 2185" Test: test_raster_within_distance ...passed\n" 2186" Test: test_raster_fully_within_distance ...passed\n" 2187" Test: test_raster_intersects ...passed\n" 2188" Test: test_raster_same_alignment ...passed\n" 2189"Suite: misc\n" 2190" Test: test_rgb_to_hsv ...passed\n" 2191" Test: test_hsv_to_rgb ...passed\n" 2192" Test: test_util_gdal_open ...passed\n" 2193"\n" 2194"Run Summary: Type Total Ran Passed Failed Inactive\n" 2195" suites 12 12 n/a 0 0\n" 2196" tests 65 65 65 0 0\n" 2197" asserts 45896 45896 45896 0 n/a\n" 2198"\n" 2199"Elapsed time = 0.499 seconds\n" 2200"\n" 2201"Loading Raster into 'postgis_reg'\n" 2202"PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-posix-" 2203"seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit\n" 2204" Postgis 3.0.0dev - r17081 - 2018-11-28 18:50:02\n" 2205" scripts 3.0.0dev r17081\n" 2206" raster scripts 3.0.0dev r17081\n" 2207" GEOS: 3.7.0-CAPI-1.11.0 673b9939\n" 2208" PROJ: Rel. 5.2.0, September 15th, 2018\n" 2209" GDAL: GDAL 2.3.1, released 2018/06/22\n" 2210"\n" 2211"Running tests\n" 2212"\n" 2213" check_gdal .. ok\n" 2214" load_outdb ... ok\n" 2215" check_raster_columns .. ok\n" 2216" check_raster_overviews .. ok\n" 2217" rt_io .. ok\n" 2218" rt_bytea .. ok\n" 2219" rt_wkb .. ok\n" 2220" box3d .. ok\n" 2221" rt_addband .. ok\n" 2222" rt_band .. ok\n" 2223" rt_tile .. ok\n" 2224" rt_dimensions .. ok\n" 2225" rt_scale .. ok\n" 2226" rt_pixelsize .. ok\n" 2227" rt_upperleft .. ok\n" 2228" rt_rotation .. ok\n" 2229" rt_georeference .. ok\n" 2230" rt_set_properties .. ok\n" 2231" rt_isempty .. ok\n" 2232" rt_hasnoband .. ok\n" 2233" rt_metadata .. ok\n" 2234" rt_rastertoworldcoord .. ok\n" 2235" rt_worldtorastercoord .. ok\n" 2236" rt_convexhull .. ok\n" 2237" rt_envelope .. ok\n" 2238" rt_band_properties .. ok\n" 2239" rt_set_band_properties .. ok\n" 2240" rt_pixelaspolygons .. ok\n" 2241" rt_pixelaspoints .. ok\n" 2242" rt_pixelascentroids .. ok\n" 2243" rt_setvalues_array .. ok\n" 2244" rt_summarystats .. ok\n" 2245" rt_count .. ok\n" 2246" rt_histogram .. ok\n" 2247" rt_quantile .. ok\n" 2248" rt_valuecount .. ok\n" 2249" rt_valuepercent .. ok\n" 2250" rt_bandmetadata .. ok\n" 2251" rt_pixelvalue .. ok\n" 2252" rt_neighborhood .. ok\n" 2253" rt_nearestvalue .. ok\n" 2254" rt_pixelofvalue .. ok\n" 2255" rt_polygon .. ok\n" 2256" rt_setbandpath .. ok\n" 2257" rt_utility .. ok\n" 2258" rt_fromgdalraster .. ok\n" 2259" rt_asgdalraster .. ok\n" 2260" rt_astiff .. ok\n" 2261" rt_asjpeg .. ok\n" 2262" rt_aspng .. ok\n" 2263" rt_reclass .. ok\n" 2264" rt_gdalwarp .. ok\n" 2265" rt_asraster .. ok\n" 2266" rt_dumpvalues .. ok\n" 2267" rt_makeemptycoverage .. ok\n" 2268" rt_createoverview .. ok\n" 2269" rt_mapalgebraexpr .. ok\n" 2270" rt_mapalgebrafct .. ok\n" 2271" rt_mapalgebraexpr_2raster .. ok\n" 2272" rt_mapalgebrafct_2raster .. ok\n" 2273" rt_mapalgebrafctngb .. ok\n" 2274" rt_mapalgebrafctngb_userfunc .. ok\n" 2275" rt_intersection .. ok\n" 2276" rt_clip .. ok\n" 2277" rt_mapalgebra .. ok\n" 2278" rt_mapalgebra_expr .. ok\n" 2279" rt_mapalgebra_mask .. ok\n" 2280" rt_union .. ok\n" 2281" rt_invdistweight4ma .. ok\n" 2282" rt_4ma .. ok\n" 2283" rt_setvalues_geomval .. ok\n" 2284" rt_elevation_functions .. ok\n" 2285" rt_colormap .. ok\n" 2286" rt_grayscale .. ok\n" 2287" rt_gist_relationships .. ok\n" 2288" rt_intersects .. ok\n" 2289" rt_samealignment .. ok\n" 2290" rt_geos_relationships .. ok\n" 2291" rt_iscoveragetile .. ok\n" 2292" bug_test_car5 .. ok\n" 2293" permitted_gdal_drivers .. ok\n" 2294" tickets .. ok\n" 2295" loader/Basic .. ok\n" 2296" loader/Projected ... ok\n" 2297" loader/BasicCopy .. ok\n" 2298" loader/BasicFilename .. ok\n" 2299" loader/BasicOutDB .. ok\n" 2300" loader/Tiled10x10 .. ok\n" 2301" loader/Tiled10x10Copy .. ok\n" 2302" loader/Tiled8x8 .. ok\n" 2303" clean .. ok\n" 2304" uninstall .. ok (4643)\n" 2305"\n" 2306"Run tests: 101\n" 2307"Failed: 0\n" 2308"\n" 2309"-- topology regress\n" 2310"PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-posix-" 2311"seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit\n" 2312" Postgis 3.0.0dev - r17081 - 2018-11-28 18:50:02\n" 2313" scripts 3.0.0dev r17081\n" 2314" GEOS: 3.7.0-CAPI-1.11.0 673b9939\n" 2315" PROJ: Rel. 5.2.0, September 15th, 2018\n" 2316"\n" 2317"Running tests\n" 2318"\n" 2319" regress/legacy_validate .. ok\n" 2320" regress/legacy_predicate .. ok\n" 2321" regress/legacy_invalid .. ok\n" 2322" regress/sqlmm .. ok\n" 2323" regress/legacy_query .. ok\n" 2324" regress/addnode .. ok\n" 2325" regress/addedge .. ok\n" 2326" regress/addface .. ok\n" 2327" regress/addface2.5d .. ok\n" 2328" regress/addtopogeometrycolumn .. ok\n" 2329" regress/polygonize .. ok\n" 2330" regress/st_addisoedge .. ok\n" 2331" regress/st_addisonode .. ok\n" 2332" regress/st_addedgemodface .. ok\n" 2333" regress/st_addedgenewfaces .. ok\n" 2334" regress/st_changeedgegeom .. ok\n" 2335" regress/st_createtopogeo .. ok\n" 2336" regress/st_getfacegeometry .. ok\n" 2337" regress/st_getfaceedges .. ok\n" 2338" regress/st_modedgeheal .. ok\n" 2339" regress/st_modedgesplit .. ok\n" 2340" regress/st_newedgeheal .. ok\n" 2341" regress/st_newedgessplit .. ok\n" 2342" regress/st_remedgenewface .. ok\n" 2343" regress/st_remedgemodface .. ok\n" 2344" regress/st_simplify .. ok\n" 2345" regress/topoelement .. ok\n" 2346" regress/topoelementarray_agg .. ok\n" 2347" regress/topogeo_addlinestring .. ok\n" 2348" regress/topogeo_addpoint .. ok\n" 2349" regress/topogeo_addpolygon .. ok\n" 2350" regress/topogeom_edit .. ok\n" 2351" regress/topogeometry_type .. ok\n" 2352" regress/topojson .. ok\n" 2353" regress/topologysummary .. ok\n" 2354" regress/topo2.5d .. ok\n" 2355" regress/totopogeom .. ok\n" 2356" regress/droptopology .. ok\n" 2357" regress/droptopogeometrycolumn .. ok\n" 2358" regress/copytopology .. ok\n" 2359" regress/createtopogeom .. ok\n" 2360" regress/createtopology .. ok\n" 2361" regress/gml .. ok\n" 2362" regress/getnodebypoint .. ok\n" 2363" regress/getedgebypoint .. ok\n" 2364" regress/getfacebypoint .. ok\n" 2365" regress/getringedges .. ok\n" 2366" regress/gettopogeomelements .. ok\n" 2367" regress/layertrigger .. ok\n" 2368" regress/validatetopology .. ok\n" 2369" uninstall .. ok (4643)\n" 2370"\n" 2371"Run tests: 51\n" 2372"Failed: 0\n" 2373"\n" 2374"-- if you built --with-gui, you should see this too\n" 2375"\n" 2376" CUnit - A unit testing framework for C - Version 2.1-2\n" 2377" http://cunit.sourceforge.net/\n" 2378"\n" 2379"\n" 2380"Suite: Shapefile Loader File shp2pgsql Test\n" 2381" Test: test_ShpLoaderCreate() ...passed\n" 2382" Test: test_ShpLoaderDestroy() ...passed\n" 2383"Suite: Shapefile Loader File pgsql2shp Test\n" 2384" Test: test_ShpDumperCreate() ...passed\n" 2385" Test: test_ShpDumperDestroy() ...passed\n" 2386"\n" 2387"Run Summary: Type Total Ran Passed Failed Inactive\n" 2388" suites 2 2 n/a 0 0\n" 2389" tests 4 4 4 0 0\n" 2390" asserts 4 4 4 0 n/a" 2391msgstr "" 2392"CUnit - A unit testing framework for C - Version 2.1-2\n" 2393" http://cunit.sourceforge.net/\n" 2394"\n" 2395"\n" 2396"Suite: computational_geometry\n" 2397" Test: test_lw_segment_side ...passed\n" 2398" Test: test_lw_segment_intersects ...passed\n" 2399" Test: test_lwline_crossing_short_lines ...passed\n" 2400" Test: test_lwline_crossing_long_lines ...passed\n" 2401" Test: test_lwline_crossing_bugs ...passed\n" 2402" Test: test_lwpoint_set_ordinate ...passed\n" 2403" Test: test_lwpoint_get_ordinate ...passed\n" 2404" Test: test_point_interpolate ...passed\n" 2405" Test: test_lwline_clip ...passed\n" 2406" Test: test_lwline_clip_big ...passed\n" 2407" Test: test_lwmline_clip ...passed\n" 2408" Test: test_geohash_point ...passed\n" 2409" Test: test_geohash_precision ...passed\n" 2410" Test: test_geohash ...passed\n" 2411" Test: test_geohash_point_as_int ...passed\n" 2412" Test: test_isclosed ...passed\n" 2413" Test: test_lwgeom_simplify ...passed\n" 2414"Suite: buildarea\n" 2415" Test: buildarea1 ...passed\n" 2416" Test: buildarea2 ...passed\n" 2417" Test: buildarea3 ...passed\n" 2418" Test: buildarea4 ...passed\n" 2419" Test: buildarea4b ...passed\n" 2420" Test: buildarea5 ...passed\n" 2421" Test: buildarea6 ...passed\n" 2422" Test: buildarea7 ...passed\n" 2423"Suite: geometry_clean\n" 2424" Test: test_lwgeom_make_valid ...passed\n" 2425"Suite: clip_by_rectangle\n" 2426" Test: test_lwgeom_clip_by_rect ...passed\n" 2427"Suite: force_sfs\n" 2428" Test: test_sfs_11 ...passed\n" 2429" Test: test_sfs_12 ...passed\n" 2430" Test: test_sqlmm ...passed\n" 2431"Suite: geodetic\n" 2432" Test: test_sphere_direction ...passed\n" 2433" Test: test_sphere_project ...passed\n" 2434" Test: test_lwgeom_area_sphere ...passed\n" 2435" Test: test_signum ...passed\n" 2436" Test: test_gbox_from_spherical_coordinates ...passed\n" 2437" Test: test_gserialized_get_gbox_geocentric ...passed\n" 2438" Test: test_clairaut ...passed\n" 2439" Test: test_edge_intersection ...passed\n" 2440" Test: test_edge_intersects ...passed\n" 2441" Test: test_edge_distance_to_point ...passed\n" 2442" Test: test_edge_distance_to_edge ...passed\n" 2443" Test: test_lwgeom_distance_sphere ...passed\n" 2444" Test: test_lwgeom_check_geodetic ...passed\n" 2445" Test: test_gserialized_from_lwgeom ...passed\n" 2446" Test: test_spheroid_distance ...passed\n" 2447" Test: test_spheroid_area ...passed\n" 2448" Test: test_lwpoly_covers_point2d ...passed\n" 2449" Test: test_gbox_utils ...passed\n" 2450" Test: test_vector_angle ...passed\n" 2451" Test: test_vector_rotate ...passed\n" 2452" Test: test_lwgeom_segmentize_sphere ...passed\n" 2453" Test: test_ptarray_contains_point_sphere ...passed\n" 2454" Test: test_ptarray_contains_point_sphere_iowa ...passed\n" 2455"Suite: GEOS\n" 2456" Test: test_geos_noop ...passed\n" 2457" Test: test_geos_subdivide ...passed\n" 2458" Test: test_geos_linemerge ...passed\n" 2459"Suite: Clustering\n" 2460" Test: basic_test ...passed\n" 2461" Test: nonsequential_test ...passed\n" 2462" Test: basic_distance_test ...passed\n" 2463" Test: single_input_test ...passed\n" 2464" Test: empty_inputs_test ...passed\n" 2465"Suite: Clustering Union-Find\n" 2466" Test: test_unionfind_create ...passed\n" 2467" Test: test_unionfind_union ...passed\n" 2468" Test: test_unionfind_ordered_by_cluster ...passed\n" 2469"Suite: homogenize\n" 2470" Test: test_coll_point ...passed\n" 2471" Test: test_coll_line ...passed\n" 2472" Test: test_coll_poly ...passed\n" 2473" Test: test_coll_coll ...passed\n" 2474" Test: test_geom ...passed\n" 2475" Test: test_coll_curve ...passed\n" 2476"Suite: encoded_polyline_input\n" 2477" Test: in_encoded_polyline_test_geoms ...passed\n" 2478" Test: in_encoded_polyline_test_precision ...passed\n" 2479"Suite: geojson_input\n" 2480" Test: in_geojson_test_srid ...passed\n" 2481" Test: in_geojson_test_bbox ...passed\n" 2482" Test: in_geojson_test_geoms ...passed\n" 2483"Suite: twkb_input\n" 2484" Test: test_twkb_in_point ...passed\n" 2485" Test: test_twkb_in_linestring ...passed\n" 2486" Test: test_twkb_in_polygon ...passed\n" 2487" Test: test_twkb_in_multipoint ...passed\n" 2488" Test: test_twkb_in_multilinestring ...passed\n" 2489" Test: test_twkb_in_multipolygon ...passed\n" 2490" Test: test_twkb_in_collection ...passed\n" 2491" Test: test_twkb_in_precision ...passed\n" 2492"Suite: serialization/deserialization\n" 2493" Test: test_typmod_macros ...passed\n" 2494" Test: test_flags_macros ...passed\n" 2495" Test: test_serialized_srid ...passed\n" 2496" Test: test_gserialized_from_lwgeom_size ...passed\n" 2497" Test: test_gbox_serialized_size ...passed\n" 2498" Test: test_lwgeom_from_gserialized ...passed\n" 2499" Test: test_lwgeom_count_vertices ...passed\n" 2500" Test: test_on_gser_lwgeom_count_vertices ...passed\n" 2501" Test: test_geometry_type_from_string ...passed\n" 2502" Test: test_lwcollection_extract ...passed\n" 2503" Test: test_lwgeom_free ...passed\n" 2504" Test: test_lwgeom_flip_coordinates ...passed\n" 2505" Test: test_f2d ...passed\n" 2506" Test: test_lwgeom_clone ...passed\n" 2507" Test: test_lwgeom_force_clockwise ...passed\n" 2508" Test: test_lwgeom_calculate_gbox ...passed\n" 2509" Test: test_lwgeom_is_empty ...passed\n" 2510" Test: test_lwgeom_same ...passed\n" 2511" Test: test_lwline_from_lwmpoint ...passed\n" 2512" Test: test_lwgeom_as_curve ...passed\n" 2513" Test: test_lwgeom_scale ...passed\n" 2514" Test: test_gserialized_is_empty ...passed\n" 2515" Test: test_gbox_same_2d ...passed\n" 2516"Suite: measures\n" 2517" Test: test_mindistance2d_tolerance ...passed\n" 2518" Test: test_rect_tree_contains_point ...passed\n" 2519" Test: test_rect_tree_intersects_tree ...passed\n" 2520" Test: test_lwgeom_segmentize2d ...passed\n" 2521" Test: test_lwgeom_locate_along ...passed\n" 2522" Test: test_lw_dist2d_pt_arc ...passed\n" 2523" Test: test_lw_dist2d_seg_arc ...passed\n" 2524" Test: test_lw_dist2d_arc_arc ...passed\n" 2525" Test: test_lw_arc_length ...passed\n" 2526" Test: test_lw_dist2d_pt_ptarrayarc ...passed\n" 2527" Test: test_lw_dist2d_ptarray_ptarrayarc ...passed\n" 2528" Test: test_lwgeom_tcpa ...passed\n" 2529" Test: test_lwgeom_is_trajectory ...passed\n" 2530"Suite: effectivearea\n" 2531" Test: do_test_lwgeom_effectivearea_lines ...passed\n" 2532" Test: do_test_lwgeom_effectivearea_polys ...passed\n" 2533"Suite: miscellaneous\n" 2534" Test: test_misc_force_2d ...passed\n" 2535" Test: test_misc_simplify ...passed\n" 2536" Test: test_misc_count_vertices ...passed\n" 2537" Test: test_misc_area ...passed\n" 2538" Test: test_misc_wkb ...passed\n" 2539" Test: test_grid ...passed\n" 2540"Suite: noding\n" 2541" Test: test_lwgeom_node ...passed\n" 2542"Suite: encoded_polyline_output\n" 2543" Test: out_encoded_polyline_test_geoms ...passed\n" 2544" Test: out_encoded_polyline_test_srid ...passed\n" 2545" Test: out_encoded_polyline_test_precision ...passed\n" 2546"Suite: geojson_output\n" 2547" Test: out_geojson_test_precision ...passed\n" 2548" Test: out_geojson_test_dims ...passed\n" 2549" Test: out_geojson_test_srid ...passed\n" 2550" Test: out_geojson_test_bbox ...passed\n" 2551" Test: out_geojson_test_geoms ...passed\n" 2552"Suite: gml_output\n" 2553" Test: out_gml_test_precision ...passed\n" 2554" Test: out_gml_test_srid ...passed\n" 2555" Test: out_gml_test_dims ...passed\n" 2556" Test: out_gml_test_geodetic ...passed\n" 2557" Test: out_gml_test_geoms ...passed\n" 2558" Test: out_gml_test_geoms_prefix ...passed\n" 2559" Test: out_gml_test_geoms_nodims ...passed\n" 2560" Test: out_gml2_extent ...passed\n" 2561" Test: out_gml3_extent ...passed\n" 2562"Suite: kml_output\n" 2563" Test: out_kml_test_precision ...passed\n" 2564" Test: out_kml_test_dims ...passed\n" 2565" Test: out_kml_test_geoms ...passed\n" 2566" Test: out_kml_test_prefix ...passed\n" 2567"Suite: svg_output\n" 2568" Test: out_svg_test_precision ...passed\n" 2569" Test: out_svg_test_dims ...passed\n" 2570" Test: out_svg_test_relative ...passed\n" 2571" Test: out_svg_test_geoms ...passed\n" 2572" Test: out_svg_test_srid ...passed\n" 2573"Suite: x3d_output\n" 2574" Test: out_x3d3_test_precision ...passed\n" 2575" Test: out_x3d3_test_geoms ...passed\n" 2576" Test: out_x3d3_test_option ...passed\n" 2577"Suite: ptarray\n" 2578" Test: test_ptarray_append_point ...passed\n" 2579" Test: test_ptarray_append_ptarray ...passed\n" 2580" Test: test_ptarray_locate_point ...passed\n" 2581" Test: test_ptarray_isccw ...passed\n" 2582" Test: test_ptarray_signed_area ...passed\n" 2583" Test: test_ptarray_unstroke ...passed\n" 2584" Test: test_ptarray_insert_point ...passed\n" 2585" Test: test_ptarray_contains_point ...passed\n" 2586" Test: test_ptarrayarc_contains_point ...passed\n" 2587" Test: test_ptarray_scale ...passed\n" 2588"Suite: printing\n" 2589" Test: test_lwprint_default_format ...passed\n" 2590" Test: test_lwprint_format_orders ...passed\n" 2591" Test: test_lwprint_optional_format ...passed\n" 2592" Test: test_lwprint_oddball_formats ...passed\n" 2593" Test: test_lwprint_bad_formats ...passed\n" 2594"Suite: SFCGAL\n" 2595" Test: test_sfcgal_noop ...passed\n" 2596"Suite: split\n" 2597" Test: test_lwline_split_by_point_to ...passed\n" 2598" Test: test_lwgeom_split ...passed\n" 2599"Suite: stringbuffer\n" 2600" Test: test_stringbuffer_append ...passed\n" 2601" Test: test_stringbuffer_aprintf ...passed\n" 2602"Suite: surface\n" 2603" Test: triangle_parse ...passed\n" 2604" Test: tin_parse ...passed\n" 2605" Test: polyhedralsurface_parse ...passed\n" 2606" Test: surface_dimension ...passed\n" 2607"Suite: Internal Spatial Trees\n" 2608" Test: test_tree_circ_create ...passed\n" 2609" Test: test_tree_circ_pip ...passed\n" 2610" Test: test_tree_circ_pip2 ...passed\n" 2611" Test: test_tree_circ_distance ...passed\n" 2612" Test: test_tree_circ_distance_threshold ...passed\n" 2613"Suite: triangulate\n" 2614" Test: test_lwgeom_delaunay_triangulation ...passed\n" 2615"Suite: twkb_output\n" 2616" Test: test_twkb_out_point ...passed\n" 2617" Test: test_twkb_out_linestring ...passed\n" 2618" Test: test_twkb_out_polygon ...passed\n" 2619" Test: test_twkb_out_multipoint ...passed\n" 2620" Test: test_twkb_out_multilinestring ...passed\n" 2621" Test: test_twkb_out_multipolygon ...passed\n" 2622" Test: test_twkb_out_collection ...passed\n" 2623" Test: test_twkb_out_idlist ...passed\n" 2624"Suite: varint\n" 2625" Test: test_zigzag ...passed\n" 2626" Test: test_varint ...passed\n" 2627" Test: test_varint_roundtrip ...passed\n" 2628"Suite: wkb_input\n" 2629" Test: test_wkb_in_point ...passed\n" 2630" Test: test_wkb_in_linestring ...passed\n" 2631" Test: test_wkb_in_polygon ...passed\n" 2632" Test: test_wkb_in_multipoint ...passed\n" 2633" Test: test_wkb_in_multilinestring ...passed\n" 2634" Test: test_wkb_in_multipolygon ...passed\n" 2635" Test: test_wkb_in_collection ...passed\n" 2636" Test: test_wkb_in_circularstring ...passed\n" 2637" Test: test_wkb_in_compoundcurve ...passed\n" 2638" Test: test_wkb_in_curvpolygon ...passed\n" 2639" Test: test_wkb_in_multicurve ...passed\n" 2640" Test: test_wkb_in_multisurface ...passed\n" 2641" Test: test_wkb_in_malformed ...passed\n" 2642"Suite: wkb_output\n" 2643" Test: test_wkb_out_point ...passed\n" 2644" Test: test_wkb_out_linestring ...passed\n" 2645" Test: test_wkb_out_polygon ...passed\n" 2646" Test: test_wkb_out_multipoint ...passed\n" 2647" Test: test_wkb_out_multilinestring ...passed\n" 2648" Test: test_wkb_out_multipolygon ...passed\n" 2649" Test: test_wkb_out_collection ...passed\n" 2650" Test: test_wkb_out_circularstring ...passed\n" 2651" Test: test_wkb_out_compoundcurve ...passed\n" 2652" Test: test_wkb_out_curvpolygon ...passed\n" 2653" Test: test_wkb_out_multicurve ...passed\n" 2654" Test: test_wkb_out_multisurface ...passed\n" 2655" Test: test_wkb_out_polyhedralsurface ...passed\n" 2656"Suite: wkt_input\n" 2657" Test: test_wkt_in_point ...passed\n" 2658" Test: test_wkt_in_linestring ...passed\n" 2659" Test: test_wkt_in_polygon ...passed\n" 2660" Test: test_wkt_in_multipoint ...passed\n" 2661" Test: test_wkt_in_multilinestring ...passed\n" 2662" Test: test_wkt_in_multipolygon ...passed\n" 2663" Test: test_wkt_in_collection ...passed\n" 2664" Test: test_wkt_in_circularstring ...passed\n" 2665" Test: test_wkt_in_compoundcurve ...passed\n" 2666" Test: test_wkt_in_curvpolygon ...passed\n" 2667" Test: test_wkt_in_multicurve ...passed\n" 2668" Test: test_wkt_in_multisurface ...passed\n" 2669" Test: test_wkt_in_tin ...passed\n" 2670" Test: test_wkt_in_polyhedralsurface ...passed\n" 2671" Test: test_wkt_in_errlocation ...passed\n" 2672"Suite: wkt_output\n" 2673" Test: test_wkt_out_point ...passed\n" 2674" Test: test_wkt_out_linestring ...passed\n" 2675" Test: test_wkt_out_polygon ...passed\n" 2676" Test: test_wkt_out_multipoint ...passed\n" 2677" Test: test_wkt_out_multilinestring ...passed\n" 2678" Test: test_wkt_out_multipolygon ...passed\n" 2679" Test: test_wkt_out_collection ...passed\n" 2680" Test: test_wkt_out_circularstring ...passed\n" 2681" Test: test_wkt_out_compoundcurve ...passed\n" 2682" Test: test_wkt_out_curvpolygon ...passed\n" 2683" Test: test_wkt_out_multicurve ...passed\n" 2684" Test: test_wkt_out_multisurface ...passed\n" 2685"\n" 2686"Run Summary: Type Total Ran Passed Failed Inactive\n" 2687" suites 38 38 n/a 0 0\n" 2688" tests 251 251 251 0 0\n" 2689" asserts 2468 2468 2468 0 n/a\n" 2690"\n" 2691"Elapsed time = 0.298 seconds\n" 2692"\n" 2693"Creating database 'postgis_reg'\n" 2694"Loading PostGIS into 'postgis_reg'\n" 2695" /projects/postgis/branches/2.2/regress/00-regress-install/share/contrib/" 2696"postgis/postgis.sql\n" 2697" /projects/postgis/branches/2.2/regress/00-regress-install/share/contrib/" 2698"postgis/postgis_comments.sql\n" 2699"Loading SFCGAL into 'postgis_reg'\n" 2700" /projects/postgis/branches/2.2/regress/00-regress-install/share/contrib/" 2701"postgis/sfcgal.sql\n" 2702" /projects/postgis/branches/2.2/regress/00-regress-install/share/contrib/" 2703"postgis/sfcgal_comments.sql\n" 2704"PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 32-bit\n" 2705" Postgis 2.2.0dev - r13980 - 2015-08-23 06:13:07\n" 2706" scripts 2.2.0dev r13980\n" 2707" GEOS: 3.5.0-CAPI-1.9.0 r4088\n" 2708" PROJ: Rel. 4.9.1, 04 March 2015\n" 2709" SFCGAL: 1.1.0\n" 2710"\n" 2711"Running tests\n" 2712"\n" 2713" loader/Point .............. ok\n" 2714" loader/PointM .............. ok\n" 2715" loader/PointZ .............. ok\n" 2716" loader/MultiPoint .............. ok\n" 2717" loader/MultiPointM .............. ok\n" 2718" loader/MultiPointZ .............. ok\n" 2719" loader/Arc .............. ok\n" 2720" loader/ArcM .............. ok\n" 2721" loader/ArcZ .............. ok\n" 2722" loader/Polygon .............. ok\n" 2723" loader/PolygonM .............. ok\n" 2724" loader/PolygonZ .............. ok\n" 2725" loader/TSTPolygon ......... ok\n" 2726" loader/TSIPolygon ......... ok\n" 2727" loader/TSTIPolygon ......... ok\n" 2728" loader/PointWithSchema ..... ok\n" 2729" loader/NoTransPoint ......... ok\n" 2730" loader/NotReallyMultiPoint ......... ok\n" 2731" loader/MultiToSinglePoint ......... ok\n" 2732" loader/ReprojectPts ........ ok\n" 2733" loader/ReprojectPtsGeog ........ ok\n" 2734" loader/Latin1 .... ok\n" 2735" loader/Latin1-implicit .... ok\n" 2736" loader/mfile .... ok\n" 2737" dumper/literalsrid ....... ok\n" 2738" dumper/realtable ....... ok\n" 2739" affine .. ok\n" 2740" bestsrid .. ok\n" 2741" binary .. ok\n" 2742" boundary .. ok\n" 2743" cluster .. ok\n" 2744" concave_hull .. ok\n" 2745" ctors .. ok\n" 2746" dump .. ok\n" 2747" dumppoints .. ok\n" 2748" empty .. ok\n" 2749" forcecurve .. ok\n" 2750" geography .. ok\n" 2751" in_geohash .. ok\n" 2752" in_gml .. ok\n" 2753" in_kml .. ok\n" 2754" in_encodedpolyline .. ok\n" 2755" iscollection .. ok\n" 2756" legacy .. ok\n" 2757" long_xact .. ok\n" 2758" lwgeom_regress .. ok\n" 2759" measures .. ok\n" 2760" operators .. ok\n" 2761" out_geometry .. ok\n" 2762" out_geography .. ok\n" 2763" polygonize .. ok\n" 2764" polyhedralsurface .. ok\n" 2765" postgis_type_name .. ok\n" 2766" regress .. ok\n" 2767" regress_bdpoly .. ok\n" 2768" regress_index .. ok\n" 2769" regress_index_nulls .. ok\n" 2770" regress_management .. ok\n" 2771" regress_selectivity .. ok\n" 2772" regress_lrs .. ok\n" 2773" regress_ogc .. ok\n" 2774" regress_ogc_cover .. ok\n" 2775" regress_ogc_prep .. ok\n" 2776" regress_proj .. ok\n" 2777" relate .. ok\n" 2778" remove_repeated_points .. ok\n" 2779" removepoint .. ok\n" 2780" setpoint .. ok\n" 2781" simplify .. ok\n" 2782" simplifyvw .. ok\n" 2783" size .. ok\n" 2784" snaptogrid .. ok\n" 2785" split .. ok\n" 2786" sql-mm-serialize .. ok\n" 2787" sql-mm-circularstring .. ok\n" 2788" sql-mm-compoundcurve .. ok\n" 2789" sql-mm-curvepoly .. ok\n" 2790" sql-mm-general .. ok\n" 2791" sql-mm-multicurve .. ok\n" 2792" sql-mm-multisurface .. ok\n" 2793" swapordinates .. ok\n" 2794" summary .. ok\n" 2795" temporal .. ok\n" 2796" tickets .. ok\n" 2797" twkb .. ok\n" 2798" typmod .. ok\n" 2799" wkb .. ok\n" 2800" wkt .. ok\n" 2801" wmsservers .. ok\n" 2802" knn .. ok\n" 2803" hausdorff .. ok\n" 2804" regress_buffer_params .. ok\n" 2805" offsetcurve .. ok\n" 2806" relatematch .. ok\n" 2807" isvaliddetail .. ok\n" 2808" sharedpaths .. ok\n" 2809" snap .. ok\n" 2810" node .. ok\n" 2811" unaryunion .. ok\n" 2812" clean .. ok\n" 2813" relate_bnr .. ok\n" 2814" delaunaytriangles .. ok\n" 2815" clipbybox2d .. ok\n" 2816" subdivide .. ok\n" 2817" in_geojson .. ok\n" 2818" regress_sfcgal .. ok\n" 2819" sfcgal/empty .. ok\n" 2820" sfcgal/geography .. ok\n" 2821" sfcgal/legacy .. ok\n" 2822" sfcgal/measures .. ok\n" 2823" sfcgal/regress_ogc_prep .. ok\n" 2824" sfcgal/regress_ogc .. ok\n" 2825" sfcgal/regress .. ok\n" 2826" sfcgal/tickets .. ok\n" 2827" sfcgal/concave_hull .. ok\n" 2828" sfcgal/wmsservers .. ok\n" 2829" sfcgal/approximatemedialaxis .. ok\n" 2830" uninstall . /projects/postgis/branches/2.2/regress/00-regress-install/" 2831"share/contrib/postgis/uninstall_sfcgal.sql\n" 2832" /projects/postgis/branches/2.2/regress/00-regress-install/share/contrib/" 2833"postgis/uninstall_postgis.sql\n" 2834". ok (4336)\n" 2835"\n" 2836"Run tests: 118\n" 2837"Failed: 0\n" 2838"\n" 2839"-- if you built --with-gui, you should see this too\n" 2840"\n" 2841" CUnit - A unit testing framework for C - Version 2.1-2\n" 2842" http://cunit.sourceforge.net/\n" 2843"\n" 2844"\n" 2845"Suite: Shapefile Loader File shp2pgsql Test\n" 2846" Test: test_ShpLoaderCreate() ...passed\n" 2847" Test: test_ShpLoaderDestroy() ...passed\n" 2848"Suite: Shapefile Loader File pgsql2shp Test\n" 2849" Test: test_ShpDumperCreate() ...passed\n" 2850" Test: test_ShpDumperDestroy() ...passed\n" 2851"\n" 2852"Run Summary: Type Total Ran Passed Failed Inactive\n" 2853" suites 2 2 n/a 0 0\n" 2854" tests 4 4 4 0 0\n" 2855" asserts 4 4 4 0 n/a" 2856 2857#. Tag: para 2858#: installation.xml:747 2859#, no-c-format 2860msgid "" 2861"The <varname>postgis_tiger_geocoder</varname> and " 2862"<varname>address_standardizer</varname> extensions, currenlty only support " 2863"the standard PostgreSQL installcheck. To test these use the below. Note: the " 2864"make install is not necessary if you already did make install at root of " 2865"PostGIS code folder." 2866msgstr "" 2867 2868#. Tag: para 2869#: installation.xml:748 2870#, no-c-format 2871msgid "For address_standardizer:" 2872msgstr "" 2873 2874#. Tag: programlisting 2875#: installation.xml:749 2876#, no-c-format 2877msgid "" 2878"cd extensions/address_standardizer\n" 2879"make install\n" 2880"make installcheck" 2881msgstr "" 2882 2883#. Tag: para 2884#: installation.xml:751 2885#, no-c-format 2886msgid "Output should look like:" 2887msgstr "" 2888 2889#. Tag: screen 2890#: installation.xml:752 2891#, no-c-format 2892msgid "" 2893"============== dropping database \"contrib_regression\" ==============\n" 2894"DROP DATABASE\n" 2895"============== creating database \"contrib_regression\" ==============\n" 2896"CREATE DATABASE\n" 2897"ALTER DATABASE\n" 2898"============== running regression test queries ==============\n" 2899"test test-init-extensions ... ok\n" 2900"test test-parseaddress ... ok\n" 2901"test test-standardize_address_1 ... ok\n" 2902"test test-standardize_address_2 ... ok\n" 2903"\n" 2904"=====================\n" 2905" All 4 tests passed.\n" 2906"=====================" 2907msgstr "" 2908 2909#. Tag: para 2910#: installation.xml:754 2911#, no-c-format 2912msgid "" 2913"For tiger geocoder, make sure you have postgis and fuzzystrmatch extensions " 2914"available in your PostgreSQL instance. The address_standardizer tests will " 2915"also kick in if you built postgis with address_standardizer support:" 2916msgstr "" 2917 2918#. Tag: programlisting 2919#: installation.xml:755 2920#, no-c-format 2921msgid "" 2922"cd extensions/postgis_tiger_geocoder\n" 2923"make install\n" 2924"make installcheck" 2925msgstr "" 2926 2927#. Tag: para 2928#: installation.xml:756 2929#, no-c-format 2930msgid "output should look like:" 2931msgstr "" 2932 2933#. Tag: screen 2934#: installation.xml:757 2935#, no-c-format 2936msgid "" 2937"============== dropping database \"contrib_regression\" ==============\n" 2938"DROP DATABASE\n" 2939"============== creating database \"contrib_regression\" ==============\n" 2940"CREATE DATABASE\n" 2941"ALTER DATABASE\n" 2942"============== installing fuzzystrmatch ==============\n" 2943"CREATE EXTENSION\n" 2944"============== installing postgis ==============\n" 2945"CREATE EXTENSION\n" 2946"============== installing postgis_tiger_geocoder ==============\n" 2947"CREATE EXTENSION\n" 2948"============== installing address_standardizer ==============\n" 2949"CREATE EXTENSION\n" 2950"============== running regression test queries ==============\n" 2951"test test-normalize_address ... ok\n" 2952"test test-pagc_normalize_address ... ok\n" 2953"\n" 2954"=====================\n" 2955"All 2 tests passed.\n" 2956"=====================" 2957msgstr "" 2958 2959#. Tag: title 2960#: installation.xml:761 2961#, no-c-format 2962msgid "Installation" 2963msgstr "Instalación" 2964 2965#. Tag: para 2966#: installation.xml:763 2967#, no-c-format 2968msgid "To install PostGIS, type" 2969msgstr "Para instalar PostGIS entre" 2970 2971#. Tag: command 2972#: installation.xml:768 2973#, no-c-format 2974msgid "make install" 2975msgstr "make install" 2976 2977#. Tag: para 2978#: installation.xml:771 2979#, no-c-format 2980msgid "" 2981"This will copy the PostGIS installation files into their appropriate " 2982"subdirectory specified by the <command>--prefix</command> configuration " 2983"parameter. In particular:" 2984msgstr "" 2985"Esto copiará los ficheros de instalación de PostGIS en el subdirectorio " 2986"especificado por el parámetro de configuración <command>--prefix</command> " 2987"del comando . En particular:" 2988 2989#. Tag: para 2990#: installation.xml:779 2991#, no-c-format 2992msgid "" 2993"The loader and dumper binaries are installed in <filename>[prefix]/bin</" 2994"filename>." 2995msgstr "" 2996"Los archivos binarios de carga y dumper estarán instalados en " 2997"<filename>[prefix]/bin</filename>." 2998 2999#. Tag: para 3000#: installation.xml:786 3001#, no-c-format 3002msgid "" 3003"The SQL files, such as <filename>postgis.sql</filename>, are installed in " 3004"<filename>[prefix]/share/contrib</filename>." 3005msgstr "" 3006"Los archivos SQL, tal como <filename>postgis.sql</filename>, están " 3007"instalados en <filename>[prefix]/share/contrib</filename>." 3008 3009#. Tag: para 3010#: installation.xml:793 3011#, no-c-format 3012msgid "" 3013"The PostGIS libraries are installed in <filename>[prefix]/lib</filename>." 3014msgstr "" 3015"Las librerías de PostGIS estarán instaladas en <filename>[prefix]/lib</" 3016"filename>." 3017 3018#. Tag: para 3019#: installation.xml:800 3020#, no-c-format 3021msgid "" 3022"If you previously ran the <command>make comments</command> command to " 3023"generate the <filename>postgis_comments.sql</filename>, " 3024"<filename>raster_comments.sql</filename> file, install the sql file by " 3025"running" 3026msgstr "" 3027"Si has ejecutado el comando <command>make comments</command> previamente " 3028"para generar los ficheros <filename>postgis_comments.sql</filename>, " 3029"<filename>raster_comments.sql</filename>, instala los ficheros sql " 3030"ejecutando:" 3031 3032#. Tag: command 3033#: installation.xml:807 3034#, no-c-format 3035msgid "make comments-install" 3036msgstr "make comments-install" 3037 3038#. Tag: para 3039#: installation.xml:811 3040#, no-c-format 3041msgid "" 3042"<filename>postgis_comments.sql</filename>, <filename>raster_comments.sql</" 3043"filename>, <filename>topology_comments.sql</filename> was separated from the " 3044"typical build and installation targets since with it comes the extra " 3045"dependency of <command>xsltproc</command>." 3046msgstr "" 3047"<filename>postgis_comments.sql</filename>, <filename>raster_comments.sql</" 3048"filename>, <filename>topology_comments.sql</filename> han sido separados de " 3049"la compilación y de la instalación típicos ya que tienen una dependencia " 3050"extra de la librería <command>xsltproc</command>." 3051 3052#. Tag: title 3053#: installation.xml:821 3054#, no-c-format 3055msgid "Creating a spatial database using EXTENSIONS" 3056msgstr "Crear una base de datos espacial utilizando EXTENSIONS" 3057 3058#. Tag: para 3059#: installation.xml:823 3060#, no-c-format 3061msgid "" 3062"If you are using PostgreSQL 9.1+ and have compiled and installed the " 3063"extensions/ postgis modules, you can create a spatial database the new way." 3064msgstr "" 3065"Si estas utilizando PostgreSQL 9.1+ y has compilado e instalado los módulos/" 3066"extensión PostGIS, puedes crear una base de datos espacial de otra manera." 3067 3068#. Tag: command 3069#: installation.xml:829 installation.xml:877 3070#, no-c-format 3071msgid "createdb [yourdatabase]" 3072msgstr "createdb [subasededatos]" 3073 3074#. Tag: para 3075#: installation.xml:832 3076#, no-c-format 3077msgid "" 3078"The core postgis extension installs PostGIS geometry, geography, " 3079"spatial_ref_sys and all the functions and comments with a simple: " 3080"<programlisting>CREATE EXTENSION postgis;</programlisting> command." 3081msgstr "" 3082 3083#. Tag: command 3084#: installation.xml:838 3085#, no-c-format 3086msgid "psql -d [yourdatabase] -c \"CREATE EXTENSION postgis;\"" 3087msgstr "psql -d [yourdatabase] -c \"CREATE EXTENSION postgis;\"" 3088 3089#. Tag: para 3090#: installation.xml:841 3091#, no-c-format 3092msgid "" 3093"Raster is packaged as a separate extension and installable with command:" 3094msgstr "" 3095 3096#. Tag: command 3097#: installation.xml:846 3098#, no-c-format 3099msgid "psql -d [yourdatabase] -c \"CREATE EXTENSION postgis_raster;\"" 3100msgstr "" 3101 3102#. Tag: para 3103#: installation.xml:849 3104#, no-c-format 3105msgid "" 3106"Topology is packaged as a separate extension and installable with command:" 3107msgstr "" 3108"Topology esta compilado como una extensión separada y se puede instalar con " 3109"el comando:" 3110 3111#. Tag: command 3112#: installation.xml:854 3113#, no-c-format 3114msgid "psql -d [yourdatabase] -c \"CREATE EXTENSION postgis_topology;\"" 3115msgstr "psql -d [yourdatabase] -c \"CREATE EXTENSION postgis_topology;\"" 3116 3117#. Tag: para 3118#: installation.xml:857 installation.xml:957 3119#, no-c-format 3120msgid "" 3121"If you plan to restore an old backup from prior versions in this new db, run:" 3122msgstr "" 3123"Si estas pensando en restaurar una copia de seguridad de una vieja base de " 3124"datos desde una versión anterior en la nueva base de datos, ejecuta:" 3125 3126#. Tag: command 3127#: installation.xml:858 installation.xml:958 3128#, no-c-format 3129msgid "psql -d [yourdatabase] -f legacy.sql" 3130msgstr "psql -d [yourdatabase] -f legacy.sql" 3131 3132#. Tag: para 3133#: installation.xml:859 3134#, no-c-format 3135msgid "" 3136"If you need legacy functions, you'll need to reinstall the legacy.sql script " 3137"whenever you upgrade the minor version of PostGIS. E.g. if you upgraded from " 3138"2.4.3 to 2.5.0, then you need to reinstall the legacy.sql packaged with " 3139"2.5.0. This is because some of the functions make reference to the library " 3140"and the library is named with the minor in it." 3141msgstr "" 3142 3143#. Tag: para 3144#: installation.xml:862 installation.xml:962 3145#, no-c-format 3146msgid "" 3147"You can later run <filename>uninstall_legacy.sql</filename> to get rid of " 3148"the deprecated functions after you are done with restoring and cleanup." 3149msgstr "" 3150"Después podrás ejecutar <filename>uninstall_legacy.sql</filename> para " 3151"obtener el rid de las funciones obsoletas después de haber restaurado y " 3152"limpiado." 3153 3154#. Tag: title 3155#: installation.xml:866 3156#, no-c-format 3157msgid "Create a spatially-enabled database without using extensions" 3158msgstr "" 3159 3160#. Tag: para 3161#: installation.xml:868 3162#, no-c-format 3163msgid "" 3164"This is generally only needed if you cannot or don't want to get PostGIS " 3165"installed in the PostgreSQL extension directory (for example during testing, " 3166"development or in a restricted environment)." 3167msgstr "" 3168 3169#. Tag: para 3170#: installation.xml:872 3171#, no-c-format 3172msgid "" 3173"The first step in creating a PostGIS database is to create a simple " 3174"PostgreSQL database." 3175msgstr "" 3176"El primer paso en la creación de una base de datos PostGIS es crear una " 3177"simple base de datos PostgreSQL." 3178 3179#. Tag: para 3180#: installation.xml:880 3181#, no-c-format 3182msgid "" 3183"Many of the PostGIS functions are written in the PL/pgSQL procedural " 3184"language. As such, the next step to create a PostGIS database is to enable " 3185"the PL/pgSQL language in your new database. This is accomplish by the " 3186"command below command. For PostgreSQL 8.4+, this is generally already " 3187"installed" 3188msgstr "" 3189"Varias de la funciones PostGIS están escritas en el lenguaje de " 3190"procedimientos PL/pgSQL. Como tal, el siguiente paso para crear una base de " 3191"datos PostGIS es habilitar el lenguaje PL/pgSQL en nuestra nueva base de " 3192"datos. Eso se hace con el comando siguiente. Para PostgreSQL 8.4+ está " 3193"normalmente ya instalado." 3194 3195#. Tag: command 3196#: installation.xml:888 3197#, no-c-format 3198msgid "createlang plpgsql [yourdatabase]" 3199msgstr "createlang plpgsql [subasededatos]" 3200 3201#. Tag: para 3202#: installation.xml:891 3203#, no-c-format 3204msgid "" 3205"Now load the PostGIS object and function definitions into your database by " 3206"loading the <filename>postgis.sql</filename> definitions file (located in " 3207"<filename>[prefix]/share/contrib</filename> as specified during the " 3208"configuration step)." 3209msgstr "" 3210"Ahora carga los objetos y la definición de funciones en tu base de datos " 3211"cargando el fichero de definiciones <filename>postgis.sql</filename> (este " 3212"fichero se encuentra en <filename>[prefix]/share/contrib</filename> como se " 3213"especificó durante la etapa de configuración)." 3214 3215#. Tag: command 3216#: installation.xml:899 3217#, no-c-format 3218msgid "psql -d [yourdatabase] -f postgis.sql" 3219msgstr "psql -d [yourdatabase] -f postgis.sql" 3220 3221#. Tag: para 3222#: installation.xml:902 3223#, no-c-format 3224msgid "" 3225"For a complete set of EPSG coordinate system definition identifiers, you can " 3226"also load the <filename>spatial_ref_sys.sql</filename> definitions file and " 3227"populate the <varname>spatial_ref_sys</varname> table. This will permit you " 3228"to perform ST_Transform() operations on geometries." 3229msgstr "" 3230"Para tener un juego completo de definiciones de sistemas de coordinas EPSG, " 3231"también se puede cargar el fichero de definiciones <filename>spatial_ref_sys." 3232"sql</filename> y rellenar tabla <varname>spatial_ref_sys</varname>. Esto te " 3233"permitida hacer operaciones de transformación ST_Transform() en las " 3234"geometrías." 3235 3236#. Tag: command 3237#: installation.xml:910 3238#, no-c-format 3239msgid "psql -d [yourdatabase] -f spatial_ref_sys.sql" 3240msgstr "psql -d [yourdatabase] -f spatial_ref_sys.sql" 3241 3242#. Tag: para 3243#: installation.xml:913 3244#, no-c-format 3245msgid "" 3246"If you wish to add comments to the PostGIS functions, the final step is to " 3247"load the <filename>postgis_comments.sql</filename> into your spatial " 3248"database. The comments can be viewed by simply typing <command>\\dd " 3249"[function_name]</command> from a <command>psql</command> terminal window." 3250msgstr "" 3251"Si quieres añadir los comentarios de las funciones PostGIS, el paso final es " 3252"cargar el fichero <filename>postgis_comments.sql</filename> en la base de " 3253"datos. Para ver los comentarios, simplemente ejecuta el comando <command>" 3254"\\dd [function_name]</command> en un terminal psql." 3255 3256#. Tag: command 3257#: installation.xml:921 3258#, no-c-format 3259msgid "psql -d [yourdatabase] -f postgis_comments.sql" 3260msgstr "psql -d [yourdatabase] -f postgis_comments.sql" 3261 3262#. Tag: para 3263#: installation.xml:924 3264#, no-c-format 3265msgid "Install raster support" 3266msgstr "Instalar el soporte raster" 3267 3268#. Tag: command 3269#: installation.xml:929 3270#, no-c-format 3271msgid "psql -d [yourdatabase] -f rtpostgis.sql" 3272msgstr "psql -d [yourdatabase] -f rtpostgis.sql" 3273 3274#. Tag: para 3275#: installation.xml:932 3276#, no-c-format 3277msgid "" 3278"Install raster support comments. This will provide quick help info for each " 3279"raster function using psql or PgAdmin or any other PostgreSQL tool that can " 3280"show function comments" 3281msgstr "" 3282"Instala los comentarios de soporte raster. Esto te dará información de ayuda " 3283"de forma rápida para cada función raster utilizando psql, pgAdmin o " 3284"cualquier otra herramienta PostgreSQL que permita ver los comentarios de las " 3285"funciones." 3286 3287#. Tag: command 3288#: installation.xml:938 3289#, no-c-format 3290msgid "psql -d [yourdatabase] -f raster_comments.sql" 3291msgstr "psql -d [yourdatabase] -f raster_comments.sql" 3292 3293#. Tag: para 3294#: installation.xml:940 3295#, no-c-format 3296msgid "Install topology support" 3297msgstr "Instalar el soporte de topología" 3298 3299#. Tag: command 3300#: installation.xml:945 3301#, no-c-format 3302msgid "psql -d [yourdatabase] -f topology/topology.sql" 3303msgstr "psql -d [yourdatabase] -f topology/topology.sql" 3304 3305#. Tag: para 3306#: installation.xml:948 3307#, no-c-format 3308msgid "" 3309"Install topology support comments. This will provide quick help info for " 3310"each topology function / type using psql or PgAdmin or any other PostgreSQL " 3311"tool that can show function comments" 3312msgstr "" 3313"Instala los comentarios de soporte de topología. Esto te dará información de " 3314"ayuda de forma rápida para cada función red topología utilizando psql, " 3315"pgAdmin o cualquier otra herramienta PostgreSQL que permita ver los " 3316"comentarios de las funciones." 3317 3318#. Tag: command 3319#: installation.xml:954 3320#, no-c-format 3321msgid "psql -d [yourdatabase] -f topology/topology_comments.sql" 3322msgstr "psql -d [yourdatabase] -f topology/topology_comments.sql" 3323 3324#. Tag: para 3325#: installation.xml:959 3326#, no-c-format 3327msgid "" 3328"There is an alternative <filename>legacy_minimal.sql</filename> you can run " 3329"instead which will install barebones needed to recover tables and work with " 3330"apps like MapServer and GeoServer. If you have views that use things like " 3331"distance / length etc, you'll need the full blown <filename>legacy.sql</" 3332"filename>" 3333msgstr "" 3334"Hay una alternativa, se puede ejecutar el fichero <filename>legacy_minimal." 3335"sql</filename> que instalará los elementos necesarios para reemplazar tablas " 3336"y que permitida trabajar con aplicaciones como MapServer y GeoServer. Si " 3337"tienes vistas que utilizan funciones tipo distancia/longitud etc, " 3338"necesitaras ejecutar el fichero <filename>legacy.sql</filename> completo." 3339 3340#. Tag: title 3341#: installation.xml:965 3342#, no-c-format 3343msgid "Installing and Using the address standardizer" 3344msgstr "" 3345 3346#. Tag: para 3347#: installation.xml:966 3348#, no-c-format 3349msgid "" 3350"The <code>address_standardizer</code> extension used to be a separate " 3351"package that required separate download. From PostGIS 2.2 on, it is now " 3352"bundled in. For more information about the address_standardize, what it " 3353"does, and how to configure it for your needs, refer to <xref linkend=" 3354"\"Address_Standardizer\"/>." 3355msgstr "" 3356 3357#. Tag: para 3358#: installation.xml:968 3359#, no-c-format 3360msgid "" 3361"This standardizer can be used in conjunction with the PostGIS packaged tiger " 3362"geocoder extension as a replacement for the <xref linkend=\"Normalize_Address" 3363"\"/> discussed. To use as replacement refer to <xref linkend=" 3364"\"tiger_pagc_address_standardizing\"/>. You can also use it as a building " 3365"block for your own geocoder or use it to standardize your addresses for " 3366"easier compare of addresses." 3367msgstr "" 3368 3369#. Tag: para 3370#: installation.xml:972 3371#, no-c-format 3372msgid "" 3373"The address standardizer relies on PCRE which is usually already installed " 3374"on many Nix systems, but you can download the latest at: <ulink url=\"http://" 3375"www.pcre.org\">http://www.pcre.org</ulink>. If during <xref linkend=" 3376"\"installation_configuration\"/>, PCRE is found, then the address " 3377"standardizer extension will automatically be built. If you have a custom " 3378"pcre install you want to use instead, pass to configure <code>--with-" 3379"pcredir=/path/to/pcre</code> where <filename>/path/to/pcre</filename> is the " 3380"root folder for your pcre include and lib directories." 3381msgstr "" 3382 3383#. Tag: para 3384#: installation.xml:975 3385#, no-c-format 3386msgid "" 3387"For Windows users, the PostGIS 2.1+ bundle is packaged with the " 3388"address_standardizer already so no need to compile and can move straight to " 3389"<code>CREATE EXTENSION</code> step." 3390msgstr "" 3391 3392#. Tag: para 3393#: installation.xml:978 3394#, no-c-format 3395msgid "" 3396"Once you have installed, you can connect to your database and run the SQL:" 3397msgstr "" 3398 3399#. Tag: programlisting 3400#: installation.xml:979 3401#, no-c-format 3402msgid "CREATE EXTENSION address_standardizer;" 3403msgstr "CREATE EXTENSION address_standardizer;" 3404 3405#. Tag: para 3406#: installation.xml:981 3407#, no-c-format 3408msgid "The following test requires no rules, gaz, or lex tables" 3409msgstr "" 3410 3411#. Tag: programlisting 3412#: installation.xml:982 3413#, no-c-format 3414msgid "" 3415"SELECT num, street, city, state, zip\n" 3416" FROM parse_address('1 Devonshire Place PH301, Boston, MA 02109');" 3417msgstr "" 3418 3419#. Tag: para 3420#: installation.xml:983 3421#, no-c-format 3422msgid "Output should be" 3423msgstr "" 3424 3425#. Tag: screen 3426#: installation.xml:984 3427#, no-c-format 3428msgid "" 3429"num | street | city | state | zip\n" 3430"-----+------------------------+--------+-------+-------\n" 3431" 1 | Devonshire Place PH301 | Boston | MA | 02109" 3432msgstr "" 3433 3434#. Tag: title 3435#: installation.xml:986 3436#, no-c-format 3437msgid "Installing Regex::Assemble" 3438msgstr "" 3439 3440#. Tag: para 3441#: installation.xml:987 3442#, no-c-format 3443msgid "" 3444"Perl Regex:Assemble is no longer needed for compiling address_standardizer " 3445"extension since the files it generates are part of the source tree. However " 3446"if you need to edit the <filename>usps-st-city-orig.txt</filename> or " 3447"<filename>usps-st-city-orig.txt usps-st-city-adds.tx</filename>, you need to " 3448"rebuild <filename>parseaddress-stcities.h</filename> which does require " 3449"Regex:Assemble." 3450msgstr "" 3451 3452#. Tag: programlisting 3453#: installation.xml:988 3454#, no-c-format 3455msgid "cpan Regexp::Assemble" 3456msgstr "" 3457 3458#. Tag: para 3459#: installation.xml:989 3460#, no-c-format 3461msgid "or if you are on Ubuntu / Debian you might need to do" 3462msgstr "" 3463 3464#. Tag: programlisting 3465#: installation.xml:990 3466#, no-c-format 3467msgid "sudo perl -MCPAN -e \"install Regexp::Assemble\"" 3468msgstr "" 3469 3470#. Tag: title 3471#: installation.xml:995 3472#, no-c-format 3473msgid "Installing, Upgrading Tiger Geocoder and loading data" 3474msgstr "Instalar o actualizar el geocodificador Tiger y cargar datos" 3475 3476#. Tag: para 3477#: installation.xml:997 3478#, no-c-format 3479msgid "" 3480"Extras like Tiger geocoder may not be packaged in your PostGIS distribution. " 3481"If you are missing the tiger geocoder extension or want a newer version than " 3482"what your install comes with, then use the <filename>share/extension/" 3483"postgis_tiger_geocoder.*</filename> files from the packages in <ulink url=" 3484"\"http://postgis.net/windows_downloads/\">Windows Unreleased Versions</" 3485"ulink> section for your version of PostgreSQL. Although these packages are " 3486"for windows, the postgis_tiger_geocoder extension files will work on any OS " 3487"since the extension is an SQL/plpgsql only extension." 3488msgstr "" 3489 3490#. Tag: title 3491#: installation.xml:1001 3492#, no-c-format 3493msgid "Tiger Geocoder Enabling your PostGIS database: Using Extension" 3494msgstr "" 3495 3496#. Tag: para 3497#: installation.xml:1002 3498#, no-c-format 3499msgid "" 3500"If you are using PostgreSQL 9.1+ and PostGIS 2.1+, you can take advantage of " 3501"the new extension model for installing tiger geocoder. To do so:" 3502msgstr "" 3503 3504#. Tag: para 3505#: installation.xml:1004 3506#, no-c-format 3507msgid "" 3508"First get binaries for PostGIS 2.1+ or compile and install as usual. This " 3509"should install the necessary extension files as well for tiger geocoder." 3510msgstr "" 3511 3512#. Tag: para 3513#: installation.xml:1005 3514#, no-c-format 3515msgid "" 3516"Connect to your database via psql or pgAdmin or some other tool and run the " 3517"following SQL commands. Note that if you are installing in a database that " 3518"already has postgis, you don't need to do the first step. If you have " 3519"<varname>fuzzystrmatch</varname> extension already installed, you don't need " 3520"to do the second step either." 3521msgstr "" 3522 3523#. Tag: programlisting 3524#: installation.xml:1006 3525#, no-c-format 3526msgid "" 3527"CREATE EXTENSION postgis;\n" 3528"CREATE EXTENSION fuzzystrmatch;\n" 3529"CREATE EXTENSION postgis_tiger_geocoder;\n" 3530"--this one is optional if you want to use the rules based standardizer " 3531"(pagc_normalize_address)\n" 3532"CREATE EXTENSION address_standardizer;" 3533msgstr "" 3534 3535#. Tag: para 3536#: installation.xml:1008 3537#, no-c-format 3538msgid "" 3539"If you already have postgis_tiger_geocoder extension installed, and just " 3540"want to update to the latest run:" 3541msgstr "" 3542 3543#. Tag: programlisting 3544#: installation.xml:1009 3545#, no-c-format 3546msgid "" 3547"ALTER EXTENSION postgis UPDATE;\n" 3548"ALTER EXTENSION postgis_tiger_geocoder UPDATE;" 3549msgstr "" 3550"ALTER EXTENSION postgis UPDATE;\n" 3551"ALTER EXTENSION postgis_tiger_geocoder UPDATE;" 3552 3553#. Tag: para 3554#: installation.xml:1010 3555#, no-c-format 3556msgid "" 3557"If you made custom entries or changes to <varname>tiger.loader_platform</" 3558"varname> and <varname>tiger.loader_variables</varname> you may need to " 3559"update these." 3560msgstr "" 3561 3562#. Tag: para 3563#: installation.xml:1012 3564#, no-c-format 3565msgid "" 3566"To confirm your install is working correctly, run this sql in your database:" 3567msgstr "" 3568 3569#. Tag: programlisting 3570#: installation.xml:1013 3571#, no-c-format 3572msgid "" 3573"SELECT na.address, na.streetname,na.streettypeabbrev, na.zip\n" 3574" FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na;" 3575msgstr "" 3576"SELECT na.address, na.streetname,na.streettypeabbrev, na.zip\n" 3577" FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na;" 3578 3579#. Tag: para 3580#: installation.xml:1014 3581#, no-c-format 3582msgid "Which should output" 3583msgstr "" 3584 3585#. Tag: screen 3586#: installation.xml:1015 3587#, no-c-format 3588msgid "" 3589"address | streetname | streettypeabbrev | zip\n" 3590"---------+------------+------------------+-------\n" 3591" 1 | Devonshire | Pl | 02109" 3592msgstr "" 3593 3594#. Tag: para 3595#: installation.xml:1017 3596#, no-c-format 3597msgid "" 3598"Create a new record in <varname>tiger.loader_platform</varname> table with " 3599"the paths of your executables and server." 3600msgstr "" 3601 3602#. Tag: para 3603#: installation.xml:1018 3604#, no-c-format 3605msgid "" 3606"So for example to create a profile called debbie that follows <code>sh</" 3607"code> convention. You would do:" 3608msgstr "" 3609 3610#. Tag: programlisting 3611#: installation.xml:1019 3612#, no-c-format 3613msgid "" 3614"INSERT INTO tiger.loader_platform(os, declare_sect, pgbin, wget, " 3615"unzip_command, psql, path_sep,\n" 3616" loader, environ_set_command, county_process_command)\n" 3617"SELECT 'debbie', declare_sect, pgbin, wget, unzip_command, psql, path_sep,\n" 3618" loader, environ_set_command, county_process_command\n" 3619" FROM tiger.loader_platform\n" 3620" WHERE os = 'sh';" 3621msgstr "" 3622 3623#. Tag: para 3624#: installation.xml:1020 3625#, no-c-format 3626msgid "" 3627"And then edit the paths in the <emphasis>declare_sect</emphasis> column to " 3628"those that fit Debbie's pg, unzip,shp2pgsql, psql, etc path locations." 3629msgstr "" 3630 3631#. Tag: para 3632#: installation.xml:1022 3633#, no-c-format 3634msgid "" 3635"If you don't edit this <varname>loader_platform</varname> table, it will " 3636"just contain common case locations of items and you'll have to edit the " 3637"generated script after the script is generated." 3638msgstr "" 3639 3640#. Tag: para 3641#: installation.xml:1024 3642#, no-c-format 3643msgid "" 3644"As of PostGIS 2.4.1 the Zip code-5 digit tabulation area <varname>zcta5</" 3645"varname> load step was revised to load current zcta5 data and is part of the " 3646"<xref linkend=\"Loader_Generate_Nation_Script\"/> when enabled. It is turned " 3647"off by default because it takes quite a bit of time to load (20 to 60 " 3648"minutes), takes up quite a bit of disk space, and is not used that often." 3649msgstr "" 3650 3651#. Tag: para 3652#: installation.xml:1026 3653#, no-c-format 3654msgid "To enable it, do the following:" 3655msgstr "" 3656 3657#. Tag: programlisting 3658#: installation.xml:1027 3659#, no-c-format 3660msgid "" 3661"UPDATE tiger.loader_lookuptables SET load = true WHERE table_name = " 3662"'zcta510';" 3663msgstr "" 3664 3665#. Tag: para 3666#: installation.xml:1028 3667#, no-c-format 3668msgid "" 3669"If present the <xref linkend=\"Geocode\"/> function can use it if a boundary " 3670"filter is added to limit to just zips in that boundary. The <xref linkend=" 3671"\"Reverse_Geocode\"/> function uses it if the returned address is missing a " 3672"zip, which often happens with highway reverse geocoding." 3673msgstr "" 3674 3675#. Tag: para 3676#: installation.xml:1031 3677#, no-c-format 3678msgid "" 3679"Create a folder called <filename>gisdata</filename> on root of server or " 3680"your local pc if you have a fast network connection to the server. This " 3681"folder is where the tiger files will be downloaded to and processed. If you " 3682"are not happy with having the folder on the root of the server, or simply " 3683"want to change to a different folder for staging, then edit the field " 3684"<varname>staging_fold</varname> in the <varname>tiger.loader_variables</" 3685"varname> table." 3686msgstr "" 3687 3688#. Tag: para 3689#: installation.xml:1033 3690#, no-c-format 3691msgid "" 3692"Create a folder called temp in the <filename>gisdata</filename> folder or " 3693"whereever you designated the <varname>staging_fold</varname> to be. This " 3694"will be the folder where the loader extracts the downloaded tiger data." 3695msgstr "" 3696 3697#. Tag: para 3698#: installation.xml:1035 3699#, no-c-format 3700msgid "" 3701"Then run the <xref linkend=\"Loader_Generate_Nation_Script\"/> SQL function " 3702"make sure to use the name of your custom profile and copy the script to a ." 3703"sh or .bat file. So for example to build the nation load:" 3704msgstr "" 3705 3706#. Tag: programlisting 3707#: installation.xml:1036 3708#, no-c-format 3709msgid "" 3710"psql -c \"SELECT Loader_Generate_Nation_Script('debbie')\" -d geocoder -tA " 3711"> /gisdata/nation_script_load.sh" 3712msgstr "" 3713"psql -c \"SELECT Loader_Generate_Nation_Script('debbie')\" -d geocoder -tA " 3714"> /gisdata/nation_script_load.sh" 3715 3716#. Tag: para 3717#: installation.xml:1039 3718#, no-c-format 3719msgid "Run the generated nation load commandline scripts." 3720msgstr "" 3721 3722#. Tag: programlisting 3723#: installation.xml:1040 3724#, no-c-format 3725msgid "" 3726"cd /gisdata\n" 3727"sh nation_script_load.sh" 3728msgstr "" 3729"cd /gisdata\n" 3730"sh nation_script_load.sh" 3731 3732#. Tag: para 3733#: installation.xml:1043 3734#, no-c-format 3735msgid "" 3736"After you are done running the nation script, you should have three tables " 3737"in your <code>tiger_data</code> schema and they should be filled with data. " 3738"Confirm you do by doing the following queries from psql or pgAdmin" 3739msgstr "" 3740 3741#. Tag: programlisting 3742#: installation.xml:1044 3743#, no-c-format 3744msgid "SELECT count(*) FROM tiger_data.county_all;" 3745msgstr "SELECT count(*) FROM tiger_data.county_all;" 3746 3747#. Tag: screen 3748#: installation.xml:1045 3749#, no-c-format 3750msgid "" 3751"count\n" 3752"-------\n" 3753" 3233\n" 3754"(1 row)" 3755msgstr "" 3756"count\n" 3757"-------\n" 3758" 3233\n" 3759"(1 row)" 3760 3761#. Tag: programlisting 3762#: installation.xml:1046 3763#, no-c-format 3764msgid "SELECT count(*) FROM tiger_data.state_all;" 3765msgstr "SELECT count(*) FROM tiger_data.state_all;" 3766 3767#. Tag: screen 3768#: installation.xml:1047 3769#, no-c-format 3770msgid "" 3771"count\n" 3772"-------\n" 3773" 56\n" 3774"(1 row)" 3775msgstr "" 3776"count\n" 3777"-------\n" 3778" 56\n" 3779"(1 row)" 3780 3781#. Tag: para 3782#: installation.xml:1050 3783#, no-c-format 3784msgid "" 3785"By default the tables corresponding to <varname>bg</varname>, " 3786"<varname>tract</varname>, <varname>tabblock</varname> are not loaded. These " 3787"tables are not used by the geocoder but are used by folks for population " 3788"statistics. If you wish to load them as part of your state loads, run the " 3789"following statement to enable them." 3790msgstr "" 3791 3792#. Tag: programlisting 3793#: installation.xml:1052 3794#, no-c-format 3795msgid "" 3796"UPDATE tiger.loader_lookuptables SET load = true WHERE load = false AND " 3797"lookup_name IN('tract', 'bg', 'tabblock');" 3798msgstr "" 3799 3800#. Tag: para 3801#: installation.xml:1053 3802#, no-c-format 3803msgid "" 3804"Alternatively you can load just these tables after loading state data using " 3805"the <xref linkend=\"Loader_Generate_Census_Script\"/>" 3806msgstr "" 3807 3808#. Tag: para 3809#: installation.xml:1055 3810#, no-c-format 3811msgid "" 3812"For each state you want to load data for, generate a state script <xref " 3813"linkend=\"Loader_Generate_Script\"/>." 3814msgstr "" 3815 3816#. Tag: para 3817#: installation.xml:1055 3818#, no-c-format 3819msgid "" 3820"DO NOT Generate the state script until you have already loaded the nation " 3821"data, because the state script utilizes county list loaded by nation script." 3822msgstr "" 3823 3824#. Tag: programlisting 3825#: installation.xml:1057 3826#, no-c-format 3827msgid "" 3828"psql -c \"SELECT Loader_Generate_Script(ARRAY['MA'], 'debbie')\" -d geocoder " 3829"-tA > /gisdata/ma_load.sh" 3830msgstr "" 3831"psql -c \"SELECT Loader_Generate_Script(ARRAY['MA'], 'debbie')\" -d geocoder " 3832"-tA > /gisdata/ma_load.sh" 3833 3834#. Tag: para 3835#: installation.xml:1059 3836#, no-c-format 3837msgid "Run the generated commandline scripts." 3838msgstr "" 3839 3840#. Tag: programlisting 3841#: installation.xml:1060 3842#, no-c-format 3843msgid "" 3844"cd /gisdata\n" 3845"sh ma_load.sh" 3846msgstr "" 3847"cd /gisdata\n" 3848"sh ma_load.sh" 3849 3850#. Tag: para 3851#: installation.xml:1062 3852#, no-c-format 3853msgid "" 3854"After you are done loading all data or at a stopping point, it's a good idea " 3855"to analyze all the tiger tables to update the stats (include inherited stats)" 3856msgstr "" 3857 3858#. Tag: programlisting 3859#: installation.xml:1063 3860#, no-c-format 3861msgid "" 3862"SELECT install_missing_indexes();\n" 3863"vacuum (analyze, verbose) tiger.addr;\n" 3864"vacuum (analyze, verbose) tiger.edges;\n" 3865"vacuum (analyze, verbose) tiger.faces;\n" 3866"vacuum (analyze, verbose) tiger.featnames;\n" 3867"vacuum (analyze, verbose) tiger.place;\n" 3868"vacuum (analyze, verbose) tiger.cousub;\n" 3869"vacuum (analyze, verbose) tiger.county;\n" 3870"vacuum (analyze, verbose) tiger.state;\n" 3871"vacuum (analyze, verbose) tiger.zip_lookup_base;\n" 3872"vacuum (analyze, verbose) tiger.zip_state;\n" 3873"vacuum (analyze, verbose) tiger.zip_state_loc;" 3874msgstr "" 3875 3876#. Tag: title 3877#: installation.xml:1066 3878#, no-c-format 3879msgid "Converting a Tiger Geocoder Regular Install to Extension Model" 3880msgstr "" 3881 3882#. Tag: para 3883#: installation.xml:1067 3884#, no-c-format 3885msgid "" 3886"If you installed the tiger geocoder without using the extension model, you " 3887"can convert to the extension model as follows:" 3888msgstr "" 3889 3890#. Tag: para 3891#: installation.xml:1069 3892#, no-c-format 3893msgid "" 3894"Follow instructions in <xref linkend=\"upgrade_tiger_geocoder\"/> for the " 3895"non-extension model upgrade." 3896msgstr "" 3897 3898#. Tag: para 3899#: installation.xml:1070 3900#, no-c-format 3901msgid "" 3902"Connect to your database with psql or pgAdmin and run the following command:" 3903msgstr "" 3904 3905#. Tag: programlisting 3906#: installation.xml:1071 3907#, no-c-format 3908msgid "CREATE EXTENSION postgis_tiger_geocoder FROM unpackaged;" 3909msgstr "CREATE EXTENSION postgis_tiger_geocoder FROM unpackaged;" 3910 3911#. Tag: title 3912#: installation.xml:1078 3913#, no-c-format 3914msgid "Tiger Geocoder Enabling your PostGIS database: Not Using Extensions" 3915msgstr "" 3916 3917#. Tag: para 3918#: installation.xml:1079 3919#, no-c-format 3920msgid "First install PostGIS using the prior instructions." 3921msgstr "Primero debes instalar PostGIS con las instrucciones anteriores." 3922 3923#. Tag: para 3924#: installation.xml:1083 installation.xml:1143 3925#, no-c-format 3926msgid "" 3927"If you don't have an extras folder, download <ulink url=" 3928"\"&postgis_download_url;\">&postgis_download_url;</ulink>" 3929msgstr "" 3930 3931#. Tag: command 3932#: installation.xml:1088 installation.xml:1148 3933#, no-c-format 3934msgid "tar xvfz postgis-&last_release_version;.tar.gz" 3935msgstr "tar xvfz postgis-&last_release_version;.tar.gz" 3936 3937#. Tag: command 3938#: installation.xml:1092 3939#, no-c-format 3940msgid "cd postgis-&last_release_version;/extras/tiger_geocoder" 3941msgstr "" 3942 3943#. Tag: para 3944#: installation.xml:1095 3945#, no-c-format 3946msgid "" 3947"Edit the <filename>tiger_loader_2015.sql</filename> (or latest loader file " 3948"you find, unless you want to load different year) to the paths of your " 3949"executables server etc or alternatively you can update the " 3950"<varname>loader_platform</varname> table once installed. If you don't edit " 3951"this file or the <varname>loader_platform</varname> table, it will just " 3952"contain common case locations of items and you'll have to edit the generated " 3953"script after the fact when you run the <xref linkend=" 3954"\"Loader_Generate_Nation_Script\"/> and <xref linkend=" 3955"\"Loader_Generate_Script\"/> SQL functions." 3956msgstr "" 3957 3958#. Tag: para 3959#: installation.xml:1097 3960#, no-c-format 3961msgid "" 3962"If you are installing Tiger geocoder for the first time edit either the " 3963"<filename>create_geocode.bat</filename> script If you are on windows or the " 3964"<filename>create_geocode.sh</filename> if you are on Linux/Unix/Mac OSX with " 3965"your PostgreSQL specific settings and run the corresponding script from the " 3966"commandline." 3967msgstr "" 3968 3969#. Tag: para 3970#: installation.xml:1101 3971#, no-c-format 3972msgid "" 3973"Verify that you now have a <varname>tiger</varname> schema in your database " 3974"and that it is part of your database search_path. If it is not, add it with " 3975"a command something along the line of:" 3976msgstr "" 3977"Verifica que ahora tienes el esquema <varname>tiger</varname> en tu base de " 3978"datos y este forma parte de tu variable search_path en la base de datos. Si " 3979"no, añádelo con un comando parecido al siguiente:" 3980 3981#. Tag: programlisting 3982#: installation.xml:1101 3983#, no-c-format 3984msgid "ALTER DATABASE geocoder SET search_path=public, tiger;" 3985msgstr "ALTER DATABASE geocoder SET search_path=public, tiger;" 3986 3987#. Tag: para 3988#: installation.xml:1102 3989#, no-c-format 3990msgid "" 3991"The normalizing address functionality works more or less without any data " 3992"except for tricky addresses. Run this test and verify things look like this:" 3993msgstr "" 3994"La funcionalidad de normalización de direcciones funciona sin datos mas o " 3995"menos, excepto para direcciones complejas. Ejecuta el siguiente test y " 3996"verifica si se parece a esto:" 3997 3998#. Tag: programlisting 3999#: installation.xml:1103 4000#, no-c-format 4001msgid "" 4002"SELECT pprint_addy(normalize_address('202 East Fremont Street, Las Vegas, " 4003"Nevada 89101')) As pretty_address;\n" 4004"pretty_address\n" 4005"---------------------------------------\n" 4006"202 E Fremont St, Las Vegas, NV 89101" 4007msgstr "" 4008"SELECT pprint_addy(normalize_address('202 East Fremont Street, Las Vegas, " 4009"Nevada 89101')) As pretty_address;\n" 4010"pretty_address\n" 4011"---------------------------------------\n" 4012"202 E Fremont St, Las Vegas, NV 89101" 4013 4014#. Tag: title 4015#: installation.xml:1106 4016#, no-c-format 4017msgid "Using Address Standardizer Extension with Tiger geocoder" 4018msgstr "" 4019 4020#. Tag: para 4021#: installation.xml:1107 4022#, no-c-format 4023msgid "" 4024"One of the many complaints of folks is the address normalizer function <xref " 4025"linkend=\"Normalize_Address\"/> function that normalizes an address for " 4026"prepping before geocoding. The normalizer is far from perfect and trying to " 4027"patch its imperfectness takes a vast amount of resources. As such we have " 4028"integrated with another project that has a much better address standardizer " 4029"engine. To use this new address_standardizer, you compile the extension as " 4030"described in <xref linkend=\"installing_pagc_address_standardizer\"/> and " 4031"install as an extension in your database." 4032msgstr "" 4033 4034#. Tag: para 4035#: installation.xml:1110 4036#, no-c-format 4037msgid "" 4038"Once you install this extension in the same database as you have installed " 4039"<code>postgis_tiger_geocoder</code>, then the <xref linkend=" 4040"\"Pagc_Normalize_Address\"/> can be used instead of <xref linkend=" 4041"\"Normalize_Address\"/>. This extension is tiger agnostic, so can be used " 4042"with other data sources such as international addresses. The tiger geocoder " 4043"extension does come packaged with its own custom versions of <xref linkend=" 4044"\"rulestab\"/> ( <code>tiger.pagc_rules</code>) , <xref linkend=\"gaztab\"/> " 4045"(<code>tiger.pagc_gaz</code>), and <xref linkend=\"lextab\"/> (<code>tiger." 4046"pagc_lex</code>). These you can add and update to improve your standardizing " 4047"experience for your own needs." 4048msgstr "" 4049 4050#. Tag: title 4051#: installation.xml:1113 4052#, no-c-format 4053msgid "Loading Tiger Data" 4054msgstr "Cargando datos Tiger" 4055 4056#. Tag: para 4057#: installation.xml:1114 4058#, no-c-format 4059msgid "" 4060"The instructions for loading data are available in a more detailed form in " 4061"the <filename>extras/tiger_geocoder/tiger_2011/README</filename>. This just " 4062"includes the general steps." 4063msgstr "" 4064"Las instrucciones de carga de datos están disponibles de forma mas detallada " 4065"en <filename>extras/tiger_geocoder/tiger_2011/README</filename>. Esto solo " 4066"describe los pasos generales." 4067 4068#. Tag: para 4069#: installation.xml:1115 4070#, no-c-format 4071msgid "" 4072"The load process downloads data from the census website for the respective " 4073"nation files, states requested, extracts the files, and then loads each " 4074"state into its own separate set of state tables. Each state table inherits " 4075"from the tables defined in <varname>tiger</varname> schema so that its " 4076"sufficient to just query those tables to access all the data and drop a set " 4077"of state tables at any time using the <xref linkend=" 4078"\"Drop_State_Tables_Generate_Script\"/> if you need to reload a state or " 4079"just don't need a state anymore." 4080msgstr "" 4081"El proceso de carga, descarga datos desde el sitio web del censo de las " 4082"respectivas naciones de los estados pedidos, extrae los ficheros, y carga " 4083"cada estado en un conjunto separado por estados en su propia tabla. Cada " 4084"tabla de estado hereda el esquema de tablas definido en <varname>tiger</" 4085"varname> así que basta con hacer una consulta a estas tablas para acceder a " 4086"todos los datos de la tabla de estados en cualquier momento utilizando <xref " 4087"linkend=\"Drop_State_Tables_Generate_Script\"/> si necesita volver a cargar " 4088"un estado o si ya no lo necesitas mas." 4089 4090#. Tag: para 4091#: installation.xml:1117 4092#, no-c-format 4093msgid "In order to be able to load data you'll need the following tools:" 4094msgstr "Para poder cargar los datos necesitarás las siguientes herramientas:" 4095 4096#. Tag: para 4097#: installation.xml:1119 4098#, no-c-format 4099msgid "A tool to unzip the zip files from census website." 4100msgstr "" 4101"Una herramienta para descomprimir ficheros zip de la pagina web del censo." 4102 4103#. Tag: para 4104#: installation.xml:1120 4105#, no-c-format 4106msgid "" 4107"For Unix like systems: <varname>unzip</varname> executable which is usually " 4108"already installed on most Unix like platforms." 4109msgstr "" 4110"Para sistemas Unix: el ejecutable <varname>unzip</varname> que normalmente " 4111"esta instalado en la mayoría de sistemas Unix." 4112 4113#. Tag: para 4114#: installation.xml:1121 4115#, no-c-format 4116msgid "" 4117"For Windows, 7-zip which is a free compress/uncompress tool you can download " 4118"from <ulink url=\"http://www.7-zip.org/\">http://www.7-zip.org/</ulink>" 4119msgstr "" 4120"Para windows, 7-zip es una herramienta libre de compresión/descompresión que " 4121"puedes descargar en <ulink url=\"http://www.7-zip.org/\">http://www.7-zip." 4122"org/</ulink>" 4123 4124#. Tag: para 4125#: installation.xml:1123 4126#, no-c-format 4127msgid "" 4128"<filename>shp2pgsql</filename> commandline which is installed by default " 4129"when you install PostGIS." 4130msgstr "" 4131"El comando <filename>shp2pgsql</filename> que se instala por defecto cuando " 4132"instalas PostGIS." 4133 4134#. Tag: para 4135#: installation.xml:1124 4136#, no-c-format 4137msgid "" 4138"<filename>wget</filename> which is a web grabber tool usually installed on " 4139"most Unix/Linux systems." 4140msgstr "" 4141"<filename>wget</filename> que es una herramienta de captura web, normalmente " 4142"instalado en los sistemas Unix/Linux." 4143 4144#. Tag: para 4145#: installation.xml:1125 4146#, no-c-format 4147msgid "" 4148"If you are on windows, you can get pre-compiled binaries from <ulink url=" 4149"\"http://gnuwin32.sourceforge.net/packages/wget.htm\">http://gnuwin32." 4150"sourceforge.net/packages/wget.htm</ulink>" 4151msgstr "" 4152"Si estas en windows, puedes obtener ejecutables precompilados en <ulink url=" 4153"\"http://gnuwin32.sourceforge.net/packages/wget.htm\">http://gnuwin32." 4154"sourceforge.net/packages/wget.htm</ulink>" 4155 4156#. Tag: para 4157#: installation.xml:1128 4158#, no-c-format 4159msgid "" 4160"If you are upgrading from tiger_2010, you'll need to first generate and run " 4161"<xref linkend=\"Drop_Nation_Tables_Generate_Script\"/>. Before you load any " 4162"state data, you need to load the nation wide data which you do with <xref " 4163"linkend=\"Loader_Generate_Nation_Script\"/>. Which will generate a loader " 4164"script for you. <xref linkend=\"Loader_Generate_Nation_Script\"/> is a one-" 4165"time step that should be done for upgrading (from 2010) and for new installs." 4166msgstr "" 4167 4168#. Tag: para 4169#: installation.xml:1130 4170#, no-c-format 4171msgid "" 4172"To load state data refer to <xref linkend=\"Loader_Generate_Script\"/> to " 4173"generate a data load script for your platform for the states you desire. " 4174"Note that you can install these piecemeal. You don't have to load all the " 4175"states you want all at once. You can load them as you need them." 4176msgstr "" 4177 4178#. Tag: para 4179#: installation.xml:1133 4180#, no-c-format 4181msgid "" 4182"After the states you desire have been loaded, make sure to run the: " 4183"<programlisting>SELECT install_missing_indexes();</programlisting> as " 4184"described in <xref linkend=\"Install_Missing_Indexes\"/>." 4185msgstr "" 4186"Una vez que los estados que quieres han sido cargados, asegurare de " 4187"ejecutar: <programlisting>SELECT install_missing_indexes();</" 4188"programlisting> como se explica en <xref linkend=\"Install_Missing_Indexes\"/" 4189">." 4190 4191#. Tag: para 4192#: installation.xml:1135 4193#, no-c-format 4194msgid "" 4195"To test that things are working as they should, try to run a geocode on an " 4196"address in your state using <xref linkend=\"Geocode\"/>" 4197msgstr "" 4198"Para probar que las cosas han funcionado como deberían, intenta ejecutar una " 4199"geocodificacion en una dirección del estado descargado utilizando <xref " 4200"linkend=\"Geocode\"/>" 4201 4202#. Tag: title 4203#: installation.xml:1138 4204#, no-c-format 4205msgid "Upgrading your Tiger Geocoder Install" 4206msgstr "Actualizando la instalación del geocodificador Tiger" 4207 4208#. Tag: para 4209#: installation.xml:1139 4210#, no-c-format 4211msgid "" 4212"If you have Tiger Geocoder packaged with 2.0+ already installed, you can " 4213"upgrade the functions at any time even from an interim tar ball if there are " 4214"fixes you badly need. This will only work for Tiger geocoder not installed " 4215"with extensions." 4216msgstr "" 4217 4218#. Tag: command 4219#: installation.xml:1152 4220#, no-c-format 4221msgid "cd postgis-&last_release_version;/extras/tiger_geocoder/tiger_2011" 4222msgstr "cd postgis-&last_release_version;/extras/tiger_geocoder/tiger_2011" 4223 4224#. Tag: para 4225#: installation.xml:1155 4226#, no-c-format 4227msgid "" 4228"Locate the <filename>upgrade_geocoder.bat</filename> script If you are on " 4229"windows or the <filename>upgrade_geocoder.sh</filename> if you are on Linux/" 4230"Unix/Mac OSX. Edit the file to have your postgis database credentials." 4231msgstr "" 4232 4233#. Tag: para 4234#: installation.xml:1158 4235#, no-c-format 4236msgid "" 4237"If you are upgrading from 2010 or 2011, make sure to unremark out the loader " 4238"script line so you get the latest script for loading 2012 data." 4239msgstr "" 4240 4241#. Tag: para 4242#: installation.xml:1159 4243#, no-c-format 4244msgid "Then run th corresponding script from the commandline." 4245msgstr "" 4246 4247#. Tag: para 4248#: installation.xml:1163 4249#, no-c-format 4250msgid "" 4251"Next drop all nation tables and load up the new ones. Generate a drop script " 4252"with this SQL statement as detailed in <xref linkend=" 4253"\"Drop_Nation_Tables_Generate_Script\"/>" 4254msgstr "" 4255"Después, elimina todas las tabals de naciones y carga las nuevas. Genera un " 4256"script drop con esta sentencia SQL como se detalla en <xref linkend=" 4257"\"Drop_Nation_Tables_Generate_Script\"/>" 4258 4259#. Tag: programlisting 4260#: installation.xml:1164 4261#, no-c-format 4262msgid "SELECT drop_nation_tables_generate_script();" 4263msgstr "SELECT drop_nation_tables_generate_script();" 4264 4265#. Tag: para 4266#: installation.xml:1165 4267#, no-c-format 4268msgid "Run the generated drop SQL statements." 4269msgstr "Ejecuta la sentencia SQL drop" 4270 4271#. Tag: para 4272#: installation.xml:1166 4273#, no-c-format 4274msgid "" 4275"Generate a nation load script with this SELECT statement as detailed in " 4276"<xref linkend=\"Loader_Generate_Nation_Script\"/>" 4277msgstr "" 4278"Genera un script de carga de naciones con esta sentencia SELECT como se " 4279"detalla en <xref linkend=\"Loader_Generate_Nation_Script\"/>" 4280 4281#. Tag: emphasis 4282#: installation.xml:1167 4283#, no-c-format 4284msgid "For windows" 4285msgstr "Para windows" 4286 4287#. Tag: programlisting 4288#: installation.xml:1168 4289#, no-c-format 4290msgid "SELECT loader_generate_nation_script('windows');" 4291msgstr "SELECT loader_generate_nation_script('windows');" 4292 4293#. Tag: emphasis 4294#: installation.xml:1169 4295#, no-c-format 4296msgid "For unix/linux" 4297msgstr "Para unix/linux" 4298 4299#. Tag: programlisting 4300#: installation.xml:1170 4301#, no-c-format 4302msgid "SELECT loader_generate_nation_script('sh');" 4303msgstr "SELECT loader_generate_nation_script('sh');" 4304 4305#. Tag: para 4306#: installation.xml:1171 4307#, no-c-format 4308msgid "" 4309"Refer to <xref linkend=\"tiger_geocoder_loading_data\"/> for instructions on " 4310"how to run the generate script. This only needs to be done once." 4311msgstr "" 4312"Para mas información sobre como ejecutar los scripts generados visita <xref " 4313"linkend=\"tiger_geocoder_loading_data\"/>. Esto solo es necesario hacerlo " 4314"una vez." 4315 4316#. Tag: para 4317#: installation.xml:1172 4318#, no-c-format 4319msgid "" 4320"You can have a mix of 2010/2011 state tables and can upgrade each state " 4321"separately. Before you upgrade a state to 2011, you first need to drop the " 4322"2010 tables for that state using <xref linkend=" 4323"\"Drop_State_Tables_Generate_Script\"/>." 4324msgstr "" 4325"Puedes tener una mezcla de tablas de estados de 2010/2011 y puedes " 4326"actualizar cada estado por separado. Antes de actualizar un estado a la " 4327"versión de 2011 debes suprimir las tablas de este estado para 2010 " 4328"utilizando <xref linkend=\"Drop_State_Tables_Generate_Script\"/>." 4329 4330#. Tag: title 4331#: installation.xml:1178 4332#, no-c-format 4333msgid "Create a spatially-enabled database from a template" 4334msgstr "Crear una base de datos espacial desde una plantilla" 4335 4336#. Tag: para 4337#: installation.xml:1180 4338#, no-c-format 4339msgid "" 4340"Some packaged distributions of PostGIS (in particular the Win32 installers " 4341"for PostGIS >= 1.1.5) load the PostGIS functions into a template database " 4342"called <varname>template_postgis</varname>. If the " 4343"<varname>template_postgis</varname> database exists in your PostgreSQL " 4344"installation then it is possible for users and/or applications to create " 4345"spatially-enabled databases using a single command. Note that in both cases, " 4346"the database user must have been granted the privilege to create new " 4347"databases." 4348msgstr "" 4349"Algunas de las distribuciones precompiladas de PostGIS (en particular los " 4350"instaladores de Postgis >= 1.1.5 para sistemas Win32) carga las funciones " 4351"de PostGIS en una base de datos plantilla llamada <varname>template_postgis</" 4352"varname>. Si la base de datos <varname>template_postgis</varname> existe ya " 4353"en nuestra instalación de PostgreSQL, los usuarios y aplicaciones podrán " 4354"crear bases de datos espaciales con un simple comando. En ambos casos, el " 4355"usuario de la base de datos debe tener privilegios para crear nuevas bases " 4356"de datos" 4357 4358#. Tag: para 4359#: installation.xml:1191 4360#, no-c-format 4361msgid "From the shell:" 4362msgstr "En la linea de comandos:" 4363 4364#. Tag: programlisting 4365#: installation.xml:1195 4366#, no-c-format 4367msgid "# createdb -T template_postgis my_spatial_db" 4368msgstr "# createdb -T template_postgis my_spatial_db" 4369 4370#. Tag: para 4371#: installation.xml:1197 4372#, no-c-format 4373msgid "From SQL:" 4374msgstr "Desde SQL:" 4375 4376#. Tag: programlisting 4377#: installation.xml:1201 4378#, no-c-format 4379msgid "postgres=# CREATE DATABASE my_spatial_db TEMPLATE=template_postgis" 4380msgstr "postgres=# CREATE DATABASE my_spatial_db TEMPLATE=template_postgis" 4381 4382#. Tag: title 4383#: installation.xml:1205 4384#, no-c-format 4385msgid "Upgrading" 4386msgstr "Actualizando" 4387 4388#. Tag: para 4389#: installation.xml:1207 4390#, no-c-format 4391msgid "" 4392"Upgrading existing spatial databases can be tricky as it requires " 4393"replacement or introduction of new PostGIS object definitions." 4394msgstr "" 4395"Actualizar una base de datos espacial puede ser complejo ya que requiere " 4396"reemplazar o introducir nuevas definiciones de objetos PostGIS." 4397 4398#. Tag: para 4399#: installation.xml:1212 4400#, no-c-format 4401msgid "" 4402"Unfortunately not all definitions can be easily replaced in a live database, " 4403"so sometimes your best bet is a dump/reload process." 4404msgstr "" 4405"Desafortunadamente, no todas las definiciones pueden reemplazarse fácilmente " 4406"en una base de datos activa, así que algunas veces lo mejor es un proceso " 4407"copia de seguridad/recarga." 4408 4409#. Tag: para 4410#: installation.xml:1217 4411#, no-c-format 4412msgid "" 4413"PostGIS provides a SOFT UPGRADE procedure for minor or bugfix releases, and " 4414"a HARD UPGRADE procedure for major releases." 4415msgstr "" 4416"PostGIS incluye una SOFT UPGRADE (actualización ligera) para " 4417"actualizaciones menores o corrección de errores, y una HARD UPGRADE " 4418"(Actualización pesada) para versiones mayores." 4419 4420#. Tag: para 4421#: installation.xml:1222 4422#, no-c-format 4423msgid "" 4424"Before attempting to upgrade PostGIS, it is always worth to backup your " 4425"data. If you use the -Fc flag to pg_dump you will always be able to restore " 4426"the dump with a HARD UPGRADE." 4427msgstr "" 4428"Antes de realizar una actualización de PostGIS, es recomendable hacer una " 4429"copia de seguridad de los datos. Si utilizas la opción -Fc en el comando " 4430"pg_dump siempre podrás restaurar la copia realizada con un HARD UPDATE." 4431 4432#. Tag: title 4433#: installation.xml:1229 4434#, no-c-format 4435msgid "Soft upgrade" 4436msgstr "Actualizacion Ligera" 4437 4438#. Tag: para 4439#: installation.xml:1231 4440#, no-c-format 4441msgid "" 4442"If you installed your database using extensions, you'll need to upgrade " 4443"using the extension model as well. If you installed using the old sql script " 4444"way, then you should upgrade using the sql script way. Please refer to the " 4445"appropriate." 4446msgstr "" 4447"Si instalaste la base de datos utilizando extensiones, necesitaras " 4448"actualizar utilizando el modelo de extensiones tambien. Si instalaste " 4449"utilizando el antiguo metodo de script sql, necesitaras actualizar el metodo " 4450"de script sql. Consulta el metodo adecuado." 4451 4452#. Tag: title 4453#: installation.xml:1235 4454#, no-c-format 4455msgid "Soft Upgrade Pre 9.1+ or without extensions" 4456msgstr "" 4457"Actualización ligera anterior a la versión PostgreSQL 9.1+ o sin extensiones" 4458 4459#. Tag: para 4460#: installation.xml:1237 4461#, no-c-format 4462msgid "" 4463"This section applies only to those who installed PostGIS not using " 4464"extensions. If you have extensions and try to upgrade with this approach " 4465"you'll get messages like:" 4466msgstr "" 4467"Esta sección describe el método para quienes instalaron PostGIS sin utilizar " 4468"extensiones solamente. Si tienes extensiones e intentas actualizar con este " 4469"metodo, tendras mensajes como los siguientes:" 4470 4471#. Tag: programlisting 4472#: installation.xml:1241 4473#, no-c-format 4474msgid "can't drop ... because postgis extension depends on it" 4475msgstr "no se puede suprimir ... porque la extensión postgis depende de el" 4476 4477#. Tag: para 4478#: installation.xml:1243 4479#, no-c-format 4480msgid "" 4481"NOTE: if you are moving from PostGIS 1.* to PostGIS 2.* or from PostGIS 2.* " 4482"prior to r7409, you cannot use this procedure but would rather need to do a " 4483"<link linkend=\"hard_upgrade\">HARD UPGRADE</link>." 4484msgstr "" 4485 4486#. Tag: para 4487#: installation.xml:1250 4488#, no-c-format 4489msgid "" 4490"After compiling and installing (make install) you should find a set of " 4491"<filename>*_upgrade.sql</filename> files in the installation folders. You " 4492"can list them all with:" 4493msgstr "" 4494 4495#. Tag: programlisting 4496#: installation.xml:1257 4497#, no-c-format 4498msgid "" 4499"ls `pg_config --sharedir`/contrib/postgis-&last_release_version;/*_upgrade." 4500"sql" 4501msgstr "" 4502 4503#. Tag: para 4504#: installation.xml:1259 4505#, no-c-format 4506msgid "" 4507"Load them all in turn, starting from <filename>postgis_upgrade.sql</" 4508"filename>." 4509msgstr "" 4510 4511#. Tag: programlisting 4512#: installation.xml:1263 4513#, no-c-format 4514msgid "psql -f postgis_upgrade.sql -d your_spatial_database" 4515msgstr "psql -f postgis_upgrade.sql -d your_spatial_database" 4516 4517#. Tag: para 4518#: installation.xml:1265 4519#, no-c-format 4520msgid "" 4521"The same procedure applies to raster, topology and sfcgal extensions, with " 4522"upgrade files named <filename>rtpostgis_upgrade.sql</filename>, " 4523"<filename>topology_upgrade.sql</filename> and <filename>sfcgal_upgrade.sql</" 4524"filename> respectively. If you need them:" 4525msgstr "" 4526 4527#. Tag: programlisting 4528#: installation.xml:1274 4529#, no-c-format 4530msgid "psql -f rtpostgis_upgrade.sql -d your_spatial_database" 4531msgstr "psql -f rtpostgis_upgrade.sql -d your_spatial_database" 4532 4533#. Tag: programlisting 4534#: installation.xml:1275 4535#, no-c-format 4536msgid "psql -f topology_upgrade.sql -d your_spatial_database" 4537msgstr "psql -f topology_upgrade.sql -d your_spatial_database" 4538 4539#. Tag: programlisting 4540#: installation.xml:1276 4541#, no-c-format 4542msgid "psql -f sfcgal_upgrade.sql -d your_spatial_database" 4543msgstr "" 4544 4545#. Tag: para 4546#: installation.xml:1279 4547#, no-c-format 4548msgid "" 4549"If you can't find the <filename>postgis_upgrade.sql</filename> specific for " 4550"upgrading your version you are using a version too early for a soft upgrade " 4551"and need to do a <link linkend=\"hard_upgrade\">HARD UPGRADE</link>." 4552msgstr "" 4553 4554#. Tag: para 4555#: installation.xml:1288 4556#, no-c-format 4557msgid "" 4558"The <xref linkend=\"PostGIS_Full_Version\"/> function should inform you " 4559"about the need to run this kind of upgrade using a \"procs need upgrade\" " 4560"message." 4561msgstr "" 4562"La función <xref linkend=\"PostGIS_Full_Version\"/> debe darte la " 4563"información sobre la necesidad de ejecutar este tipo de actualización " 4564"utilizando el mensaje \"procs need upgrade\"." 4565 4566#. Tag: title 4567#: installation.xml:1295 4568#, no-c-format 4569msgid "Soft Upgrade 9.1+ using extensions" 4570msgstr "Actualizacion ligera 9.1+ utilizando extensiones" 4571 4572#. Tag: para 4573#: installation.xml:1296 4574#, no-c-format 4575msgid "" 4576"If you originally installed PostGIS with extensions, then you need to " 4577"upgrade using extensions as well. Doing a minor upgrade with extensions, is " 4578"fairly painless." 4579msgstr "" 4580"Si has instalado originalmente PostGIS con extensiones, entonces necesitas " 4581"actualizar utilizando extensiones también. Hacer una actualización menor con " 4582"extensiones es bastante sencillo." 4583 4584#. Tag: programlisting 4585#: installation.xml:1297 4586#, no-c-format 4587msgid "" 4588"ALTER EXTENSION postgis UPDATE TO \"&last_release_version;\";\n" 4589"ALTER EXTENSION postgis_topology UPDATE TO \"&last_release_version;\";" 4590msgstr "" 4591"ALTER EXTENSION postgis UPDATE TO \"&last_release_version;\";\n" 4592"ALTER EXTENSION postgis_topology UPDATE TO \"&last_release_version;\";" 4593 4594#. Tag: para 4595#: installation.xml:1298 4596#, no-c-format 4597msgid "If you get an error notice something like:" 4598msgstr "Si obtienes un error parecido a:" 4599 4600#. Tag: programlisting 4601#: installation.xml:1299 4602#, no-c-format 4603msgid "No migration path defined for ... to &last_release_version;" 4604msgstr "No migration path defined for ... to &last_release_version;" 4605 4606#. Tag: para 4607#: installation.xml:1300 4608#, no-c-format 4609msgid "" 4610"Then you'll need to backup your database, create a fresh one as described in " 4611"<xref linkend=\"create_new_db_extensions\"/> and then restore your backup " 4612"ontop of this new database." 4613msgstr "" 4614 4615#. Tag: para 4616#: installation.xml:1301 4617#, no-c-format 4618msgid "If you get a notice message like:" 4619msgstr "" 4620 4621#. Tag: programlisting 4622#: installation.xml:1302 4623#, no-c-format 4624msgid "" 4625"Version \"&last_release_version;\" of extension \"postgis\" is already " 4626"installed" 4627msgstr "" 4628 4629#. Tag: para 4630#: installation.xml:1303 4631#, no-c-format 4632msgid "" 4633"Then everything is already up to date and you can safely ignore it. " 4634"<emphasis role=\"bold\">UNLESS</emphasis> you're attempting to upgrade from " 4635"an development version to the next (which doesn't get a new version number); " 4636"in that case you can append \"next\" to the version string, and next time " 4637"you'll need to drop the \"next\" suffix again:" 4638msgstr "" 4639 4640#. Tag: programlisting 4641#: installation.xml:1309 4642#, no-c-format 4643msgid "" 4644"ALTER EXTENSION postgis UPDATE TO \"&last_release_version;next\";\n" 4645"ALTER EXTENSION postgis_topology UPDATE TO \"&last_release_version;next\";" 4646msgstr "" 4647"ALTER EXTENSION postgis UPDATE TO \"&last_release_version;next\";\n" 4648"ALTER EXTENSION postgis_topology UPDATE TO \"&last_release_version;next\";" 4649 4650#. Tag: para 4651#: installation.xml:1310 4652#, no-c-format 4653msgid "" 4654"If you installed PostGIS originally without a version specified, you can " 4655"often skip the reinstallation of postgis extension before restoring since " 4656"the backup just has <code>CREATE EXTENSION postgis</code> and thus picks up " 4657"the newest latest version during restore." 4658msgstr "" 4659 4660#. Tag: para 4661#: installation.xml:1314 4662#, no-c-format 4663msgid "" 4664"If you are upgrading PostGIS extension from a version prior to 3.0.0 you'll " 4665"end up with an unpackaged PostGIS Raster support. You can repackage the " 4666"raster support using: <programlisting>\n" 4667" CREATE EXTENSION postgis_raster FROM unpackaged;\n" 4668" </programlisting> And then, if you don't need it, drop it with:" 4669msgstr "" 4670 4671#. Tag: programlisting 4672#: installation.xml:1320 4673#, no-c-format 4674msgid "DROP EXTENSION postgis_raster;" 4675msgstr "" 4676 4677#. Tag: title 4678#: installation.xml:1329 4679#, no-c-format 4680msgid "Hard upgrade" 4681msgstr "Actualizacion pesada o HARD UPDATE" 4682 4683#. Tag: para 4684#: installation.xml:1331 4685#, no-c-format 4686msgid "" 4687"By HARD UPGRADE we mean full dump/reload of postgis-enabled databases. You " 4688"need a HARD UPGRADE when PostGIS objects' internal storage changes or when " 4689"SOFT UPGRADE is not possible. The <link linkend=\"release_notes\">Release " 4690"Notes</link> appendix reports for each version whether you need a dump/" 4691"reload (HARD UPGRADE) to upgrade." 4692msgstr "" 4693"Por actualización pesada se entiende una copia de seguridad/recarga completa " 4694"de datos en la base de datos espacial. Necesitas una actualización pesada " 4695"cuando los objetos internos de almacenamiento de PostGIS cambian o cuando " 4696"una actualización ligera no es posible. Las notas <link linkend=" 4697"\"release_notes\">Release Notes</link> del apéndice hay informes de cada " 4698"version y de si necesitas hacer una copia de seguridad/recarga de datos " 4699"(HARD UPGRADE) para actualizar." 4700 4701#. Tag: para 4702#: installation.xml:1340 4703#, no-c-format 4704msgid "" 4705"The dump/reload process is assisted by the postgis_restore.pl script which " 4706"takes care of skipping from the dump all definitions which belong to PostGIS " 4707"(including old ones), allowing you to restore your schemas and data into a " 4708"database with PostGIS installed without getting duplicate symbol errors or " 4709"bringing forward deprecated objects." 4710msgstr "" 4711"El proceso copia de seguridad/recarga de datos esta asistido por el script " 4712"postgis_restore.pl te toma en cuenta ignorar en la copia de seguridad todas " 4713"las definiciones que pertenecen a PostGIS (incluyendo las antiguas), " 4714"permitiéndote restaurar tus esquemas y datos en una base de datos con " 4715"PostGIS instalado sin tener que duplicar errores o trayendo objetos " 4716"rechazados." 4717 4718#. Tag: para 4719#: installation.xml:1349 4720#, no-c-format 4721msgid "" 4722"Supplementary instructions for windows users are available at <ulink url=" 4723"\"http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade\">Windows Hard " 4724"upgrade</ulink>." 4725msgstr "" 4726"Instruciones complementarias para windows están disponibles en <ulink url=" 4727"\"http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade\">Windows Hard " 4728"upgrade</ulink>." 4729 4730#. Tag: para 4731#: installation.xml:1352 4732#, no-c-format 4733msgid "The Procedure is as follows:" 4734msgstr "El procedimiento es como sigue:" 4735 4736#. Tag: para 4737#: installation.xml:1360 4738#, no-c-format 4739msgid "" 4740"Create a \"custom-format\" dump of the database you want to upgrade (let's " 4741"call it <varname>olddb</varname>) include binary blobs (-b) and verbose (-v) " 4742"output. The user can be the owner of the db, need not be postgres super " 4743"account." 4744msgstr "" 4745"Crea un \"formato personalizado\" de copia de seguridad de la base de datos " 4746"que asieres actualizar (llamemosla <varname>olddb</varname>) incluye " 4747"binarios bolb (-b) y salida verbose (-v). El usuario puede ser el " 4748"propietario de la base de datos, no necesitas una cuenta de superusuario " 4749"postgres." 4750 4751#. Tag: programlisting 4752#: installation.xml:1368 4753#, no-c-format 4754msgid "" 4755"pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f \"/somepath/olddb." 4756"backup\" olddb" 4757msgstr "" 4758"pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f \"/somepath/olddb." 4759"backup\" olddb" 4760 4761#. Tag: para 4762#: installation.xml:1374 4763#, no-c-format 4764msgid "" 4765"Do a fresh install of PostGIS in a new database -- we'll refer to this " 4766"database as <varname>newdb</varname>. Please refer to <xref linkend=" 4767"\"create_new_db\"/> and <xref linkend=\"create_new_db_extensions\"/> for " 4768"instructions on how to do this." 4769msgstr "" 4770"Haz una nueva instalación de PsotGIS en una nueva base de datos --la " 4771"llamaremos <varname>newdb</varname> en este ejemplo. Puedes obtener " 4772"información de como hacer esto en <xref linkend=\"create_new_db\"/> y <xref " 4773"linkend=\"create_new_db_extensions\"/>" 4774 4775#. Tag: para 4776#: installation.xml:1381 4777#, no-c-format 4778msgid "" 4779"The spatial_ref_sys entries found in your dump will be restored, but they " 4780"will not override existing ones in spatial_ref_sys. This is to ensure that " 4781"fixes in the official set will be properly propagated to restored databases. " 4782"If for any reason you really want your own overrides of standard entries " 4783"just don't load the spatial_ref_sys.sql file when creating the new db." 4784msgstr "" 4785"Las entradas que se encuentren en tu copia de seguridad de la tabla " 4786"spatial_ref_sys serán restauradas, pero pero no reescribiran las existentes " 4787"en la nueva tabla spatial_ref_sys. Esto es para asegurar que las soluciones " 4788"en el conjunto oficial se propagarán correctamente para las bases de datos " 4789"restauradas. Si por algún motivo, realmente quieres que tus entradas " 4790"reemplacen las entradas estándar simplemente no cargues el archivo " 4791"spatial_ref_sys.sql al crear la nueva db. " 4792 4793#. Tag: para 4794#: installation.xml:1391 4795#, no-c-format 4796msgid "" 4797"If your database is really old or you know you've been using long deprecated " 4798"functions in your views and functions, you might need to load " 4799"<filename>legacy.sql</filename> for all your functions and views etc. to " 4800"properly come back. Only do this if _really_ needed. Consider upgrading your " 4801"views and functions before dumping instead, if possible. The deprecated " 4802"functions can be later removed by loading <filename>uninstall_legacy.sql</" 4803"filename>." 4804msgstr "" 4805"Si tu base de datos es muy antigua o sabes que has estado utilizando " 4806"funciones rechazadas en tus vistas y funciones, necesitaras cargar el " 4807"fichero <filename>legacy.sql</filename> para todas tus funciones y vistas " 4808"para que funcionen correctamente. Haz esto solamente si es indispensable. " 4809"Considera actualizar tus vistas y funciones antes de hacer una copia de " 4810"seguridad si es posible. Las funciones rechazadas pueden borrarse cargando " 4811"el fichero <filename>uninstall_legacy.sql</filename> después." 4812 4813#. Tag: para 4814#: installation.xml:1407 4815#, no-c-format 4816msgid "" 4817"Restore your backup into your fresh <varname>newdb</varname> database using " 4818"postgis_restore.pl. Unexpected errors, if any, will be printed to the " 4819"standard error stream by psql. Keep a log of those." 4820msgstr "" 4821"Restaura tu copia de seguridad en tu nueva base de datos <varname>newdb</" 4822"varname> utilizando el script postgis_restore.pl. Si aparecen errores " 4823"inesperados, se imprimirán en la consola de psql. Ten un inventario de estos." 4824 4825#. Tag: programlisting 4826#: installation.xml:1415 4827#, no-c-format 4828msgid "" 4829"perl utils/postgis_restore.pl \"/somepath/olddb.backup\" | psql -h localhost " 4830"-p 5432 -U postgres newdb 2> errors.txt" 4831msgstr "" 4832"perl utils/postgis_restore.pl \"/somepath/olddb.backup\" | psql -h localhost " 4833"-p 5432 -U postgres newdb 2> errors.txt" 4834 4835#. Tag: para 4836#: installation.xml:1421 4837#, no-c-format 4838msgid "Errors may arise in the following cases:" 4839msgstr "Los errores se producirán en alguno de estos casos:" 4840 4841#. Tag: para 4842#: installation.xml:1427 4843#, no-c-format 4844msgid "" 4845"Some of your views or functions make use of deprecated PostGIS objects. In " 4846"order to fix this you may try loading <filename>legacy.sql</filename> script " 4847"prior to restore or you'll have to restore to a version of PostGIS which " 4848"still contains those objects and try a migration again after porting your " 4849"code. If the <filename>legacy.sql</filename> way works for you, don't forget " 4850"to fix your code to stop using deprecated functions and drop them loading " 4851"<filename>uninstall_legacy.sql</filename>." 4852msgstr "" 4853"Alguna de tus vistas o funciones hacen uso de funciones rechazadas de " 4854"objetos PostGIS. Para corregir estos deberás intentar cargar el script " 4855"<filename>legacy.sql</filename> antes de restaurar o deberás restaurar a una " 4856"version de PsotGIS que todavía contenga estos objetos e intentar hacer la " 4857"migración otra vez después de migrar tu código. Si el uso del fichero " 4858"<filename>legacy.sql</filename> funciona, no olvides corregir tu código para " 4859"dejar de utilizar funciones rechazadas, y elimina el script <filename>legacy." 4860"sql</filename> ejecutando <filename>uninstall_legacy.sql</filename>." 4861 4862#. Tag: para 4863#: installation.xml:1439 4864#, no-c-format 4865msgid "" 4866"Some custom records of spatial_ref_sys in dump file have an invalid SRID " 4867"value. Valid SRID values are bigger than 0 and smaller than 999000. Values " 4868"in the 999000.999999 range are reserved for internal use while values > " 4869"999999 can't be used at all. All your custom records with invalid SRIDs will " 4870"be retained, with those > 999999 moved into the reserved range, but the " 4871"spatial_ref_sys table would lose a check constraint guarding for that " 4872"invariant to hold and possibly also its primary key ( when multiple invalid " 4873"SRIDS get converted to the same reserved SRID value )." 4874msgstr "" 4875 4876#. Tag: para 4877#: installation.xml:1453 4878#, no-c-format 4879msgid "" 4880"In order to fix this you should copy your custom SRS to a SRID with a valid " 4881"value (maybe in the 910000..910999 range), convert all your tables to the " 4882"new srid (see <xref linkend=\"UpdateGeometrySRID\"/>), delete the invalid " 4883"entry from spatial_ref_sys and re-construct the check(s) with: " 4884"<programlisting>ALTER TABLE spatial_ref_sys ADD CONSTRAINT " 4885"spatial_ref_sys_srid_check check (srid > 0 AND srid < 999000 );</" 4886"programlisting> <programlisting>ALTER TABLE spatial_ref_sys ADD PRIMARY " 4887"KEY(srid));</programlisting> If you are upgrading an old database containing " 4888"french <ulink url=\"https://en.wikipedia.org/wiki/Institut_g" 4889"%C3%A9ographique_national\"> IGN </ulink> cartography, you will have " 4890"probably SRIDs out of range and you will see, when importing your database, " 4891"issues like this : <programlisting> WARNING: SRID 310642222 converted to " 4892"999175 (in reserved zone)</programlisting> In this case, you can try " 4893"following steps : first throw out completely the IGN from the sql which is " 4894"resulting from postgis_restore.pl. So, after having run : " 4895"<programlisting>perl utils/postgis_restore.pl \"/somepath/olddb.backup\" > " 4896"olddb.sql</programlisting> run this command : <programlisting>grep -v IGNF " 4897"olddb.sql > olddb-without-IGN.sql</programlisting> Create then your newdb, " 4898"activate the required Postgis extensions, and insert properly the french " 4899"system IGN with : <ulink url=\"https://raw.githubusercontent.com/Remi-C/" 4900"IGN_spatial_ref_for_PostGIS/master/Put_IGN_SRS_into_Postgis.sql\"> this " 4901"script </ulink> After these operations, import your data :" 4902msgstr "" 4903 4904#. Tag: programlisting 4905#: installation.xml:1490 4906#, no-c-format 4907msgid "" 4908"psql -h localhost -p 5432 -U postgres -d newdb -f olddb-without-IGN.sql 2> " 4909"errors.txt" 4910msgstr "" 4911 4912#. Tag: title 4913#: installation.xml:1501 4914#, no-c-format 4915msgid "Common Problems during installation" 4916msgstr "" 4917 4918#. Tag: para 4919#: installation.xml:1502 4920#, no-c-format 4921msgid "" 4922"There are several things to check when your installation or upgrade doesn't " 4923"go as you expected." 4924msgstr "" 4925"Hay varias cosas a comprobar cuando la instalación o actualización no han " 4926"fusionado como se esperaba." 4927 4928#. Tag: para 4929#: installation.xml:1509 4930#, no-c-format 4931msgid "" 4932"Check that you have installed PostgreSQL &min_postgres_version; or newer, " 4933"and that you are compiling against the same version of the PostgreSQL source " 4934"as the version of PostgreSQL that is running. Mix-ups can occur when your " 4935"(Linux) distribution has already installed PostgreSQL, or you have otherwise " 4936"installed PostgreSQL before and forgotten about it. PostGIS will only work " 4937"with PostgreSQL &min_postgres_version; or newer, and strange, unexpected " 4938"error messages will result if you use an older version. To check the version " 4939"of PostgreSQL which is running, connect to the database using psql and run " 4940"this query:" 4941msgstr "" 4942"Comprueba que tienes instalado PostgreSQL &min_postgres_version; o " 4943"posterior, y que estas compilando para esta version de PostgreSQL que estas " 4944"utilizando. Se pueden producir confusiones cuando tu distribución (Linux)ya " 4945"tiene instalada PostgreSQL, o has instalado antes PostgreSQL y lo has " 4946"olvidado. PostGIS solo funcionará con PostgreSQL &min_postgres_version; o " 4947"superior, y errores inesperados o extraños pueden ocurrir si utilizas una " 4948"version mas antigua. Para comprobar la version de PostgreSQL que esta " 4949"instalada y ejecutándose, conectare a la base de datos utilizando psql y " 4950"ejecuta la siguiente consulta:" 4951 4952#. Tag: programlisting 4953#: installation.xml:1522 4954#, no-c-format 4955msgid "SELECT version();" 4956msgstr "SELECT version();" 4957 4958#. Tag: para 4959#: installation.xml:1524 4960#, no-c-format 4961msgid "" 4962"If you are running an RPM based distribution, you can check for the " 4963"existence of pre-installed packages using the <command>rpm</command> command " 4964"as follows: <command>rpm -qa | grep postgresql</command>" 4965msgstr "" 4966"Si estas ejecutando una version basada en una distribución RPM, puedes " 4967"comprobar si existen paquetes pre-instalados utilizando el comando " 4968"<command>rpm</command> como sigue: <command>rpm -qa | grep postgresql</" 4969"command>" 4970 4971#. Tag: para 4972#: installation.xml:1532 4973#, no-c-format 4974msgid "" 4975"If your upgrade fails, make sure you are restoring into a database that " 4976"already has PostGIS installed." 4977msgstr "" 4978"Si tienes errores en la actualización, asegúrate de que estas restaurando tu " 4979"base de datos en una que tenga instalada PostGIS." 4980 4981#. Tag: programlisting 4982#: installation.xml:1533 4983#, no-c-format 4984msgid "SELECT postgis_full_version();" 4985msgstr "SELECT postgis_full_version();" 4986 4987#. Tag: para 4988#: installation.xml:1537 4989#, no-c-format 4990msgid "" 4991"Also check that configure has correctly detected the location and version of " 4992"PostgreSQL, the Proj4 library and the GEOS library." 4993msgstr "" 4994"Comprueba que tu configuración detecta la ubicación y la version correctas " 4995"de PostgreSQL, la librería Proj4 y la librería GEOS." 4996 4997#. Tag: para 4998#: installation.xml:1544 4999#, no-c-format 5000msgid "" 5001"The output from configure is used to generate the <filename>postgis_config." 5002"h</filename> file. Check that the <varname>POSTGIS_PGSQL_VERSION</varname>, " 5003"<varname>POSTGIS_PROJ_VERSION</varname> and <varname>POSTGIS_GEOS_VERSION</" 5004"varname> variables have been set correctly." 5005msgstr "" 5006"La salida de configure se utiliza para generar el fichero " 5007"<filename>postgis_config.h</filename>. Comprueba que la variables " 5008"<varname>POSTGIS_PGSQL_VERSION</varname>, <varname>POSTGIS_PROJ_VERSION</" 5009"varname> y <varname>POSTGIS_GEOS_VERSION</varname>, han sido bien " 5010"configuradas." 5011 5012#. Tag: title 5013#: installation.xml:1557 5014#, no-c-format 5015msgid "Loader/Dumper" 5016msgstr "Cargador/Dumper" 5017 5018#. Tag: para 5019#: installation.xml:1559 5020#, no-c-format 5021msgid "" 5022"The data loader and dumper are built and installed automatically as part of " 5023"the PostGIS build. To build and install them manually:" 5024msgstr "" 5025"El cargador y dumper de datos se compila e instala de forma automática como " 5026"parte de la distribución de PostGIS. Para compilar e instalar de forma " 5027"manual puedes ejecutar:" 5028 5029#. Tag: programlisting 5030#: installation.xml:1564 5031#, no-c-format 5032msgid "" 5033"# cd postgis-&last_release_version;/loader\n" 5034"# make\n" 5035"# make install" 5036msgstr "" 5037"# cd postgis-&last_release_version;/loader\n" 5038"# make\n" 5039"# make install" 5040 5041#. Tag: para 5042#: installation.xml:1566 5043#, no-c-format 5044msgid "" 5045"The loader is called <filename>shp2pgsql</filename> and converts ESRI Shape " 5046"files into SQL suitable for loading in PostGIS/PostgreSQL. The dumper is " 5047"called <filename>pgsql2shp</filename> and converts PostGIS tables (or " 5048"queries) into ESRI Shape files. For more verbose documentation, see the " 5049"online help, and the manual pages." 5050msgstr "" 5051"El cargador se llama <filename>shp2pgsql</filename> y convierte ficheros " 5052"Shape de ESRI en sentencias SQL necesarias para cargarlo en PostGIS/" 5053"PostgreSQL. El dumper se llama <filename>pgsql2shp</filename> y convierte " 5054"tablas PostGIS (o sentencias) en ficheros Shape de ESRI. Para mayor " 5055"información, puedes ver la información en linea y las pagnas del manual." 5056 5057#~ msgid "" 5058#~ "cd extensions\n" 5059#~ "cd postgis\n" 5060#~ "make clean\n" 5061#~ "make\n" 5062#~ "make install\n" 5063#~ "cd ..\n" 5064#~ "cd postgis_topology\n" 5065#~ "make clean\n" 5066#~ "make\n" 5067#~ "make install\n" 5068#~ "cd ..\n" 5069#~ "cd postgis_sfcgal\n" 5070#~ "make clean\n" 5071#~ "make\n" 5072#~ "make install\n" 5073#~ "\n" 5074#~ "cd ..\n" 5075#~ "cd address_standardizer\n" 5076#~ "make clean\n" 5077#~ "make\n" 5078#~ "make install\n" 5079#~ "make installcheck\n" 5080#~ "\n" 5081#~ "cd ..\n" 5082#~ "cd postgis_tiger_geocoder\n" 5083#~ "make clean\n" 5084#~ "make\n" 5085#~ "make install\n" 5086#~ "make installcheck" 5087#~ msgstr "" 5088#~ "cd extensions\n" 5089#~ "cd postgis\n" 5090#~ "make clean\n" 5091#~ "make\n" 5092#~ "make install\n" 5093#~ "cd ..\n" 5094#~ "cd postgis_topology\n" 5095#~ "make clean\n" 5096#~ "make\n" 5097#~ "make install\n" 5098#~ "cd ..\n" 5099#~ "cd postgis_sfcgal\n" 5100#~ "make clean\n" 5101#~ "make\n" 5102#~ "make install\n" 5103#~ "\n" 5104#~ "cd ..\n" 5105#~ "cd address_standardizer\n" 5106#~ "make clean\n" 5107#~ "make\n" 5108#~ "make install\n" 5109#~ "make installcheck\n" 5110#~ "\n" 5111#~ "cd ..\n" 5112#~ "cd postgis_tiger_geocoder\n" 5113#~ "make clean\n" 5114#~ "make\n" 5115#~ "make install\n" 5116#~ "make installcheck" 5117 5118#~ msgid "" 5119#~ "In order to fix this you should copy your custom SRS to a SRID with a " 5120#~ "valid value (maybe in the 910000..910999 range), convert all your tables " 5121#~ "to the new srid (see <xref linkend=\"UpdateGeometrySRID\"/>), delete the " 5122#~ "invalid entry from spatial_ref_sys and re-construct the check(s) with:" 5123#~ msgstr "" 5124#~ "Para corregir esto deberías copiar tus SRS personalizados en in SRID con " 5125#~ "un valor (quizás en el rango de valores 910000..910999), convertir " 5126#~ "todas las tablas al nuevo srid (ver como hacer esto en <xref linkend=" 5127#~ "\"UpdateGeometrySRID\"/>), borrar las entradas invalidas de la tabla " 5128#~ "spatial_ref_sys y reconstruir la o las restricciones chek con:" 5129 5130#~ msgid "" 5131#~ "ALTER TABLE spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_srid_check " 5132#~ "check (srid > 0 AND srid < 999000 );" 5133#~ msgstr "" 5134#~ "ALTER TABLE spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_srid_check " 5135#~ "check (srid > 0 AND srid < 999000 );" 5136 5137#~ msgid "ALTER TABLE spatial_ref_sys ADD PRIMARY KEY(srid));" 5138#~ msgstr "ALTER TABLE spatial_ref_sys ADD PRIMARY KEY(srid));" 5139