ProBackup: fast, reliable, and incremental
Modern state of backup tools for PostgreSQL certainly leaves some room for improvements. Standard utilities provides only basic functionality, third-party tools solve some, but not all, problems. To take backups reliably, fast, and incrementally on page level, one needs not only a backup tool, but also some support from the database server. On this tutorial we will talk about our new backup and recovery manager ProBackup, and will show it in action.
Demonstration script:
Слайды
Видео
Другие доклады
-
Philip Delgyado ООО «Лектон»
Complex structures without ORM
I love complex knowledge domains, strong typing in applications, and 3NF, but I hate ORM. That is why I’ve been actively storing serialized structures in JSON fields (even before the JSON type was introduced). In this talk, I will tell you about some specifics of storing complex structures within DBMS fields, what problems can arise, and how to cushion the blow.
VIDEO
-
Dmitry Vasilyev Postgres Professional
Mamonsu – a Swiss Army knife for managing and monitoring PostgreSQL
This tutorial shows how to properly monitor PostgreSQL. We will discuss the mamonsu utility, see how to configure it, examine its hidden features and learn how to extend them.
-
Anton Doroshkevich ИнфоСофт
PostgreSQL – a real alternative for high-load 1C-based systems
- Why is it time to consider switching to PostgreSQL?
- 1С and PostgreSQL interoperability.
- Why should we start with Windows?
- The first experience of migrating big enough 1С databases to Postgres.
- Large-scale projects on high-load systems, in figures.