Sign in to confirm you’re not a bot
This helps protect our community. Learn more

You Don't Need a Database Backup Policy | POSETTE 2024

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
375 views 10 months ago #PostgreSQL #Database #PosetteConf
Video of a conference talk about why you don't need a database backup policy presented by Karen Jex at POSETTE: An Event for Postgres 2024. I can hear what you’re thinking: “Don’t be ridiculous, Karen! Of course I need a database backup policy. All hell will break loose if I don’t backup my Postgres databases. Hear me out. A backup policy specifies things like type and frequency of backups, backup tool(s), backup storage and retention. But how do you decide those things? Finger in the air? Copy what you put in place for your other Postgres databases? Since the primary goal of backing up your Postgres databases is probably to recover data in case of failure, it makes more sense to consider the types of failure you need to be able to recover from, how quickly you need to recover, and how much data you can afford to lose. The answers to these recovery-based questions will determine how and when you take backups. In this talk, we’ll look at the di …...more
...more
You Don't Need a Database Backup Policy | POSETTE 2024
13Likes
375Views
Jun 132024
Video of a conference talk about why you don't need a database backup policy presented by Karen Jex at POSETTE: An Event for Postgres 2024. I can hear what you’re thinking: “Don’t be ridiculous, Karen! Of course I need a database backup policy. All hell will break loose if I don’t backup my Postgres databases. Hear me out. A backup policy specifies things like type and frequency of backups, backup tool(s), backup storage and retention. But how do you decide those things? Finger in the air? Copy what you put in place for your other Postgres databases? Since the primary goal of backing up your Postgres databases is probably to recover data in case of failure, it makes more sense to consider the types of failure you need to be able to recover from, how quickly you need to recover, and how much data you can afford to lose. The answers to these recovery-based questions will determine how and when you take backups. In this talk, we’ll look at the different things you need to consider in order to be confident in your ability to recover your Postgres database from disaster. Karen was a database administrator for over 20 years and was once described as "quite personable for a DBA", which she decided to take as a compliment! She's now a Senior Solutions Architect, helping her customers to design and manage their (PostgreSQL) database environments. Karen is on the PostgreSQL Europe board, co-organises the pgDay Paris event and helps out as a volunteer at other PostgreSQL community events. Karen gives talks about databases at PostgreSQL and developer conferences because she loves sharing knowledge. Chapters: 00:00 - Intro 01:04 - What is a Database Backup Policy 02:03 - Why take backups 03:45 - What are your recovery requirements? 06:21 - Backup methods 12:38 - Backup tools 14:15 - Creating a disaster recovery policy 14:41 - Recovery requirements 15:38 - Responsibilities 15:59 - Recovery procedures 22:10 - Test each scenario 22:43 - Backup strategy 23:35 - Monitoring policy 24:35 - Ongoing testing & monitoring of your disaster recovery policy 26:59 - Conclusions 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe #PosetteConf #PostgreSQL #Database Presenters: Karen Jex, Senior Solutions Architect at Crunchy Data Connect: Karen Jex: https://mastodon.online/@karenhjex,   / karenhjex  ,   / karenhjex  

Follow along using the transcript.

Microsoft Developer

588K subscribers