talks and workshop sessions
PostgreSQL backup overview for DBA and programmersAlexander Burtsev Abstract:
How to start career as an DBMS developer and understand issues of backup tools with real examples from every day routine of our development team.
Talk will focus on following:
Why backups are important?
Why replica is not backup?
Recognize use-cases for logical and physical replications
The cost of lost data
Developing a simple QA script for automatization DBA routine
Backups approaches, incremental copies to speed up your backups
Backup round-trip: compression and concurrency
Where DBMS developer career starts if you like security and accuracy
How different backup tools resolve trilemma: backup, speed up backup round-trip, restore faster and accurate
Where is the simplest path to start contributing in Open Source?
Where the magic never ends for programmers.
Alexander works as Lead Technical Product Manager of backup systems, compression and cryptography algorithms at Postgres Professional.
My career started as a system programmer in C/C++ and QA-automation in 2006. He has designed and implemented architecture of a famous sports and economics news media in Russia. Also, He developed and launched more 10 startups in advertising, finance, ecommerce and blockchain fields.
Speaking about Postgres Pro, he prefer to dive deeper into backup and disaster recovery of DBMS. He manages pg_probackup community and maintain Testgres - the project for simplifying automation DBA scenarios using Python.