{"guid":"33f1ee15-b584-4dc2-94d4-b593dfb428de","title":"Wie PostgreSQL Eure Daten Sicher Hält","subtitle":null,"slug":"froscon2019-2432-wie_postgresql_eure_daten_sicher_halt","link":"https://programm.froscon.de/2019/events/2432.html","description":"PostgreSQL ist für seine Datensicherheit berühmt - die Entwickler legen größten Wert darauf, dass die von ihm verwalteten Nutzerdaten nicht verloren gehen. Trotzdem kann es auf Grund defekter Hardware, Betriebssystem-Fehlern oder (selten aber vorkommend) PostgreSQL-Problemen zu Datenverlust kommen.\n\nDieser Vortrag bietet eine Übersicht über die Sicherheits-Vorrichtungen von PostgreSQL. Außerdem werden die zur Verfügung stehenden zusätzlichen Möglichkeiten zur Erhöhung der Datensicherheit besprochen. Hierzu gehören die Verwendung von Checksummen, die Validierung von Backups oder der Einsatz von Programmen zur Erkennung von Daten-Inkonsistenzen.","original_language":"deu","persons":["Michael Banck"],"tags":["froscon2019","2432","Databases"],"view_count":131,"promoted":false,"date":"2019-08-11T00:00:00.000+02:00","release_date":"2019-08-11T02:00:00.000+02:00","updated_at":"2025-11-19T16:30:03.891+01:00","length":3329,"duration":3329,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2019/2432-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2019/2432-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2019/2432-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2019/2432-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2019-2432-wie_postgresql_eure_daten_sicher_halt","url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_title":"FrOSCon 2019","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019","related":[{"event_id":7040,"event_guid":"40829380-cbd9-414e-8afe-b51c12d5e721","weight":1},{"event_id":7268,"event_guid":"7007a0ab-a90c-4c5a-8ff2-e9faa6eba646","weight":4},{"event_id":7281,"event_guid":"bb5b04bd-9599-4d93-bd12-c779f381cf5e","weight":4},{"event_id":7285,"event_guid":"71c15227-527d-40e4-96c0-e04e2b218422","weight":5},{"event_id":7286,"event_guid":"a2f61e35-bf54-4cf9-9362-e4d04fa94915","weight":5},{"event_id":7296,"event_guid":"b8424140-1639-44f7-a19a-67af58ad61e9","weight":4},{"event_id":7297,"event_guid":"e3cbd7a8-c747-42e3-93c3-990adb6d6c0e","weight":4},{"event_id":7300,"event_guid":"b3ce0272-f184-416d-ada2-07441237e632","weight":1},{"event_id":7312,"event_guid":"d140d6af-5f70-4dca-aea7-1019989e4f76","weight":3},{"event_id":7320,"event_guid":"403c633e-a16a-43d1-bce3-a16803851408","weight":4},{"event_id":7325,"event_guid":"9279d4b2-71f4-4b6a-8b65-d40cdeb75b1a","weight":5},{"event_id":7332,"event_guid":"50ad5991-1b2f-4a92-ba87-dec6456f085a","weight":5},{"event_id":7334,"event_guid":"4bd45e4a-c05c-4804-b879-4b793b7fca4e","weight":4},{"event_id":7343,"event_guid":"212468fa-72ee-4d11-a32e-56d5e6fd78a3","weight":6},{"event_id":7351,"event_guid":"ca5e5930-ca47-41c9-b85d-73475fb75edb","weight":3},{"event_id":7355,"event_guid":"a160f9d4-663b-4237-b56a-20d065ade180","weight":2}],"recordings":[{"size":633,"length":3329,"mime_type":"video/mp4","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-11T16:38:28.291+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/h264-hd/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_hd.mp4","url":"https://api.media.ccc.de/public/recordings/36948","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":32,"length":3329,"mime_type":"audio/opus","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-11T16:40:58.092+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/opus/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_opus.opus","url":"https://api.media.ccc.de/public/recordings/36950","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":50,"length":3329,"mime_type":"audio/mpeg","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-11T16:41:34.454+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/mp3/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/36951","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":135,"length":3329,"mime_type":"video/mp4","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-11T16:54:36.872+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/h264-sd/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_sd.mp4","url":"https://api.media.ccc.de/public/recordings/36958","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":212,"length":3329,"mime_type":"video/webm","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-11T17:07:38.850+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/webm-sd/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/36959","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":723,"length":3329,"mime_type":"video/webm","language":"deu","filename":"froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-11T17:40:47.302+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/webm-hd/froscon2019-2432-deu-Wie_PostgreSQL_Eure_Daten_Sicher_Haelt_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/36962","event_url":"https://api.media.ccc.de/public/events/33f1ee15-b584-4dc2-94d4-b593dfb428de","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"}]}