Where the open-source database community meets: Secure your spot at PerconaLive.com
Back to all talks

Logical vs Physical Backups: Choosing the right one

Event: FOSSASIA Summit 2026

Location: Bangkok

Dates: March 9, 2026 – March 10, 2026

Presentation: March 10, 2026

Link: On event website

Speaker: Sonia Valeja

We’ll start by defining what logical backups are and explore when they shine—like selective restores, version upgrades, and lightweight migrations. Then we’ll look at the flip side: where logical backups fail under scale, performance pressure, and complex workloads. Next, we’ll break down physical backups: what they are, why they’re the gold standard for full cluster recovery, and the scenarios where they deliver unbeatable speed and reliability. We’ll also highlight the practical challenges and risks that come with physical backups. Finally, we’ll compare both approaches side-by-side and close with clear, actionable guidance on how to choose the best strategy—or combination—for your environment.

Event

Speaker card

Logical vs Physical Backups: Choosing the right one

Speakers

Sonia Valeja

Sonia Valeja

Sonia is data enthusiast who started working in PostgreSQL in the year 2012. Since she has performed multiple migrations from Oracle to PostgreSQL, she learnt Oracle while working with PostgreSQL. She is a SME for beginner-level course on Open Source Database-PostgreSQL in one of her previous company. She has conducted multiple trainings on PostgreSQL for freshers as well as experienced professionals. Also, she has been an active participant at pgConf and has given lightning talk. She has worked extensively in Taxation as well as manufacturing based projects for Indian as well as African sub- continent.

View full profile ›