Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/backup/en/units/?format=api
{ "count": 72, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "PostgreSQL Backup and Restore" ], "previous_source": "", "target": [ "PostgreSQL Backup and Restore" ], "id_hash": 7727415565366050571, "content_hash": 7727415565366050571, "location": "../../en/backup.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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99080/?format=api", "priority": 100, "id": 99080, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=eb3d4b83dd77bf0b", "url": "https://weblate.osgeo.org/api/units/99080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.670402Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "There are lots of ways to backup a PostgreSQL database, and the one you choose will depend a great deal on how you are using the database." ], "previous_source": "", "target": [ "There are lots of ways to backup a PostgreSQL database, and the one you choose will depend a great deal on how you are using the database." ], "id_hash": 1599623516337744412, "content_hash": 1599623516337744412, "location": "../../en/backup.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": 27, "source_unit": "https://weblate.osgeo.org/api/units/99085/?format=api", "priority": 100, "id": 99085, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=9633011ce9ac2a1c", "url": "https://weblate.osgeo.org/api/units/99085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.708126Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "For relatively static databases, the basic pg_dump/pg_restore tools can be used to take periodic snapshots of the data." ], "previous_source": "", "target": [ "For relatively static databases, the basic pg_dump/pg_restore tools can be used to take periodic snapshots of the data." ], "id_hash": 5622080963934021257, "content_hash": 5622080963934021257, "location": "../../en/backup.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": 18, "source_unit": "https://weblate.osgeo.org/api/units/99088/?format=api", "priority": 100, "id": 99088, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=ce05a4d981c5e689", "url": "https://weblate.osgeo.org/api/units/99088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.732309Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "For frequently changing data, using an \"online backup\" scheme allows continuous archiving of updates to a secure location." ], "previous_source": "", "target": [ "For frequently changing data, using an \"online backup\" scheme allows continuous archiving of updates to a secure location." ], "id_hash": 5692296781219422447, "content_hash": 5692296781219422447, "location": "../../en/backup.rst:9", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/99091/?format=api", "priority": 100, "id": 99091, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=ceff19c370aee0ef", "url": "https://weblate.osgeo.org/api/units/99091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.757237Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Online backup is the basis for replication and stand-by systems for `high availability <http://www.postgresql.org/docs/current/static/high-availability.html>`_, particularly for versions of PostgreSQL >= 9.0." ], "previous_source": "", "target": [ "Online backup is the basis for replication and stand-by systems for `high availability <http://www.postgresql.org/docs/current/static/high-availability.html>`_, particularly for versions of PostgreSQL >= 9.0." ], "id_hash": -3721425701707436751, "content_hash": -3721425701707436751, "location": "../../en/backup.rst:11", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/99094/?format=api", "priority": 100, "id": 99094, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=4c5ad70a8fb82d31", "url": "https://weblate.osgeo.org/api/units/99094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.781057Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Laying Out your Data" ], "previous_source": "", "target": [ "Laying Out your Data" ], "id_hash": 3798015831275571873, "content_hash": 3798015831275571873, "location": "../../en/backup.rst:15", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99097/?format=api", "priority": 100, "id": 99097, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=b4b543469a7d8aa1", "url": "https://weblate.osgeo.org/api/units/99097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.847787Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "As discussed in :ref:`schemas`, ensuring that production data is always stored in separate schemas is a very important **best practice** in managing data. There are two reasons:" ], "previous_source": "", "target": [ "As discussed in :ref:`schemas`, ensuring that production data is always stored in separate schemas is a very important **best practice** in managing data. There are two reasons:" ], "id_hash": -6711182218833978754, "content_hash": -6711182218833978754, "location": "../../en/backup.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": 27, "source_unit": "https://weblate.osgeo.org/api/units/99100/?format=api", "priority": 100, "id": 99100, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=22dd17544f7b9a7e", "url": "https://weblate.osgeo.org/api/units/99100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.870875Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Backing up and restoring data in schemas is much simpler than managing lists of tables to be backed up individually." ], "previous_source": "", "target": [ "Backing up and restoring data in schemas is much simpler than managing lists of tables to be backed up individually." ], "id_hash": 2262676199606142330, "content_hash": 2262676199606142330, "location": "../../en/backup.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": 20, "source_unit": "https://weblate.osgeo.org/api/units/99104/?format=api", "priority": 100, "id": 99104, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=9f66a403ef41457a", "url": "https://weblate.osgeo.org/api/units/99104/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.893888Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Keeping data tables out of the \"public\" schema allows far easier upgrades, as discussed in :ref:`upgrades`." ], "previous_source": "", "target": [ "Keeping data tables out of the \"public\" schema allows far easier upgrades, as discussed in :ref:`upgrades`." ], "id_hash": -1494325207800976969, "content_hash": -1494325207800976969, "location": "../../en/backup.rst:20", "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": 16, "source_unit": "https://weblate.osgeo.org/api/units/99108/?format=api", "priority": 100, "id": 99108, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=6b4317240a1c69b7", "url": "https://weblate.osgeo.org/api/units/99108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.916515Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Basic Backup and Restore" ], "previous_source": "", "target": [ "Basic Backup and Restore" ], "id_hash": 3251321822323409626, "content_hash": 3251321822323409626, "location": "../../en/backup.rst:24", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99111/?format=api", "priority": 100, "id": 99111, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=ad1f03f89e1002da", "url": "https://weblate.osgeo.org/api/units/99111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.939176Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Backing up a full database is easy using the pg_dump_ utility. The utility is a command-line tool, which makes it easy to automate with scripting, and it can also be invoke via a GUI in the PgAdmin utility." ], "previous_source": "", "target": [ "Backing up a full database is easy using the pg_dump_ utility. The utility is a command-line tool, which makes it easy to automate with scripting, and it can also be invoke via a GUI in the PgAdmin utility." ], "id_hash": 8432481231420298607, "content_hash": 8432481231420298607, "location": "../../en/backup.rst:26", "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": 38, "source_unit": "https://weblate.osgeo.org/api/units/99114/?format=api", "priority": 100, "id": 99114, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=f5063100b5f4956f", "url": "https://weblate.osgeo.org/api/units/99114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.964468Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "To backup our ``nyc`` database, we can use the GUI, just right-click the database you want to backup:" ], "previous_source": "", "target": [ "To backup our ``nyc`` database, we can use the GUI, just right-click the database you want to backup:" ], "id_hash": 8905531356122767342, "content_hash": 8905531356122767342, "location": "../../en/backup.rst:28", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/99115/?format=api", "priority": 100, "id": 99115, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=fb96cd95b9ccdfee", "url": "https://weblate.osgeo.org/api/units/99115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.995095Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Enter the name of the backup file you want to create." ], "previous_source": "", "target": [ "Enter the name of the backup file you want to create." ], "id_hash": 6902346172962082417, "content_hash": 6902346172962082417, "location": "../../en/backup.rst:32", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/99116/?format=api", "priority": 100, "id": 99116, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=dfca0f462c2e8e71", "url": "https://weblate.osgeo.org/api/units/99116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.023332Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Note that there are three backup format options: compress, tar and plain." ], "previous_source": "", "target": [ "Note that there are three backup format options: compress, tar and plain." ], "id_hash": 2663450973677276280, "content_hash": 2663450973677276280, "location": "../../en/backup.rst:36", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/99117/?format=api", "priority": 100, "id": 99117, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=a4f67a8c8ab3cc78", "url": "https://weblate.osgeo.org/api/units/99117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.048597Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "**Plain** is just a textual SQL file. This is the simplest format and in many ways the most flexible, since it can be editing or altered easily and then loaded back into a database, allowing offline changes to things like ownership or other global information." ], "previous_source": "", "target": [ "**Plain** is just a textual SQL file. This is the simplest format and in many ways the most flexible, since it can be editing or altered easily and then loaded back into a database, allowing offline changes to things like ownership or other global information." ], "id_hash": 1105746993708849198, "content_hash": 1105746993708849198, "location": "../../en/backup.rst:38", "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": 45, "source_unit": "https://weblate.osgeo.org/api/units/99118/?format=api", "priority": 100, "id": 99118, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=8f5867084378d82e", "url": "https://weblate.osgeo.org/api/units/99118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.072744Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "**Tar** using a UNIX archive format to hold components of the dump in separate files. Using the tar format allows the pg_restore_ utility to selectively restore parts of the dump." ], "previous_source": "", "target": [ "**Tar** using a UNIX archive format to hold components of the dump in separate files. Using the tar format allows the pg_restore_ utility to selectively restore parts of the dump." ], "id_hash": -948098440346046944, "content_hash": -948098440346046944, "location": "../../en/backup.rst:39", "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": 30, "source_unit": "https://weblate.osgeo.org/api/units/99119/?format=api", "priority": 100, "id": 99119, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=72d7ad7de3126e20", "url": "https://weblate.osgeo.org/api/units/99119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.096898Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "**Compress** is like the Tar format, but compresses the internal components individually, allowing them to be selectively restored without decompressing the entire archive." ], "previous_source": "", "target": [ "**Compress** is like the Tar format, but compresses the internal components individually, allowing them to be selectively restored without decompressing the entire archive." ], "id_hash": 2894538837346564967, "content_hash": 2894538837346564967, "location": "../../en/backup.rst:40", "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": 23, "source_unit": "https://weblate.osgeo.org/api/units/99120/?format=api", "priority": 100, "id": 99120, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=a82b77bc949d3b67", "url": "https://weblate.osgeo.org/api/units/99120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.120670Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "We'll check the Compress option and go, saving out a backup file." ], "previous_source": "", "target": [ "We'll check the Compress option and go, saving out a backup file." ], "id_hash": -964719038951499805, "content_hash": -964719038951499805, "location": "../../en/backup.rst:42", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/99121/?format=api", "priority": 100, "id": 99121, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=729ca125373d57e3", "url": "https://weblate.osgeo.org/api/units/99121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.145585Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "The same operation can be done with the command line like this:" ], "previous_source": "", "target": [ "The same operation can be done with the command line like this:" ], "id_hash": 1289323833145355944, "content_hash": 1289323833145355944, "location": "../../en/backup.rst:44", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/99122/?format=api", "priority": 100, "id": 99122, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=91e49931f312eea8", "url": "https://weblate.osgeo.org/api/units/99122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.170554Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Because the backup file is in Compress format, we can view the contents using the pg_restore_ command to list the manifest. In the PgAdmin GUI, \"View\" is an option in the panel." ], "previous_source": "", "target": [ "Because the backup file is in Compress format, we can view the contents using the pg_restore_ command to list the manifest. In the PgAdmin GUI, \"View\" is an option in the panel." ], "id_hash": -3204405819799435235, "content_hash": -3204405819799435235, "location": "../../en/backup.rst:50", "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": 32, "source_unit": "https://weblate.osgeo.org/api/units/99123/?format=api", "priority": 100, "id": 99123, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=5387a9e272a9081d", "url": "https://weblate.osgeo.org/api/units/99123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.195879Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "When you look at the manifest, one of the things you might notice is that there are a lot of \"FUNCTION\" signatures in there." ], "previous_source": "", "target": [ "When you look at the manifest, one of the things you might notice is that there are a lot of \"FUNCTION\" signatures in there." ], "id_hash": 5921890340300857900, "content_hash": 5921890340300857900, "location": "../../en/backup.rst:54", "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": 24, "source_unit": "https://weblate.osgeo.org/api/units/99136/?format=api", "priority": 100, "id": 99136, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=d22ec7e39473222c", "url": "https://weblate.osgeo.org/api/units/99136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.218819Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "That's because the pg_dump_ utility dumps **every** non-system object in the database, and that includes the PostGIS function definitions." ], "previous_source": "", "target": [ "That's because the pg_dump_ utility dumps **every** non-system object in the database, and that includes the PostGIS function definitions." ], "id_hash": -5085465418438557424, "content_hash": -5085465418438557424, "location": "../../en/backup.rst:58", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/99150/?format=api", "priority": 100, "id": 99150, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=396ccc25586fc110", "url": "https://weblate.osgeo.org/api/units/99150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.241431Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "PostgreSQL 9.1+ includes an \"EXTENSION\" feature that allows add-on packages like PostGIS to be installed as registered system components and therefore excluded from pg_dump_ output. PostGIS 2.0 and higher support installation using this extension system." ], "previous_source": "", "target": [ "PostgreSQL 9.1+ includes an \"EXTENSION\" feature that allows add-on packages like PostGIS to be installed as registered system components and therefore excluded from pg_dump_ output. PostGIS 2.0 and higher support installation using this extension system." ], "id_hash": -669303462096508945, "content_hash": -669303462096508945, "location": "../../en/backup.rst:62", "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": 35, "source_unit": "https://weblate.osgeo.org/api/units/99163/?format=api", "priority": 100, "id": 99163, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=76b6280c1ecc67ef", "url": "https://weblate.osgeo.org/api/units/99163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.296958Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "We can see the same manifest from the command-line using pg_restore_ directly:" ], "previous_source": "", "target": [ "We can see the same manifest from the command-line using pg_restore_ directly:" ], "id_hash": 3445859264730166668, "content_hash": 3445859264730166668, "location": "../../en/backup.rst:64", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/99174/?format=api", "priority": 100, "id": 99174, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=afd226be8c3af58c", "url": "https://weblate.osgeo.org/api/units/99174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.323144Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "The problem with a dump file full of PostGIS function signatures is that we really wanted a dump of our data, not our system functions." ], "previous_source": "", "target": [ "The problem with a dump file full of PostGIS function signatures is that we really wanted a dump of our data, not our system functions." ], "id_hash": -8984658314356024178, "content_hash": -8984658314356024178, "location": "../../en/backup.rst:70", "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": 25, "source_unit": "https://weblate.osgeo.org/api/units/99187/?format=api", "priority": 100, "id": 99187, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=035014dda88c9c8e", "url": "https://weblate.osgeo.org/api/units/99187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.348499Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Since every object is in the dump file, we can restore to a blank database and get full functionality. In doing so, we are expecting that system we are restoring to has exactly the same version of PostGIS as the one we dumped from (since the function signature definitions reference a particular version of the PostGIS shared library)." ], "previous_source": "", "target": [ "Since every object is in the dump file, we can restore to a blank database and get full functionality. In doing so, we are expecting that system we are restoring to has exactly the same version of PostGIS as the one we dumped from (since the function signature definitions reference a particular version of the PostGIS shared library)." ], "id_hash": -1643655857246484973, "content_hash": -1643655857246484973, "location": "../../en/backup.rst:72", "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": 58, "source_unit": "https://weblate.osgeo.org/api/units/99189/?format=api", "priority": 100, "id": 99189, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=69308fb4cfd54613", "url": "https://weblate.osgeo.org/api/units/99189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.374173Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "From the command-line the restore looks like this:" ], "previous_source": "", "target": [ "From the command-line the restore looks like this:" ], "id_hash": 4678474097501100376, "content_hash": 4678474097501100376, "location": "../../en/backup.rst:74", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/99191/?format=api", "priority": 100, "id": 99191, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=c0ed4767706b5958", "url": "https://weblate.osgeo.org/api/units/99191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.397557Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Dumping just data, without function signatures, is where having data in schemas is handy, because there is a command-line flag to only dump a particular schema:" ], "previous_source": "", "target": [ "Dumping just data, without function signatures, is where having data in schemas is handy, because there is a command-line flag to only dump a particular schema:" ], "id_hash": -1073601795716961861, "content_hash": -1073601795716961861, "location": "../../en/backup.rst:81", "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": 26, "source_unit": "https://weblate.osgeo.org/api/units/99193/?format=api", "priority": 100, "id": 99193, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=7119ccdae011a9bb", "url": "https://weblate.osgeo.org/api/units/99193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.419918Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Now when we list the contents of the dump, we see just the data tables we wanted::" ], "previous_source": "", "target": [ "Now when we list the contents of the dump, we see just the data tables we wanted::" ], "id_hash": 8468896528795199300, "content_hash": 8468896528795199300, "location": "../../en/backup.rst:87", "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": 17, "source_unit": "https://weblate.osgeo.org/api/units/99195/?format=api", "priority": 100, "id": 99195, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=f5879085d6606744", "url": "https://weblate.osgeo.org/api/units/99195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.442735Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Having just the data tables is handy, because it means we can store to a database with any version of PostGIS installed, as we talk about in :ref:`upgrades`." ], "previous_source": "", "target": [ "Having just the data tables is handy, because it means we can store to a database with any version of PostGIS installed, as we talk about in :ref:`upgrades`." ], "id_hash": -2257864296665478936, "content_hash": -2257864296665478936, "location": "../../en/backup.rst:116", "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": 28, "source_unit": "https://weblate.osgeo.org/api/units/99197/?format=api", "priority": 100, "id": 99197, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=60aa7462863788e8", "url": "https://weblate.osgeo.org/api/units/99197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.465160Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Backing Up Users" ], "previous_source": "", "target": [ "Backing Up Users" ], "id_hash": 8897736381896368417, "content_hash": 8897736381896368417, "location": "../../en/backup.rst:120", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/99206/?format=api", "priority": 100, "id": 99206, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=fb7b1c18dc00a121", "url": "https://weblate.osgeo.org/api/units/99206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.490195Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "The pg_dump_ utility operates a database at a time (or a schema or table at a time, if you restrict it). However, information about users is is stored across an entire cluster, it's not stored in any one database!" ], "previous_source": "", "target": [ "The pg_dump_ utility operates a database at a time (or a schema or table at a time, if you restrict it). However, information about users is is stored across an entire cluster, it's not stored in any one database!" ], "id_hash": 3930894239852484080, "content_hash": 3930894239852484080, "location": "../../en/backup.rst:122", "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": 39, "source_unit": "https://weblate.osgeo.org/api/units/99221/?format=api", "priority": 100, "id": 99221, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=b68d577c000955f0", "url": "https://weblate.osgeo.org/api/units/99221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.517363Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "To backup your user information, use the pg_dumpall_ utility, with the \"--globals-only\" flag." ], "previous_source": "", "target": [ "To backup your user information, use the pg_dumpall_ utility, with the \"--globals-only\" flag." ], "id_hash": 7742657011311145560, "content_hash": 7742657011311145560, "location": "../../en/backup.rst:124", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/99226/?format=api", "priority": 100, "id": 99226, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=eb73718788e37258", "url": "https://weblate.osgeo.org/api/units/99226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.542414Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "You can also use pg_dumpall_ in its default mode to backup an entire cluster, but be aware that, as with pg_dump_, you will end up backing up the PostGIS function signatures, so the dump will have to be restored against an identical software installation, it can't be used as part of an upgrade process." ], "previous_source": "", "target": [ "You can also use pg_dumpall_ in its default mode to backup an entire cluster, but be aware that, as with pg_dump_, you will end up backing up the PostGIS function signatures, so the dump will have to be restored against an identical software installation, it can't be used as part of an upgrade process." ], "id_hash": 5018427884710390458, "content_hash": 5018427884710390458, "location": "../../en/backup.rst:130", "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": 54, "source_unit": "https://weblate.osgeo.org/api/units/99228/?format=api", "priority": 100, "id": 99228, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=c5a509928713eaba", "url": "https://weblate.osgeo.org/api/units/99228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.570137Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Online Backup and Restore" ], "previous_source": "", "target": [ "Online Backup and Restore" ], "id_hash": -1803950157513093282, "content_hash": -1803950157513093282, "location": "../../en/backup.rst:134", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99230/?format=api", "priority": 100, "id": 99230, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=66f714e3b4ec0f5e", "url": "https://weblate.osgeo.org/api/units/99230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.597841Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Online backup and restore allows an administrator to keep an extremely up-to-date set of backup files without the overhead of repeatedly dumping the entire database. If the database is under frequent insert and update load, then online backup might be preferable to basic backup." ], "previous_source": "", "target": [ "Online backup and restore allows an administrator to keep an extremely up-to-date set of backup files without the overhead of repeatedly dumping the entire database. If the database is under frequent insert and update load, then online backup might be preferable to basic backup." ], "id_hash": 313291041433259939, "content_hash": 313291041433259939, "location": "../../en/backup.rst:136", "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": 44, "source_unit": "https://weblate.osgeo.org/api/units/99243/?format=api", "priority": 100, "id": 99243, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=8459088ad3f10fa3", "url": "https://weblate.osgeo.org/api/units/99243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.620494Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "The best way to learn about online backup is to read the relevant sections of the PostgreSQL manual on `continuous archiving and point-in-time recovery <http://www.postgresql.org/docs/current/static/continuous-archiving.html>`_. This section of the PostGIS workshop will just provide a brief snapshot of online backup set-up." ], "previous_source": "", "target": [ "The best way to learn about online backup is to read the relevant sections of the PostgreSQL manual on `continuous archiving and point-in-time recovery <http://www.postgresql.org/docs/current/static/continuous-archiving.html>`_. This section of the PostGIS workshop will just provide a brief snapshot of online backup set-up." ], "id_hash": -6767057829578074528, "content_hash": -6767057829578074528, "location": "../../en/backup.rst:140", "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": 41, "source_unit": "https://weblate.osgeo.org/api/units/99258/?format=api", "priority": 100, "id": 99258, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=221694c1e5791660", "url": "https://weblate.osgeo.org/api/units/99258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.643252Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "How it Works" ], "previous_source": "", "target": [ "How it Works" ], "id_hash": 1389941602316059967, "content_hash": 1389941602316059967, "location": "../../en/backup.rst:144", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/99270/?format=api", "priority": 100, "id": 99270, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=934a1085e896053f", "url": "https://weblate.osgeo.org/api/units/99270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.666229Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Rather than continually write to the main data tables, PostgreSQL stores changes initially in \"write-ahead logs\" (WAL). Taken together, these logs are a complete record of all changes made to a database. Online backup consists of taking a copy of the database main data table, then taking a copy of each WAL that is generated from then on." ], "previous_source": "", "target": [ "Rather than continually write to the main data tables, PostgreSQL stores changes initially in \"write-ahead logs\" (WAL). Taken together, these logs are a complete record of all changes made to a database. Online backup consists of taking a copy of the database main data table, then taking a copy of each WAL that is generated from then on." ], "id_hash": 5196816508840785135, "content_hash": 5196816508840785135, "location": "../../en/backup.rst:146", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://weblate.osgeo.org/api/units/99282/?format=api", "priority": 100, "id": 99282, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=c81ecd14b45734ef", "url": "https://weblate.osgeo.org/api/units/99282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.688872Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "When it is time to recover to a new database, the system starts on the main data copy, then replays all the WAL files into the database. The end result is a restored database in the same state as the original at the time of the last WAL received." ], "previous_source": "", "target": [ "When it is time to recover to a new database, the system starts on the main data copy, then replays all the WAL files into the database. The end result is a restored database in the same state as the original at the time of the last WAL received." ], "id_hash": -5253922151113745209, "content_hash": -5253922151113745209, "location": "../../en/backup.rst:150", "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": 49, "source_unit": "https://weblate.osgeo.org/api/units/99299/?format=api", "priority": 100, "id": 99299, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=371651a3d94f1cc7", "url": "https://weblate.osgeo.org/api/units/99299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.713411Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Because WAL are being written anyways, and transferring copies to an archive server is computationally cheap, online backup is an effective means of keeping a very up-to-date backup of a system without resorting to intensive regular full dumps." ], "previous_source": "", "target": [ "Because WAL are being written anyways, and transferring copies to an archive server is computationally cheap, online backup is an effective means of keeping a very up-to-date backup of a system without resorting to intensive regular full dumps." ], "id_hash": 3710021996798607418, "content_hash": 3710021996798607418, "location": "../../en/backup.rst:152", "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/99314/?format=api", "priority": 100, "id": 99314, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=b37ca5597c11003a", "url": "https://weblate.osgeo.org/api/units/99314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.735414Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Archiving the WAL Files" ], "previous_source": "", "target": [ "Archiving the WAL Files" ], "id_hash": 471029943599778803, "content_hash": 471029943599778803, "location": "../../en/backup.rst:156", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99321/?format=api", "priority": 100, "id": 99321, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=86896f3cf2d64bf3", "url": "https://weblate.osgeo.org/api/units/99321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.757660Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "The first thing to do in setting up online backup is to create an archiving method. PostgreSQL archiving methods are the ultimate in flexibility: the PostgreSQL backend simply calls a script specified in the ``archive_command`` configuration parameter." ], "previous_source": "", "target": [ "The first thing to do in setting up online backup is to create an archiving method. PostgreSQL archiving methods are the ultimate in flexibility: the PostgreSQL backend simply calls a script specified in the ``archive_command`` configuration parameter." ], "id_hash": -1419904401942882956, "content_hash": -1419904401942882956, "location": "../../en/backup.rst:158", "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": 37, "source_unit": "https://weblate.osgeo.org/api/units/99323/?format=api", "priority": 100, "id": 99323, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=6c4b7c782b2e5574", "url": "https://weblate.osgeo.org/api/units/99323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.780308Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "That means archiving can be as simple as copying the file to a network-mounted drive, and as complex as encrypting and emailing the files to the remote archive. Any process you can script you can use to archive the files." ], "previous_source": "", "target": [ "That means archiving can be as simple as copying the file to a network-mounted drive, and as complex as encrypting and emailing the files to the remote archive. Any process you can script you can use to archive the files." ], "id_hash": -6483646630676712136, "content_hash": -6483646630676712136, "location": "../../en/backup.rst:160", "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": 40, "source_unit": "https://weblate.osgeo.org/api/units/99325/?format=api", "priority": 100, "id": 99325, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=260575bdc15b3538", "url": "https://weblate.osgeo.org/api/units/99325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.804576Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "To turn on archiving we will edit ``postgresql.conf``, first turning on WAL archiving:" ], "previous_source": "", "target": [ "To turn on archiving we will edit ``postgresql.conf``, first turning on WAL archiving:" ], "id_hash": -9011585759261843624, "content_hash": -9011585759261843624, "location": "../../en/backup.rst:162", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/99340/?format=api", "priority": 100, "id": 99340, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=02f06a7f543a9f58", "url": "https://weblate.osgeo.org/api/units/99340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.827239Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "And then setting the ``archive_command`` to copy our archive files to a safe location (changing the destination paths as appropriate):" ], "previous_source": "", "target": [ "And then setting the ``archive_command`` to copy our archive files to a safe location (changing the destination paths as appropriate):" ], "id_hash": -71135257880398382, "content_hash": -71135257880398382, "location": "../../en/backup.rst:169", "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": 20, "source_unit": "https://weblate.osgeo.org/api/units/99356/?format=api", "priority": 100, "id": 99356, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=7f0346dc1f0875d2", "url": "https://weblate.osgeo.org/api/units/99356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.850905Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "It is important that the archive command not over-write existing files, so the unix command includes an initial test to ensure that the files aren't already there. It is also important that the command returns a non-zero status if the copy process fails." ], "previous_source": "", "target": [ "It is important that the archive command not over-write existing files, so the unix command includes an initial test to ensure that the files aren't already there. It is also important that the command returns a non-zero status if the copy process fails." ], "id_hash": -6296444013606433830, "content_hash": -6296444013606433830, "location": "../../en/backup.rst:179", "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": 43, "source_unit": "https://weblate.osgeo.org/api/units/99368/?format=api", "priority": 100, "id": 99368, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=289e898794da8bda", "url": "https://weblate.osgeo.org/api/units/99368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.873324Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Once the changes are made you can re-start PostgreSQL to make them effective." ], "previous_source": "", "target": [ "Once the changes are made you can re-start PostgreSQL to make them effective." ], "id_hash": 881890377746076395, "content_hash": 881890377746076395, "location": "../../en/backup.rst:181", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/99385/?format=api", "priority": 100, "id": 99385, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=8c3d1aa04863d2eb", "url": "https://weblate.osgeo.org/api/units/99385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.898520Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Taking the Base Backup" ], "previous_source": "", "target": [ "Taking the Base Backup" ], "id_hash": -5085828726041494528, "content_hash": -5085828726041494528, "location": "../../en/backup.rst:185", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/99400/?format=api", "priority": 100, "id": 99400, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=396b81b833d1bc00", "url": "https://weblate.osgeo.org/api/units/99400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.921851Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/backup/en/?format=api", "source": [ "Once the archiving process is in place, you need to take a base back-up." ], "previous_source": "", "target": [ "Once the archiving process is in place, you need to take a base back-up." ], "id_hash": 1403673164885298085, "content_hash": 1403673164885298085, "location": "../../en/backup.rst:187", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/99414/?format=api", "priority": 100, "id": 99414, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/backup/en/?checksum=937ad94e75bc8ba5", "url": "https://weblate.osgeo.org/api/units/99414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.946006Z" } ] }