Try   HackMD

Instalación de PostgreSQL/PostGIS en Windows

Autor: Samuel Mesa
Fecha: 17 de noviembre de 2023

tags: PostgreSQL PostGIS

Se muestra de forma generar el proceso de instalación del software de PostgreSQL y PostGIS de forma local en el sistema operativo de Windows.

Todas las herramientas son software libre y de código abierto.

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →
Pasos generales de instalación

Paso 1: Descarga del software

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Paso 2: Instalación de PostgreSQL

Instalar el archivo de `postgresql-14.0-1-windows-x64.exe y seguir los pasos por defecto:

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Dejar por defecto la contraseña de postgres

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Dejar por defecto el puerto 5432

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Deshabilitar lanzar Stack Builder

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Paso 3: Instalación de PostGIS

Clic en el archivo postgis-bundle-pg14x64-setup-3.4.2-1.exe para iniciar el proceso de instalación:

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Image Not Showing Possible Reasons
  • The image was uploaded to a note which you don't have access to
  • The note which the image was originally uploaded to has been deleted
Learn More →

Con lo anterior se finaliza la instalación.

Verificar la conexión con QGIS

Los parámetros de conexión corresponden al siguiente:

host: localhost
Puerto: 5432
Usuario: postgres
Contraseña: postgres

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Last changed by 
 
Samuel Mesa
Samuel Fernando Mesa
0
665

Read more

Listado de Servcios Geográficos Web de ArcGIS Server en Colombia

Gran parte de los servicios geográficos Web de Colombia, en las diferentes entidades oficiales del país se publican a través del servidor de mapas de ArcGIS Server. A pesar que estos servicios no son considerados estándares abiertos, definidido por la OGC es posible acceder a ellos con el software de QGIS Desktop. Básicamente estos servicios son ArcGIS Mapserver, considerados como servicios de imágen o de mapas y ArcGIS Feature Server considerados como servicios de entidades.

Dec 15, 2024
Configurar una base e datos PostgreSQL/PostGIS con render

Uno de los pocos servicios que ofrecen de forma gratuita y limitada la configuración e instalación de una base de datos espacial con PostgreSQL/PostGIS.

Jun 12, 2024
Configuración del Receptor GNSS South Galaxy G1 con Field Genius y RTK NTRIP

Asegúrate de que tu receptor GNSS South Garmin G1 esté cargado y listo para usar.

Mar 24, 2024
Instalación de QGIS en Windows (MSYS2)

Fecha actualización: 12 de febrero de 2024Documentado por Samuel Mesa

Feb 13, 2024
Read more from Samuel Mesa
Published on HackMD