Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/security/en/units/?format=api
{ "count": 68, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "PostgreSQL Security" ], "previous_source": "", "target": [ "PostgreSQL Security" ], "id_hash": -4859589184915499822, "content_hash": -4859589184915499822, "location": "../../en/security.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99958/?format=api", "priority": 100, "id": 99958, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=3c8f45622ec814d2", "url": "https://weblate.osgeo.org/api/units/99958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.825145Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "PostgreSQL has a rich and flexible permissions system, with the ability to parcel out particular privileges to particular roles_, and provide users with the powers of one or more of those roles_." ], "previous_source": "", "target": [ "PostgreSQL has a rich and flexible permissions system, with the ability to parcel out particular privileges to particular roles_, and provide users with the powers of one or more of those roles_." ], "id_hash": 3571811970113678802, "content_hash": 3571811970113678802, "location": "../../en/security.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://weblate.osgeo.org/api/units/99960/?format=api", "priority": 100, "id": 99960, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=b191a010031d2dd2", "url": "https://weblate.osgeo.org/api/units/99960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.857639Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "In addition, the PostgreSQL server can use multiple different systems to authenticate users. This means that the database can use the same authentication infrastructure as other architecture components, simplifying password management." ], "previous_source": "", "target": [ "In addition, the PostgreSQL server can use multiple different systems to authenticate users. This means that the database can use the same authentication infrastructure as other architecture components, simplifying password management." ], "id_hash": -5836858618371869241, "content_hash": -5836858618371869241, "location": "../../en/security.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://weblate.osgeo.org/api/units/99968/?format=api", "priority": 100, "id": 99968, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=2eff5002f7c475c7", "url": "https://weblate.osgeo.org/api/units/99968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.883985Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Users and Roles" ], "previous_source": "", "target": [ "Users and Roles" ], "id_hash": 5350475191839341233, "content_hash": 5350475191839341233, "location": "../../en/security.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/99982/?format=api", "priority": 100, "id": 99982, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=ca40b4d6c51fbab1", "url": "https://weblate.osgeo.org/api/units/99982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.906953Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "In this chapter we will create two useful production users:" ], "previous_source": "", "target": [ "In this chapter we will create two useful production users:" ], "id_hash": -4193773012771300253, "content_hash": -4193773012771300253, "location": "../../en/security.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99997/?format=api", "priority": 100, "id": 99997, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=45ccb9aa19259c63", "url": "https://weblate.osgeo.org/api/units/99997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.929498Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "A read-only user for use in a publishing application." ], "previous_source": "", "target": [ "A read-only user for use in a publishing application." ], "id_hash": 4741666372591608750, "content_hash": 4741666372591608750, "location": "../../en/security.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/100011/?format=api", "priority": 100, "id": 100011, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=c1cdc87185bce3ae", "url": "https://weblate.osgeo.org/api/units/100011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.952392Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "A read/write user for use by a developer in building a software or analyzing data." ], "previous_source": "", "target": [ "A read/write user for use by a developer in building a software or analyzing data." ], "id_hash": 6491077351136390747, "content_hash": 6491077351136390747, "location": "../../en/security.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/100013/?format=api", "priority": 100, "id": 100013, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=da14f075ac116e5b", "url": "https://weblate.osgeo.org/api/units/100013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.974843Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Rather than creating users and granting them the necessary powers, we will create two roles with the right powers and then create two users and add them to the appropriate roles. That way we can easily reuse the roles when we create further users." ], "previous_source": "", "target": [ "Rather than creating users and granting them the necessary powers, we will create two roles with the right powers and then create two users and add them to the appropriate roles. That way we can easily reuse the roles when we create further users." ], "id_hash": -6618245753721883940, "content_hash": -6618245753721883940, "location": "../../en/security.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://weblate.osgeo.org/api/units/100015/?format=api", "priority": 100, "id": 100015, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=2427448d4d2b72dc", "url": "https://weblate.osgeo.org/api/units/100015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:43.997965Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Creating Roles" ], "previous_source": "", "target": [ "Creating Roles" ], "id_hash": -3135716715962971761, "content_hash": -3135716715962971761, "location": "../../en/security.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100017/?format=api", "priority": 100, "id": 100017, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=547bb242b4c5c98f", "url": "https://weblate.osgeo.org/api/units/100017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.021174Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "A role is a user and a user is a role. The only difference is that a \"user\" can be said to be a role with the \"login\" privilege." ], "previous_source": "", "target": [ "A role is a user and a user is a role. The only difference is that a \"user\" can be said to be a role with the \"login\" privilege." ], "id_hash": 4902646901182051951, "content_hash": 4902646901182051951, "location": "../../en/security.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/100019/?format=api", "priority": 100, "id": 100019, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=c409b3619c20366f", "url": "https://weblate.osgeo.org/api/units/100019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.044067Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "So functionally, the two SQL statements below are the same, they both create a \"role with the login privilege\", which is to say, a \"user\"." ], "previous_source": "", "target": [ "So functionally, the two SQL statements below are the same, they both create a \"role with the login privilege\", which is to say, a \"user\"." ], "id_hash": -4952321988958474450, "content_hash": -4952321988958474450, "location": "../../en/security.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/100021/?format=api", "priority": 100, "id": 100021, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=3b45d163bac62f2e", "url": "https://weblate.osgeo.org/api/units/100021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.067068Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Read-only Users" ], "previous_source": "", "target": [ "Read-only Users" ], "id_hash": -8297080965088323761, "content_hash": -8297080965088323761, "location": "../../en/security.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100023/?format=api", "priority": 100, "id": 100023, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=0cdad8d27341574f", "url": "https://weblate.osgeo.org/api/units/100023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.090098Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Our read-only user will be for a web application to use to query the ``nyc_streets`` table." ], "previous_source": "", "target": [ "Our read-only user will be for a web application to use to query the ``nyc_streets`` table." ], "id_hash": -4011738515767811031, "content_hash": -4011738515767811031, "location": "../../en/security.rst:38", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/100025/?format=api", "priority": 100, "id": 100025, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=4853711333e82429", "url": "https://weblate.osgeo.org/api/units/100025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.112387Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "The application will have specific access to the ``nyc_streets`` table, but will inherit the necessary system access for PostGIS operations from the ``postgis_reader`` role." ], "previous_source": "", "target": [ "The application will have specific access to the ``nyc_streets`` table, but will inherit the necessary system access for PostGIS operations from the ``postgis_reader`` role." ], "id_hash": 3438781860404944023, "content_hash": 3438781860404944023, "location": "../../en/security.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/100027/?format=api", "priority": 100, "id": 100027, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=afb901e1f17e5c97", "url": "https://weblate.osgeo.org/api/units/100027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.135954Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Now, when we login as app1, we can select rows from the ``nyc_streets`` table. However, we cannot run an :command:`ST_Transform` call! Why not?" ], "previous_source": "", "target": [ "Now, when we login as app1, we can select rows from the ``nyc_streets`` table. However, we cannot run an :command:`ST_Transform` call! Why not?" ], "id_hash": 1332244657631979761, "content_hash": 1332244657631979761, "location": "../../en/security.rst:54", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://weblate.osgeo.org/api/units/100029/?format=api", "priority": 100, "id": 100029, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=927d15752410e8f1", "url": "https://weblate.osgeo.org/api/units/100029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.159054Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "The answer is contained in the error statement. Though our ``app1`` user can view the contents of the ``nyc_streets`` table fine, it cannot view the contents of ``spatial_ref_sys``, so the call to :command:`ST_Transform` fails." ], "previous_source": "", "target": [ "The answer is contained in the error statement. Though our ``app1`` user can view the contents of the ``nyc_streets`` table fine, it cannot view the contents of ``spatial_ref_sys``, so the call to :command:`ST_Transform` fails." ], "id_hash": -3503355162547605639, "content_hash": -3503355162547605639, "location": "../../en/security.rst:70", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://weblate.osgeo.org/api/units/100031/?format=api", "priority": 100, "id": 100031, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=4f61950a8e51af79", "url": "https://weblate.osgeo.org/api/units/100031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.181969Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "So, we need to also grant the ``postgis_reader`` role read access to all the PostGIS metadata tables:" ], "previous_source": "", "target": [ "So, we need to also grant the ``postgis_reader`` role read access to all the PostGIS metadata tables:" ], "id_hash": 3839233857092711565, "content_hash": 3839233857092711565, "location": "../../en/security.rst:72", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100033/?format=api", "priority": 100, "id": 100033, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=b547b2da15a9f48d", "url": "https://weblate.osgeo.org/api/units/100033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.205524Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Now we have a nice generic ``postgis_reader`` role we can apply to any user that need to read from PostGIS tables." ], "previous_source": "", "target": [ "Now we have a nice generic ``postgis_reader`` role we can apply to any user that need to read from PostGIS tables." ], "id_hash": -3220110394345339664, "content_hash": -3220110394345339664, "location": "../../en/security.rst:80", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/100036/?format=api", "priority": 100, "id": 100036, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=534fdea83f80c4f0", "url": "https://weblate.osgeo.org/api/units/100036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.228371Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Read/write Users" ], "previous_source": "", "target": [ "Read/write Users" ], "id_hash": -5850064955251807334, "content_hash": -5850064955251807334, "location": "../../en/security.rst:91", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100038/?format=api", "priority": 100, "id": 100038, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=2ed064eb0d412b9a", "url": "https://weblate.osgeo.org/api/units/100038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.251624Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "There are two kinds of read/write scenarios we need to consider:" ], "previous_source": "", "target": [ "There are two kinds of read/write scenarios we need to consider:" ], "id_hash": -787938327117235358, "content_hash": -787938327117235358, "location": "../../en/security.rst:93", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/100049/?format=api", "priority": 100, "id": 100049, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=7510ae442342fb62", "url": "https://weblate.osgeo.org/api/units/100049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.274857Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Web applications and others that need to write to existing data tables." ], "previous_source": "", "target": [ "Web applications and others that need to write to existing data tables." ], "id_hash": 3156476127131607887, "content_hash": 3156476127131607887, "location": "../../en/security.rst:95", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/100064/?format=api", "priority": 100, "id": 100064, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=abce0e505bae234f", "url": "https://weblate.osgeo.org/api/units/100064/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.297852Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Developers or analysts that need to create new tables and geometry columns as part of their work." ], "previous_source": "", "target": [ "Developers or analysts that need to create new tables and geometry columns as part of their work." ], "id_hash": 3902463633128973806, "content_hash": 3902463633128973806, "location": "../../en/security.rst:96", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100081/?format=api", "priority": 100, "id": 100081, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=b62855ff898865ee", "url": "https://weblate.osgeo.org/api/units/100081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.320993Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "For web applications that require write access to data tables, we just need to grant extra permissions to the tables themselves, and we can continue to use the ``postgis_reader`` role." ], "previous_source": "", "target": [ "For web applications that require write access to data tables, we just need to grant extra permissions to the tables themselves, and we can continue to use the ``postgis_reader`` role." ], "id_hash": -1792759719368862780, "content_hash": -1792759719368862780, "location": "../../en/security.rst:98", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/100092/?format=api", "priority": 100, "id": 100092, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=671ed6889f63d3c4", "url": "https://weblate.osgeo.org/api/units/100092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.344481Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "These kinds of permissions would be required for a read/write WFS service, for example." ], "previous_source": "", "target": [ "These kinds of permissions would be required for a read/write WFS service, for example." ], "id_hash": -7765031624576137387, "content_hash": -7765031624576137387, "location": "../../en/security.rst:105", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100095/?format=api", "priority": 100, "id": 100095, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=143d10e0db770755", "url": "https://weblate.osgeo.org/api/units/100095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.368407Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "For developers and analysts, a little more access is needed to the main PostGIS metadata tables. We will need a ``postgis_writer`` role that can edit the PostGIS metadata tables!" ], "previous_source": "", "target": [ "For developers and analysts, a little more access is needed to the main PostGIS metadata tables. We will need a ``postgis_writer`` role that can edit the PostGIS metadata tables!" ], "id_hash": -993081141215788344, "content_hash": -993081141215788344, "location": "../../en/security.rst:107", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/100098/?format=api", "priority": 100, "id": 100098, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=7237ddf6b0b182c8", "url": "https://weblate.osgeo.org/api/units/100098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.391072Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Now try the table creation SQL above as the app1 user and see how it goes!" ], "previous_source": "", "target": [ "Now try the table creation SQL above as the app1 user and see how it goes!" ], "id_hash": 3770213091740986696, "content_hash": 3770213091740986696, "location": "../../en/security.rst:123", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/100101/?format=api", "priority": 100, "id": 100101, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=b4527cd4dcbfad48", "url": "https://weblate.osgeo.org/api/units/100101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.413974Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Encryption" ], "previous_source": "", "target": [ "Encryption" ], "id_hash": 6514370749377085168, "content_hash": 6514370749377085168, "location": "../../en/security.rst:127", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/100104/?format=api", "priority": 100, "id": 100104, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=da67b1ae93d0fef0", "url": "https://weblate.osgeo.org/api/units/100104/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.436415Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "PostgreSQL provides a lot of `encryption facilities <http://www.postgresql.org/docs/current/static/encryption-options.html>`_, many of them optional, some of them on by default." ], "previous_source": "", "target": [ "PostgreSQL provides a lot of `encryption facilities <http://www.postgresql.org/docs/current/static/encryption-options.html>`_, many of them optional, some of them on by default." ], "id_hash": -8165061882634689316, "content_hash": -8165061882634689316, "location": "../../en/security.rst:129", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/100107/?format=api", "priority": 100, "id": 100107, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=0eafdf7a647a24dc", "url": "https://weblate.osgeo.org/api/units/100107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.458540Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "By default, all passwords are MD5 encrypted. The client/server handshake double encrypts the MD5 password to prevent re-use of the hash by anyone who intercepts the password." ], "previous_source": "", "target": [ "By default, all passwords are MD5 encrypted. The client/server handshake double encrypts the MD5 password to prevent re-use of the hash by anyone who intercepts the password." ], "id_hash": -1574468314535460393, "content_hash": -1574468314535460393, "location": "../../en/security.rst:131", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/100110/?format=api", "priority": 100, "id": 100110, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=6a265d68ea0181d7", "url": "https://weblate.osgeo.org/api/units/100110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.480866Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "`SSL connections <http://www.postgresql.org/docs/current/static/libpq-ssl.html>`_ are optionally available between the client and server, to encrypt all data and login information. SSL certificate authentication is also available when SSL connections are used." ], "previous_source": "", "target": [ "`SSL connections <http://www.postgresql.org/docs/current/static/libpq-ssl.html>`_ are optionally available between the client and server, to encrypt all data and login information. SSL certificate authentication is also available when SSL connections are used." ], "id_hash": 2901162889902977505, "content_hash": 2901162889902977505, "location": "../../en/security.rst:132", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/100113/?format=api", "priority": 100, "id": 100113, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=a8430047003671e1", "url": "https://weblate.osgeo.org/api/units/100113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.503908Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Columns inside the database can be encrypted using the pgcrypto_ module, which includes hashing algorithms, direct ciphers (blowfish, aes) and both public key and symmetric PGP encryption." ], "previous_source": "", "target": [ "Columns inside the database can be encrypted using the pgcrypto_ module, which includes hashing algorithms, direct ciphers (blowfish, aes) and both public key and symmetric PGP encryption." ], "id_hash": -5487050370883334902, "content_hash": -5487050370883334902, "location": "../../en/security.rst:133", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/100117/?format=api", "priority": 100, "id": 100117, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=33da14c262d2cd0a", "url": "https://weblate.osgeo.org/api/units/100117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.529160Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "SSL Connections" ], "previous_source": "", "target": [ "SSL Connections" ], "id_hash": -1545266959406391306, "content_hash": -1545266959406391306, "location": "../../en/security.rst:136", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100120/?format=api", "priority": 100, "id": 100120, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=6a8e1be3396f1ff6", "url": "https://weblate.osgeo.org/api/units/100120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.553068Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "In order to use SSL connections, both your client and server must support SSL." ], "previous_source": "", "target": [ "In order to use SSL connections, both your client and server must support SSL." ], "id_hash": -5050705415887096559, "content_hash": -5050705415887096559, "location": "../../en/security.rst:138", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100123/?format=api", "priority": 100, "id": 100123, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=39e84a2f1ce87511", "url": "https://weblate.osgeo.org/api/units/100123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.575169Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "First, turn off PostgreSQL, since activating SSL will require a restart." ], "previous_source": "", "target": [ "First, turn off PostgreSQL, since activating SSL will require a restart." ], "id_hash": -3481282884958952814, "content_hash": -3481282884958952814, "location": "../../en/security.rst:140", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/100126/?format=api", "priority": 100, "id": 100126, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=4fafffa9275fe292", "url": "https://weblate.osgeo.org/api/units/100126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.597408Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Next, we acquire or generate an SSL certificate and key. The certificate will need to have no passphrase on it, or the database server won't be able to start up. You can generate a self-signed key as follows:" ], "previous_source": "", "target": [ "Next, we acquire or generate an SSL certificate and key. The certificate will need to have no passphrase on it, or the database server won't be able to start up. You can generate a self-signed key as follows:" ], "id_hash": -3997102570920530077, "content_hash": -3997102570920530077, "location": "../../en/security.rst:141", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://weblate.osgeo.org/api/units/100128/?format=api", "priority": 100, "id": 100128, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=48877063a97b2f63", "url": "https://weblate.osgeo.org/api/units/100128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.618942Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Copy the ``server.crt`` and ``server.key`` into the PostgreSQL data directory." ], "previous_source": "", "target": [ "Copy the ``server.crt`` and ``server.key`` into the PostgreSQL data directory." ], "id_hash": -1353751683606178005, "content_hash": -1353751683606178005, "location": "../../en/security.rst:157", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/100131/?format=api", "priority": 100, "id": 100131, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=6d3682042891172b", "url": "https://weblate.osgeo.org/api/units/100131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.641357Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Enable SSL support in the ``postgresql.conf`` file by turning the \"ssl\" parameter to \"on\"." ], "previous_source": "", "target": [ "Enable SSL support in the ``postgresql.conf`` file by turning the \"ssl\" parameter to \"on\"." ], "id_hash": 6049938240709242491, "content_hash": 6049938240709242491, "location": "../../en/security.rst:159", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100135/?format=api", "priority": 100, "id": 100135, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=d3f5b2c6a686ae7b", "url": "https://weblate.osgeo.org/api/units/100135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.665174Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Now re-start PostgreSQL; the server is ready for SSL operation." ], "previous_source": "", "target": [ "Now re-start PostgreSQL; the server is ready for SSL operation." ], "id_hash": 8451783515966612238, "content_hash": 8451783515966612238, "location": "../../en/security.rst:161", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/100137/?format=api", "priority": 100, "id": 100137, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=f54ac4540bb1230e", "url": "https://weblate.osgeo.org/api/units/100137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.687530Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "With the server enabled for SSL, creating an encrypted connection is easy. In PgAdmin, create a new server connection (File > Add Server...), and set the SSL parameter to “require”." ], "previous_source": "", "target": [ "With the server enabled for SSL, creating an encrypted connection is easy. In PgAdmin, create a new server connection (File > Add Server...), and set the SSL parameter to “require”." ], "id_hash": 5432242706769266019, "content_hash": 5432242706769266019, "location": "../../en/security.rst:163", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/100139/?format=api", "priority": 100, "id": 100139, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=cb6333f5e6b04563", "url": "https://weblate.osgeo.org/api/units/100139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.709536Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Once you connect with the new connection, you can see in its properties that it is using an SSL connection." ], "previous_source": "", "target": [ "Once you connect with the new connection, you can see in its properties that it is using an SSL connection." ], "id_hash": 22707067157741975, "content_hash": 22707067157741975, "location": "../../en/security.rst:167", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/100142/?format=api", "priority": 100, "id": 100142, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=8050abf50fd40197", "url": "https://weblate.osgeo.org/api/units/100142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.732812Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Since the default SSL connection mode is \"prefer\", you don't even need to specify an SSL preference when connecting. A connection with the command line ``psql`` terminal will pick up the SSL option and use it by default:" ], "previous_source": "", "target": [ "Since the default SSL connection mode is \"prefer\", you don't even need to specify an SSL preference when connecting. A connection with the command line ``psql`` terminal will pick up the SSL option and use it by default:" ], "id_hash": -8219583089279469364, "content_hash": -8219583089279469364, "location": "../../en/security.rst:171", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://weblate.osgeo.org/api/units/100144/?format=api", "priority": 100, "id": 100144, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=0dee2cbac1b078cc", "url": "https://weblate.osgeo.org/api/units/100144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.755018Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Note how the terminal reports the SSL status of the connection." ], "previous_source": "", "target": [ "Note how the terminal reports the SSL status of the connection." ], "id_hash": -5879616372794176339, "content_hash": -5879616372794176339, "location": "../../en/security.rst:181", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/100147/?format=api", "priority": 100, "id": 100147, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=2e67680f7c084cad", "url": "https://weblate.osgeo.org/api/units/100147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.777656Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Data Encryption" ], "previous_source": "", "target": [ "Data Encryption" ], "id_hash": 760264618451589382, "content_hash": 760264618451589382, "location": "../../en/security.rst:185", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100150/?format=api", "priority": 100, "id": 100150, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=8a8d00a4761ad906", "url": "https://weblate.osgeo.org/api/units/100150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.799502Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "The pgcrypto_ module has a huge range of encryption options, so we will only demonstrate the simplest use case: encrypting a column of data using a symmetric cipher." ], "previous_source": "", "target": [ "The pgcrypto_ module has a huge range of encryption options, so we will only demonstrate the simplest use case: encrypting a column of data using a symmetric cipher." ], "id_hash": -762058506319658870, "content_hash": -762058506319658870, "location": "../../en/security.rst:187", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/100153/?format=api", "priority": 100, "id": 100153, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=756c9fd378c0808a", "url": "https://weblate.osgeo.org/api/units/100153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.821664Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "First, enable pgcrypto by loading the contrib SQL file, either in PgAdmin or psql." ], "previous_source": "", "target": [ "First, enable pgcrypto by loading the contrib SQL file, either in PgAdmin or psql." ], "id_hash": -2871292643420410985, "content_hash": -2871292643420410985, "location": "../../en/security.rst:189", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100156/?format=api", "priority": 100, "id": 100156, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=58271e8db6bbeb97", "url": "https://weblate.osgeo.org/api/units/100156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.844105Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Then, test the encryption function." ], "previous_source": "", "target": [ "Then, test the encryption function." ], "id_hash": -7824868225623187845, "content_hash": -7824868225623187845, "location": "../../en/security.rst:196", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://weblate.osgeo.org/api/units/100158/?format=api", "priority": 100, "id": 100158, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=13687bce857d1e7b", "url": "https://weblate.osgeo.org/api/units/100158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.865822Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "And make sure it's reversible too!" ], "previous_source": "", "target": [ "And make sure it's reversible too!" ], "id_hash": -7080552236869215206, "content_hash": -7080552236869215206, "location": "../../en/security.rst:203", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/100160/?format=api", "priority": 100, "id": 100160, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=1dbcd34143d01c1a", "url": "https://weblate.osgeo.org/api/units/100160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.888062Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "Authentication" ], "previous_source": "", "target": [ "Authentication" ], "id_hash": 542232198182989621, "content_hash": 542232198182989621, "location": "../../en/security.rst:212", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/100162/?format=api", "priority": 100, "id": 100162, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=8786654fb679ef35", "url": "https://weblate.osgeo.org/api/units/100162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.910132Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "PostgreSQL supports many different `authentication methods <http://www.postgresql.org/docs/current/static/auth-methods.html>`_, to allow easy integration into existing enterprise architectures. For production purposes, the following methods are commonly used:" ], "previous_source": "", "target": [ "PostgreSQL supports many different `authentication methods <http://www.postgresql.org/docs/current/static/auth-methods.html>`_, to allow easy integration into existing enterprise architectures. For production purposes, the following methods are commonly used:" ], "id_hash": -8606572005699402009, "content_hash": -8606572005699402009, "location": "../../en/security.rst:214", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/100167/?format=api", "priority": 100, "id": 100167, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=088f505c427746e7", "url": "https://weblate.osgeo.org/api/units/100167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.932296Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/security/en/?format=api", "source": [ "**Password** is the basic system where the passwords are stored by the database, with MD5 encryption." ], "previous_source": "", "target": [ "**Password** is the basic system where the passwords are stored by the database, with MD5 encryption." ], "id_hash": 2280732348306121068, "content_hash": 2280732348306121068, "location": "../../en/security.rst:216", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/100181/?format=api", "priority": 100, "id": 100181, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/security/en/?checksum=9fa6c9fca887616c", "url": "https://weblate.osgeo.org/api/units/100181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:44.954460Z" } ] }