I Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest and How to Use it for PITR

Speakers:  Charly Batista

I Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest and How to Use it for PITR

This session was presented on Percona Community Live Online June 21-23, 2022. Check out the full schedule here.

We live in a dangerous world and a catastrophe can happen at any time, including in our database. We can have a hardware failure, software failure, malicious software, or a human error and find ourselves with a data loss. While we work hard to prevent all those some are just not under our control and we cannot rely on luck, we need strategy and methods to be able to recover the maximum data we can in case a catastrophic event happens and this is what we will discuss during this talk. How to survive catastrophic events and recover data back!

Watch Video Here

Link: https://youtu.be/AbYBlTomQus

Transcript

Speakers

Charly Batista

Percona, PostgreSQL Tech Lead

Charly Batista is currently PostgreSQL Tech Lead at Percona. Possesses over twelve (12) years of experience in various areas of IT including Database Administration, Data Analysis, Systems Analysis and Software Development. Strong analytical skills combined with experience in object oriented programming techniques. Technical Leader for more than four (4) years for the Developer Team. Born in Brazil and now living in Shanghai-China.

See all talks by Charly Batista »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Read more »

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

In this episode, Joe Brockmeier interviews benny Vasquez of the AlmaLinux Project to discuss open source data, the future of databases, and how databases and Linux distros go together.

Read more »

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

In this episode, Joe Brockmeier talks to Percona’s Sonia Valeja and David Gonzalez, about their recent book PostgreSQL for Jobseekers. They talk about the inspiration for the book, why they focus on jobseekers, and what’s covered in the title.

Read more »

✎ Edit this page on GitHub