Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/security/changes/?format=api
{ "count": 423, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/security/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": null, "author": null, "timestamp": "2025-09-04T23:47:43.379353Z", "action": 17, "target": "", "id": 2217841, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2217841/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100585/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T22:06:10.912413Z", "action": 2, "target": "Ahora intenta la creación de tablas en SQL anterior con el usuario app1 y observa qué sucede!", "id": 2217768, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217768/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100628/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:34:47.637401Z", "action": 2, "target": "`Autenticación en PostgreSQL <http://www.postgresql.org/docs/current/static/auth-methods.html>`_", "id": 2217652, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217652/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100629/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:34:37.982552Z", "action": 2, "target": "`Encriptación en PostgreSQL <http://www.postgresql.org/docs/current/static/encryption-options.html>`_", "id": 2217651, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217651/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:34:21.531433Z", "action": 1, "target": "", "id": 2217650, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2217650/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100630/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:34:21.402507Z", "action": 5, "target": "`Soporte a SSL en PostgreSQL<http://www.postgresql.org/docs/current/static/libpq-ssl.html>`_", "id": 2217649, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217649/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100629/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:33:55.411847Z", "action": 5, "target": "`PostgreSQL Encrpyption <http://www.postgresql.org/docs/current/static/encryption-options.html>`_", "id": 2217648, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217648/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100628/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:33:49.766086Z", "action": 5, "target": "`PostgreSQL Authentication <http://www.postgresql.org/docs/current/static/auth-methods.html>`_", "id": 2217647, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217647/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100626/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:33:37.915150Z", "action": 5, "target": "La línea para ``nyc`` en el ejemplo anterior es un ejemplo de entrada de acceso remoto. El ejemplo ``nyc`` permite acceso autenticado vía LDAP solo a máquinas en la red local (en este caso la red 192.168.1.) y solo a la base de datos nyc. Dependiendo de la seguridad de tu red, usarás versiones más o menos estrictas de estas reglas en tu configuración de producción.", "id": 2217646, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217646/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100625/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:33:29.917369Z", "action": 5, "target": "Es común que se confíe de las conexiones locales, ya que el acceso al propio servidor suele ser privilegiado. Las conexiones remotas están deshabilitadas de manera predeterminada cuando se instala PostgreSQL: si deseas conectarte desde máquinas remotas, tendrás que añadir una entrada.", "id": 2217645, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217645/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100624/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:32:42.962095Z", "action": 5, "target": "**METHOD** especifica el protocolo de autenticación a usar. \"trust\" omite completamente la autenticación y simplemente acepta cualquier nombre de usuario válido sin verificación.", "id": 2217644, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217644/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100623/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:32:37.020543Z", "action": 5, "target": "**CIDR-ADDRESS** especifica las limitaciones de red para conexiones remotas, usando la sintaxis network/netmask", "id": 2217643, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217643/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100622/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:32:29.749125Z", "action": 5, "target": "**USER** especifica a qué usuarios se refiere la línea o \"all\" para todos los usuarios", "id": 2217642, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217642/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100621/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:32:22.125412Z", "action": 5, "target": "**DATABASE** especifica a qué base de datos se refiere la línea de configuración o \"all\" para todas las bases de datos", "id": 2217641, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217641/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100620/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:31:32.161800Z", "action": 2, "target": "**TYPE** determina el tipo de acceso, ya sea \"local\" para conexiones desde el mismo servidor o \"host\" para conexiones remotas.", "id": 2217640, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217640/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100620/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:31:07.759289Z", "action": 5, "target": "**TYPE** determina el tipo de acceso, ya sea \"local\" para conexiones desde", "id": 2217639, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217639/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100619/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:57.589948Z", "action": 5, "target": "El archivo consta de cinco columnas", "id": 2217638, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217638/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100618/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:50.000397Z", "action": 5, "target": "Aquí un ejemplo de archivo ``pg_hba.conf``:", "id": 2217637, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217637/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100617/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:43.852649Z", "action": 5, "target": "Los métodos de autenticación se controlan con el archivo ``pg_hba.conf``. El \"HBA\" en el nombre del archivo significa \"host based access\", porque además de permitir especificar el método de autenticación para cada base de datos, también permite limitar el acceso por host utilizando direcciones de red.", "id": 2217636, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217636/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100615/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:36.117093Z", "action": 5, "target": "La autenticación PAM_ es una opción si estás en Linux o Solaris y usas el esquema PAM_ para provisión de autenticación transparente.", "id": 2217635, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217635/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100614/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:30.176962Z", "action": 5, "target": "La autenticación por **certificado** es una opción si esperas que todas las conexiones de cliente sean vía SSL y puedes gestionar la distribución de las claves.", "id": 2217634, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217634/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100613/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:24.237870Z", "action": 5, "target": "LDAP_ es otro método común de autenticación empresarial. El servidor `OpenLDAP <http://www.openldap.org/>`_ incluido en la mayoría de las distribuciones Linux proporciona una implementación de código abierto de LDAP_.", "id": 2217633, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217633/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100612/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:17.602642Z", "action": 5, "target": "Kerberos_ es un método estándar de autenticación empresarial, utilizado tanto por los esquemas GSSAPI_ como SSPI_ en PostgreSQL. Usando SSPI_, PostgreSQL puede autenticarse contra servidores Windows.", "id": 2217632, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217632/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100611/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:11.421275Z", "action": 5, "target": "**Password** es el sistema básico donde las contraseñas son almacenadas por la base de datos, con cifrado MD5.", "id": 2217631, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217631/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100608/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:30:04.953710Z", "action": 2, "target": "Y asegúrate de que también sea reversible!", "id": 2217630, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217630/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100610/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:57.616685Z", "action": 5, "target": "PostgreSQL soporta muchos `métodos de autenticación <http://www.postgresql.org/docs/current/static/auth-methods.html>`_ diferentes, para permitir una fácil integración en arquitecturas empresariales existentes. Para fines de producción, los siguientes métodos son comúnmente usados:", "id": 2217629, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217629/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100608/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:49.841939Z", "action": 5, "target": "Y asegúrate de que también sea reversible.", "id": 2217628, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217628/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100607/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:42.707941Z", "action": 5, "target": "Luego, prueba la función de cifrado.", "id": 2217627, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217627/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100606/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:36.649872Z", "action": 5, "target": "Primero, habilita pgcrypto cargando el archivo SQL de contrib, ya sea en PgAdmin o en psql.", "id": 2217626, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217626/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100605/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:27.738613Z", "action": 5, "target": "El módulo pgcrypto_ tiene una enorme variedad de opciones de cifrado, por lo que solo demostraremos el caso de uso más simple: cifrar una columna de datos usando un cifrado simétrico.", "id": 2217625, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217625/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100604/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:22.050684Z", "action": 5, "target": "Cifrado de Datos", "id": 2217624, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217624/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100602/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:15.658416Z", "action": 2, "target": "Dado que el modo de conexión SSL predeterminado es \"prefer\", ni siquiera necesitas especificar una preferencia SSL al conectarte. Una conexión con la terminal de línea de comandos ``psql`` tomará la opción SSL y la usará de manera predeterminada:", "id": 2217623, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217623/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100603/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:06.624392Z", "action": 5, "target": "Observa cómo la terminal informa el estado SSL de la conexión.", "id": 2217622, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217622/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100602/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:29:00.879499Z", "action": 5, "target": "Dado que el modo de conexión SSL predeterminado es \"prefer\", ni siquiera necesitas especificar una preferencia SSL al conectarte. Una conexión con la terminal de línea de comandos ``psql`` tomará la opción SSL y la usará por defecto:", "id": 2217621, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217621/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100600/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:42.648364Z", "action": 5, "target": "Una vez que te conectes, podrás ver en sus propiedades que está usando una conexión SSL.", "id": 2217620, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217620/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100599/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:31.291124Z", "action": 5, "target": "Con el servidor habilitado para SSL, crear una conexión cifrada es fácil. En PgAdmin, crea una nueva conexión de servidor (File > Add Server...), y establece el parámetro SSL en “require”.", "id": 2217619, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217619/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100598/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:23.922016Z", "action": 5, "target": "Ahora reinicia PostgreSQL; el servidor está listo para operar con SSL.", "id": 2217618, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217618/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100597/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:17.713805Z", "action": 5, "target": "Habilita el soporte SSL en el archivo ``postgresql.conf`` cambiando el parámetro \"ssl\" a \"on\".", "id": 2217617, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217617/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100596/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:12.085352Z", "action": 5, "target": "Copia los archivos ``server.crt`` y ``server.key`` en el directorio de datos de PostgreSQL.", "id": 2217616, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217616/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100595/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:28:05.822105Z", "action": 5, "target": "Luego, adquirimos o generamos un certificado y una clave SSL. El certificado no debe tener frase de paso, o el servidor de base de datos no podrá arrancar. Puedes generar una clave autofirmada de la siguiente forma:", "id": 2217615, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217615/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100594/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:58.742640Z", "action": 5, "target": "Primero, apaga PostgreSQL, ya que activar SSL requerirá un reinicio.", "id": 2217614, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217614/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100593/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:53.064240Z", "action": 5, "target": "Para usar conexiones SSL, tanto el cliente como el servidor deben soportar SSL.", "id": 2217613, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217613/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100592/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:45.200194Z", "action": 5, "target": "Conexiones SSL", "id": 2217612, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217612/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100591/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:38.436649Z", "action": 5, "target": "Dentro de la base de datos, las columnas pueden cifrarse utilizando el módulo pgcrypto_, que incluye algoritmos de hash, cifrados directos (blowfish, aes) y cifrado PGP tanto de clave pública como simétrica.", "id": 2217611, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217611/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100590/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:32.331966Z", "action": 5, "target": "Las `conexiones SSL <http://www.postgresql.org/docs/current/static/libpq-ssl.html>`_ están disponibles opcionalmente entre el cliente y el servidor, para cifrar todos los datos e información de inicio de sesión. La autenticación con certificados SSL también está disponible cuando se usan conexiones SSL.", "id": 2217610, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217610/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100589/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:25.425459Z", "action": 5, "target": "De manera predeterminada, todas las contraseñas están cifradas con MD5. El intercambio cliente/servidor cifra doblemente la contraseña MD5 para evitar la reutilización del hash por cualquiera que intercepte la contraseña.", "id": 2217609, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217609/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100587/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:27:10.733964Z", "action": 5, "target": "PostgreSQL proporciona muchas `facilidades de cifrado <http://www.postgresql.org/docs/current/static/encryption-options.html>`_, muchas de ellas opcionales, algunas activadas de manera predeterminada.", "id": 2217608, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217608/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100584/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:26:49.704202Z", "action": 2, "target": "Para desarrolladores y analistas, se necesita un poco más de acceso a las tablas principales de metadatos de PostGIS. Necesitaremos un rol ``postgis_writer`` que pueda editar las tablas de metadatos de PostGIS!", "id": 2217607, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217607/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100585/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:26:32.958018Z", "action": 5, "target": "Ahora intenta la creación de tablas en SQL anterior con el usuario app1 y observa qué sucede.", "id": 2217606, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217606/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100584/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/security/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T21:26:22.531555Z", "action": 5, "target": "Para desarrolladores y analistas, se necesita un poco más de acceso a las tablas principales de metadatos de PostGIS. Necesitaremos un rol ``postgis_writer`` que pueda editar las tablas de metadatos de PostGIS.", "id": 2217605, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217605/?format=api" } ] }